Microsoft Office Tutorials and References
In Depth Information
Fixed Headings with Freeze Panes
By dividing the worksheet into four panes between rows 2 and 3 and columns
A and B and then freezing them on the screen, you can keep the column
headings in row 2 that identify each column of information on the screen
while you scroll the worksheet up and down to review information on income
and expenses. Additionally, you can keep the row headings in column A on
the screen while you scroll the worksheet to the right.
Refer to Figure 6-4 to see the worksheet right after splitting the window into
four panes and freezing them. To create and freeze these panes, follow these
1. Position the cell cursor in cell B3.
2. Click View ➪ Freeze Panes on the Ribbon and then click Freeze Panes
on the drop-down menu or press Alt+WFF.
In this example, Excel freezes the top and left pane above row 3 and left
of column B.
When Excel sets up the frozen panes, the borders of frozen panes are
represented by a single line rather than the thin gray bar, as is the case when
simply splitting the worksheet into panes.
See what happens when you scroll the worksheet up after freezing the panes
(shown in Figure 6-5). In this figure, I scrolled the worksheet up so that rows
33 through 52 of the table appear under rows 1 and 2. Because the
vertical pane with the worksheet title and column headings is frozen, it remains
onscreen. (Normally, rows 1 and 2 would have been the first to disappear
when you scroll the worksheet up.)
Look to Figure 6-6 to see what happens when you scroll the worksheet to
the right. In this figure, I scroll the worksheet so that the data in columns
M through P appear after the data in column A. Because the first column is
frozen, it remains onscreen, helping you identify the various categories of
income and expenses for each month.
Click Freeze Top Row or Freeze First Column on the Freeze Panes button’s
drop-down menu to freeze the column headings in the top row of the
worksheet or the row headings in the first column of the worksheet, regardless of
where the cell cursor is located in the worksheet.
To unfreeze the panes in a worksheet, click View ➪ Freeze Panes on the
Ribbon and then click Unfreeze Panes on the Freeze Panes button’s
dropdown menu or press Alt+WFF. Choosing this option removes the panes,
indicating that Excel has unfrozen them.