Freeze Panes

You can prevent rows or columns from scrolling off the page by freezing them.

TO FREEZE A ROW:

Select a cell in the row below the row that you want to freeze.

Click on the Window menu and select Freeze Panes.

TO FREEZE A COLUMN:

Select a cell in the column to the right of the column that you want to freeze.

Click on the Window menu and select Freeze Panes