XL2000: Cannot Use Keyboard to Move to Partially Hidden Merged Cells (212097)



The information in this article applies to:

  • Microsoft Excel 2000

This article was previously published under Q212097

SYMPTOMS

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.

CAUSE

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.

WORKAROUND

To select partially hidden merged cells, click in them or use the Go To command on the Edit menu.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

REFERENCES

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.

Modification Type:MajorLast Reviewed:11/5/2003
Keywords:kbbug kbpending KB212097