Tap on the row or column that you want to “freeze”.

Go into the Menu and choose View/Freeze Panes

Once the chosen area is frozen, that area will remain on screen while you’re able to pan the rest of the unfrozen document. To freeze both a row and a column, select a single cell and tap View/Freeze Panes. The panes will be frozen around that cell.