Excel: Moving Between Unlocked Cells in Protected Worksheet

 Last reviewed: October 16, 1995
Article ID: Q25492
The information in this article applies to:
  • Microsoft Excel for Windows, version 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.

KBCategory: kbusage
KBSubcategory:

Additional reference words: howto 1.x 2.20 3.00 4.00 5.00 5.00a 5.00c 7.00

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: October 16, 1995
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.