Tip Printed from ExcelTip.com

---

Moving Between Unprotected Cells in a Protected Sheet


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).