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.
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.