Excel spreadsheets can grow to a very large number of rows. After the spreadsheet grows beyond a single page, the column headings scroll off the page, making it very difficult to remember what the column headings are. The following steps show how to make the column headings behave as a fixed header row:
- Select the row below your column headings.
- On the Window tab, select Freeze Panes.
Now, the column headings will be frozen and constantly visible, as you scroll down.
Note: You can reverse by selecting “Unfreeze Panes” from the same menu.