Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

XL: Hidden Cells in a Worksheet May Become Unhidden

View products that this article applies to.

This article was previously published under Q117128

↑ Back to the top


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.

  • The Transition navigation keys check box is selected.

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

↑ Back to the top


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.

↑ Back to the top


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.

↑ Back to the top

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.

↑ Back to the top

Keywords: KB117128, kbprb

↑ Back to the top

Article Info
Article ID : 117128
Revision : 5
Created on : 1/19/2007
Published on : 1/19/2007
Exists online : False
Views : 512