How to Freeze or Lock Columns and Rows in Excel 2007, 2010?

Learn how to Lock or Freeze Columns and Rows using Freezing Panes in an Excel 2007, 2010.

1. Open your excel.

2. To lock both rows and columns, click the cell below and to the right of the rows and columns that you want to keep visible when you scroll.

3. Goto View tab, in the Window group and select the Freeze Panes.

4. Select the Options which you want to like to freeze.

• To lock one row only, select Freeze Top Row.
• To lock one column only, select Freeze First Column.
• To lock more than one row or column, or to lock both rows and columns at the same time, select Freeze Panes.

thats it..