What do Freeze Panes do in Excel?

Through freeze panes we can customize the view of our Data Sheet in  Excel.

Related tutorial: Freeze Panes in Excel2003.

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 Excel2007 /2010.

The steps in this tutorial are:

1. 1. Freeze the top row

1. 1. Freeze the first column

1. 1. Freeze both columns and rows

1. Unfreeze columns and rows

Freeze panes freezes (sets) the parts that you would like to see throughout the entire time you scroll  that sheet, either up, down left or right, depending on which cell you chose to freeze the panes.  This is very helpful, if the sheet created is longer than the area displayed on the screen.

customize the view of our Data Sheet in  Excel