Click on View on the Ribbon and select Freeze Panes.
Now click Freeze Top Row. If you want to Freeze other rows as well just highlight them before choosing Freeze Panes.
That’s it! Now as you can see by the example, you will be able to scroll throughout the document while keeping the column or rows in place.