Freeze Panes Using the Active Cell
The Freeze Panes option freezes all the rows above the active cell and all the columns to the left of the active cell.
Example of freezing panes using the active cell
To keep rows 1, 2, and 3 on the screen and columns A and B:
- Click in cell C4 with the mouse to make it the active cell.
- Click on the View tab.
- Click on Freeze Panes from the ribbon to open the features drop down list.
- Click on Freeze Panes option in the list.
- A black border should appear to the right of column B in the worksheet and below row 3 indicating that the areas above and to the right of the lines have been "frozen".
- Scroll to the right in the worksheet. If you scroll far enough, the columns to the right of column B will begin disappearing while columns A and B will stay on the screen.
- Scroll down through the worksheet. If you scroll far enough, the rows below row 3 will begin disappearing while rows 1, 2, and 3 will stay on the screen.