Single and multiple rows or columns may be frozen in a spreadsheet. To freeze a row or column, select it, and tap the Freeze Panes icon at the bottom of the screen.
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 the Freeze Panes icon at the bottom of the screen. The panes will be frozen around that cell.