It's not just column titles that you can freeze in place. You can also freeze row titles, or you can freeze both at the same time to keep both column and row titles.
But there's a secret to success: To freeze titles, do not select the titles themselves. To freeze:
- Column titles Select the first row below the titles.
- Row titles Select the first column to the right (for example, to keep supplier names in sight as you scroll across the worksheet).
- Both column and row titles Click the cell that is both just below the column titles and just to the right of the row titles.
If you don't get it right the first time, it's easy to unfreeze and try again. Just click Unfreeze Panes on the Window menu.
Tip 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 freeze.