How to Use ‘Freeze Panes’ for Viewing a Worksheet (Excel 2007 & 2010)
When you view a worksheet that contains a large amount of columns and/or rows, you may want to 'Freeze' some of the panes so they remain in view when you scroll through the worksheet. This can be done with a few clicks of the mouse. This process works the same in Excel 2007 and Excel 2010.