Wednesday, March 25, 2009

Freeze Panes


This is a very simple, but highly useful Excel maneuver. If you have a long list of data and you want to keep the headings on the screen, simply:


1. Click the cell immediately under the row beneath the column headings.
2. Select View/Window/Freeze Panes (Excel 2007)

You can now scroll your data and still see the headings. Cool, eh? (“Cool”, get it)?

No comments: