» Moving Between Unprotected Cells in a Protected Sheet

CATEGORY - Excel Security - Protection VERSION - All Microsoft Excel Versions

Using keyboard shortcuts

To move between unprotected cells in a protected Sheet:

Press Tab to move between unprotected cells in a protected sheet.

Example:

In the screenshot below, the colored cells (containing formulas) are protected. Press Tab to move between unprotected cells (the uncolored cells).
Screenshot // Moving Between Unprotected Cells in a Protected Sheet