To keep certain rows or columns in view while you scroll through your spreadsheet, you can freeze them.
Freeze or Unfreeze rows
- Select the row below the one you want to freeze.
For example, to freeze row 1, select row 2. To freeze rows 1 and 2, select row 3. - On the View tab, swipe the toolbar to reveal more options.
- Tap the Freeze button to freeze or unfreeze the selection. Alternatively, tap Freeze/Unfreeze on the contextual menu that appears when you tap the row.
Freeze or Unfreeze columns
- Select the column to the right of the one you want to freeze.
For example, to freeze column A, select column B. - On the View tab, swipe the toolbar to reveal more options.
- Tap the Freeze button to freeze or unfreeze the selection. Alternatively, tap Freeze/Unfreeze on the contextual menu that appears when you tap the column.
Freeze rows and columns at the same time
To keep both rows and columns in view, freeze them together in one step by selecting a single cell instead of a whole row or column.
- If any rows or columns are already frozen, go to the View tab and tap Freeze to unfreeze them first.
- Tap the cell just below the last row and to the right of the last column you want to freeze.
For example, to freeze rows 1 and 2 and column A, tap cell B3. - On the View tab, swipe the toolbar to reveal more options.
- Tap the Freeze button. Alternatively, tap Freeze/Unfreeze on the contextual menu that appears when you tap the cell.
The rows above the selected cell and the columns to its left will now stay in place while you scroll.
Note: Only one freeze can be active at a time. If you freeze rows first and then try to freeze a column, tapping Freeze will unfreeze the rows instead. To freeze both, use the steps in this section.