Using the Freeze Panes feature

You can freeze a row, column or area of the worksheet so that it remains fixed, when the worksheet is scrolled. For example, you would freeze panes to keep row and column labels visible as you scroll.

• To lock rows, select the row below where you want the split to appear.
• To lock columns, select the column below where you want the split to appear.
• To lock both rows and columns, click the cell below and to the right of where you want the split to appear.
• Press the Freeze Panes button, as shown below:

To unfreeze a row, column or area, click the cell A1 and press the Freeze Panes button.

When you press the Freeze Panes button, Office² will also lock the initial scroll position. For example, if the worksheet is scrolled such that column D is the leftmost column showing in the view, applying the Freeze Panes function will lock the initial scroll offset at column D, meaning that you will not be able to scroll to cells before column D without unfreezing the panes first.