There should be an image here!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.

To keep column labels in view:

  1. Within Excel, click View on the Ribbon.
  2. Select Freeze Panes.
  3. 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.

[Photo above by konradfoerstner / CC BY-ND 2.0]