Microsoft KB Archive/25492

{|
 * width="100%"|

Excel: Moving Between Unlocked Cells in Protected Worksheet

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, versions 3.x, 4.x, 5.0, 5.0c
 * Microsoft Excel for Windows, 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 :

Technology :