Excel: Moving Between Unlocked Cells in Protected Worksheet

• Microsoft Excel for Windows, versions 3.x, 4.x, 5.0, 5.0c
• Microsoft Excel for Windows 95, version 7.0
• Microsoft Excel for the Macintosh, versions 1.x, 2.2, 3.0, 4.0, 5.0, 5.0a

SUMMARY

In a protected Microsoft Excel document, you can select any cell (locked or unlocked) on the worksheet by using the mouse to click the cell. To cycle through the unlocked cells in a protected worksheet, press the TAB key.

MORE INFORMATION

If the worksheet is protected, you can select the next available unlocked cell by pressing the TAB key. Microsoft Excel will select the next unlocked cell that is to the right or below the active cell. If there is no unlocked cell to the right or below the active cell, then the top-left unlocked cell in the worksheet is selected.

NOTE: If you are using Microsoft Excel for the Macintosh, you can use either the TAB key or the ENTER key (on the numeric keypad) to cycle through unlocked cells.

Additional query words: howto 2.20 4.00 5.00a 5.00c

Keywords :
Version :
Platform :
Issue type :