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Â
