Freeze columns and rows

1. Select the cell below the rows and to the right of the columns you want to keep visible when you scroll.
2. Select View > Freeze Panes > Freeze Panes.

To freeze multiple rows (starting with row 1), select the row below the last row you want frozen and click Freeze Panes. To freeze multiple columns, select the column to the right of the last column you want frozen and click Freeze Panes.

Columns and rows should be frozen.
Choose the cell below the rows and to the right of the columns that you want to see when you scroll.
Select View > Freeze Panes > Freeze Panes from the menu.