The Freeze Row and Freeze Column features in Excel 2010 make it easy to match and read details of large data sets. Locking rows or columns in one area by freezing panes will allow you to keep a specific area of a worksheet visible while you scroll to another area of the worksheet. For example, you would freeze panes to keep row and column labels visible as you scroll, as shown in the following picture. This function is both useful and easy to perform.

  1. To lock rows, select the row below where you want the split to appear.
    • To lock columns, select the column to the right of where you want the freeze pane to appear.
    • To lock rows, select the row below of where you want the freeze pane to appear.
    • To lock both rows and columns, click the cell below and to the right of where you want the freeze pane to appear.
  2. Select the VIEW tab and click FREEZE PANES in the windows group within the ribbon.
  3. Select FREEZE PANES
    Freeze Panes
  4. To unlock rows/columns, select FREEZE PANES in the VIEW tab.
  5. Click UNFREEZE PANES on the Window group within the ribbon.