Excel: Freezing View Panes
When working with a large Excel worksheet that has row and column headings, it’s important to have your title headings visible so you can keep track of where you are when scrolling to a different location in the worksheet. The way to make the titles visible is to freeze the panes.
To freeze the panes, move the cell pointer to the cell below the row that you want to remain visible as you scroll and to the right of the column that you want to remain visible as you scroll. Select View / Window / Freeze Panes. In the example below, cell B5 was the cell chosen when freezing panes.
The next image shows the panes frozen in row 4 when the user is currently doing work on row 31 and beyond.
If you need to unfreeze panes, click View / Window / Unfreeze Panes.