Excel Freeze Panes Overview
Related tutorial: Freeze Panes in Excel 2003.
When working with very large spreadsheets headings located at the top and down the left side of the worksheet often disappear if you scroll too far to the right or down. Without the headings, it's hard to keep track of which column or row of data you are looking at.
To avoid this problem use Excel's freeze panes feature. It "freezes" or locks specific columns or rows of the spreadsheet so that they remain visible at all times.
This tutorial covers the freeze panes options in Excel 2007 / 2010.
The steps in this tutorial are: