Lock Columns and Rows in Excel 2003 with Freeze Panes
Related tutorial: Excel 2007 / 2010 Freeze Panes.
It is sometimes difficult to read and understand very large spreadsheets. When you scroll too far to the right or down, you lose the headings that are located at the top and down the left side of the worksheet. Without the headings, its hard to keep track of which column or row of data you are looking at.
To avoid this problem use the freeze panes feature in Microsoft Excel. It allows you to "freeze" certain areas or panes of the spreadsheet so that they remain visible at all times when scrolling to the right or down. Keeping headings on the screen makes it easier to read your data throughout the entire spreadsheet.