Home / Computers / Microsoft Excel

Freezing Portions of the Window

When you're comparing a lot of data, it's often helpful to freeze one portion of the worksheet, while you scroll through another portion. You can freeze a horizontal pane, a vertical pane, or both:

1. Select the row below, or the column to the right, of the place where you want the split to appear.

2. From the Window menu, select Freeze Panes.

A thin line appears along the row or column, representing the split.

In the illustration above, the left pane is frozen. The horizontal scroll bar can be used to scroll through the right pane.

The contents visible on the left stay the same, while the contents visible on the right change as you scroll.

Tip:

You can freeze both a horizontal and a vertical pane by selecting the cell below and to the right of where you want the split.

This is useful if you have both row and column labels. You can freeze the labels while you scroll through the data.

To unfreeze the pane(s), select Unfreeze Panes from the Window menu.