Freezing a Column or Row


Large worksheets can be difficult to work with, especially on low-resolution or small monitor screens. If you scroll down to see the bottom of the list, you can no longer see the column names at the top of the list. Instead of repeatedly scrolling up and down, you can temporarily set, or freeze , those column or row headings so that you can see them no matter where you scroll in the list. When you freeze a row or column, you are actually splitting the screen into one or more panes (window sections) and freezing one of the panes. You can split the screen into up to four panes and can freeze up to two of these panes. You can edit the data in a frozen pane just as you do any Excel data, but the cells remain stationary even when you use the scroll bars; only the unfrozen part of the screen scrolls .

Freeze a Column or Row

graphics/one_icon.jpg Select the column to the right of the columns you want to freeze, or select the row below the rows you want to freeze.

To freeze both, click the cell to the right and below of the column and row you want to freeze.


Click the Window menu, and then click Freeze Panes.

  • When you freeze a pane horizontally, all the rows above the active cell freeze. When you freeze a pane vertically, all the columns to the left of the active cell freeze.

  • When you freeze a pane, it has no effect on how a worksheet looks when printed.


Unfreeze a Column or Row


Click the Window menu.


Click Unfreeze Panes.


Show Me Microsoft Office Excel 2003
Show Me Microsoft Office Excel 2003
ISBN: 0789730057
EAN: 2147483647
Year: 2002
Pages: 291 © 2008-2017.
If you may any questions please contact us: