You can prevent important rows or columns from scrolling off the screen by freezing them. For example, you can freeze a top row that contains column headings so that the labels remain visible as you scroll in the sheet.
Sheet with top row frozen
On the View menu, click Normal.
Do one of the following:
To freeze a
Do this
Row
Select a cell in the row below the row that you want to freeze.
Column
Select a cell in the column to the right of the column that you want to freeze.
On the Window menu, click Freeze Panes.
Tips
To unfreeze rows or columns that have been frozen, on the Window menu, click Unfreeze Panes.
You can also freeze cells, rows, columns, entire sheets, and entire workbooks by turning on sheet protection. For more information, see Protect sheet elements.
