One of my favorite tips for Excel 2007 — keeping column labels in view. Otherwise, for large spreadsheets, you have to scroll back to the top of a column to see the column label.
- Within Excel, click View on the Ribbon.
- Select Freeze Panes.
- Click Freeze Top Row.
That’s all there is to it. Now as you scroll down a large spreadsheet, the column labels remain in view.