Microsoft KB Archive/117128

= XL: Hidden Cells in a Worksheet May Become Unhidden =

Article ID: 117128

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition
 * Microsoft Excel 2002 Standard Edition
 * Microsoft Excel 97 Standard Edition
 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel 5.0 Standard Edition
 * Microsoft Excel 5.0c
 * Microsoft Excel 5.0 Standard Edition

-



This article was previously published under Q117128





SYMPTOMS
In Microsoft Excel, hidden cells in a worksheet may become unhidden if all of the following conditions are true:
 * There is at least one hidden row or column in the worksheet.

-and-
 * The Transition navigation keys check box is selected.

-and-
 * You are creating a formula on another worksheet or workbook using Point mode, and you select a cell on the worksheet.



WORKAROUND
To keep cells from becoming unhidden, do the following to turn the Transition navigation keys option off:
 * 1) On the Tools menu, click Options, and then click the Transition tab.
 * 2) Under Settings, click to clear the Transition navigation keys check box.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem does not occur in versions of Microsoft Excel for the Macintosh.



MORE INFORMATION
Point mode is a data entry mode that lets you create a formula by selecting cells with the mouse or keyboard. The status bar will display the word "Point" in the lower-left corner when you are in this mode. For example, in Point mode, if you activate a cell and press = (the equal sign), you can select another cell by pressing the arrow keys on the keyboard or selecting a cell with your mouse.

Keywords: kbprb KB117128

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.