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
-
For both rows & columns: Select
-
Just the top row: Select
-
Just the first column: Select
-
-
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
-
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
