Microsoft KB Archive/172823

= XL97: Can't Move to Partially Hidden Merged Cells with Keyboard =

Article ID: 172823

Article Last Modified on 10/19/2000

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q172823





SYMPTOMS
In Microsoft Excel 97, you cannot use the TAB key or arrow keys to move to partially hidden, merged cells from a cell that is adjacent to the merged cells. When you try to move to the merged cells, the active cell becomes the first unmerged cell that is adjacent to the merged cells.



CAUSE
This problem may occur after you merge cells in Microsoft Excel 97 and hide the column or row that is the top, bottom, leftmost, or rightmost portion of the merged cells.



WORKAROUND
You can select partially hidden merged cells if you use the pointer to click them or use the Go To command on the Edit Menu.



STATUS
Microsoft has confirmed this to be a problem in Microsoft Excel 97 for Windows.

