Microsoft KB Archive/95077

= Microsoft Knowledge Base =

Excel: Freeze Panes Splits Window through Center
Last reviewed: September 12, 1996

Article ID: Q95077

The information in this article applies to:


 * Microsoft Excel for Windows, version 4.0
 * Microsoft Excel for the Macintosh, version 4.0

SUMMARY
Pages 39 and 48 of the version 4.0 &quot;Microsoft Excel User's Guide 1,&quot; state that by choosing the Freeze Panes command from the Window menu, Microsoft Excel automatically splits the worksheet window into panes crossing at the top-left corner of the active cell and freezes the panes.

This statement is only partially true: if you choose Freeze Panes from the Window menu when the active cell(s) are not displayed, the panes will be frozen with the vertical and horizontal panes intersecting at the center of the active window, not at top-left the corner of the active cell.

MORE INFORMATION
This behavior is by design.

This behavior does not exist in earlier versions of Microsoft Excel. In versions of Microsoft Excel earlier than 4.0, the Freeze Panes option is unavailable (dimmed) until you use the Split tool to split your spreadsheet into panes. At that point, you can use the Freeze Panes option to freeze the panes at the position where you split your window.