Microsoft KB Archive/87496

= Microsoft Knowledge Base =

Excel: Frozen Panes Causes Change in HOME Key Functionality
Last reviewed: July 16, 1997

Article ID: Q87496

The information in this article applies to:


 * Microsoft Excel for Windows, versions 4.0, 4.0a, 5.0
 * Microsoft Excel for the Macintosh, versions 4.0, 5.0

SUMMARY
If a vertical split is present and panes have been frozen in version 4.0 of Microsoft Excel, the HOME key no longer returns the active cell to column A of the current row, as it did in Excel 3.0.

MORE INFORMATION
In version 4.0 of Microsoft Excel, if a vertical split is present and panes are frozen, the HOME key no longer returns the active cell to column A of the row of the active cell. Excel places the active cell in the column to the right of the vertical split line in the row the active cell is in.

Also, CTRL+HOME no longer returns the active cell to cell A1 in a sheet which is split and the panes are frozen. CTRL+HOME places the active cell in the upper left cell of the right, bottom, or bottom right pane depending on whether the window is split vertically, horizontally, or both, respectively.