Put the cursor below or on the right side of the first colomn/row you want to keep on the screen. Go in the menu Window and do a Freeze Panes.

Ex.: if you put your cursor in the cell B2, the first row and the first column will never disappear when you will scrool.