How to Freeze Panes in Microsoft Office Excel 2007

1. On the worksheet, do one of the following:

  • To lock rows, select the row below the row or rows that you want to keep visible when you scroll.
  • To lock columns, select the column to the right of the column or columns that you want to keep visible when you scroll.
  • 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.

2. On the View tab, in the Window group, click the arrow below Freeze Panes.

Excel Ribbon Image

3. Do one of the following:

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

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.