XL: Hidden Cells in a Worksheet May Become Unhidden (117128)
The information in this article applies to:
- Microsoft Excel 2000
- Microsoft Excel 2002
- Microsoft Excel 97 for Windows
- Microsoft Excel for Windows 95
- Microsoft Excel for Windows 5.0
- Microsoft Excel for Windows 5.0c
- Microsoft Excel for Windows NT 5.0
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:
- On the Tools menu, click Options, and then click the Transition tab.
- Under Settings, click to clear the Transition navigation keys check box.
STATUSMicrosoft 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.
| Modification Type: | Minor | Last Reviewed: | 8/15/2005 |
|---|
| Keywords: | kbprb KB117128 |
|---|
|