Freeze Panes locks rows, columns, or both to the top and left in a sheet.
-
Select the cell below the rows and to the right of the columns to freeze.
-
On the View tab, select Freeze Panes and select one of the following:
-
For both rows & columns: Select Freeze Panes.
-
Just the top row: Select Freeze Top Row.
-
Just the first column: Select Freeze First Column.
-
-
Select the cell below the rows you want to freeze.
-
Select the cell to the right of the columns you want to freeze.
-
On the View tab, select Freeze Panes and then choose Freeze up to (where a row and column is listed).
-
Select the cell below the rows you want to freeze.
-
Select the cell to the right of the columns you want to freeze.
-
On the View tab, select Freeze Panes.