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)?
Wednesday, March 25, 2009
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: