In Microsoft Excel, you cannot use the TAB or arrow keys to move to a partially hidden merged cell from an adjacent cell. When you try to move to the merged cell, the first unmerged cell adjacent to it becomes active.
↑ Back to the top
This problem can occur after you merge cells and hide the column or row that is the top, bottom, leftmost, or rightmost portion of the merged cells.
↑ Back to the top
To select partially hidden merged cells, click in them or use the Go To command on the Edit menu.
↑ 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.
↑ Back to the top
For more information about merging cells, click Microsoft Excel Help on the Help menu, type merge cells to span several columns or rows in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
↑ Back to the top