-
To freeze two or more rows, select the row below the ones to be frozen.
-
On the View tab, select Freeze Panes and then choose Freeze up to (where a row and column is listed).
For more info, see Freeze panes to lock rows and columns.
Tip: To freeze just the top row, go to View, select Freeze Panes, and then Freeze Top Row.
-
To freeze two or more rows, select the row below the ones to be frozen.
-
On the View tab, select Freeze Panes.
For more info, see Freeze panes to lock the first row or column in Excel for Mac.
Tip: To freeze just the top row, go to View and select Freeze Top Row.