To keep names in sight, divide or split the worksheet by freezing the names in their own pane. The name pane is then locked in place as you scroll through the rest of the worksheet. It's not just column names that you can freeze in place. You can also freeze row names, or you can freeze both column and row names.
Freeze panes by making a selection in the worksheet, and then clicking Freeze Panes on the Window menu.
You can see the result in the picture on the left. The names, separated from the worksheet data by a horizontal line, are still visible above row 1,980.
To freeze names, do not select the names themselves. To freeze:
- Column names Select the first row below the names.
- Row names Select the first column to the right of the names.
- Both column and row names Click the cell that is both just below the column names and just to the right of the row names.
If you don't get it right the first time, you can unfreeze and try again. Click Unfreeze Panes on the Window menu.
You can try this in the practice session at the end of the lesson.
You can freeze panes anywhere, not just below the first row or to the right of the first column. For example, if you wanted the information in the first three rows to stay in sight as you scroll, you would select the fourth row and then freeze panes.