Freeze columns and rows

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.