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.