Use Freeze on iOS with 2 how-to topics; both are available without membership, and 0 items are membership-related.
How-to Index
| No. | Topic | Membership Requirement |
|---|---|---|
| 1 | 1. Freeze the first row, first column, or current position | Free |
| 2 | 2. Unfreeze panes | Free |
How-to Guide
1. Freeze the first row, first column, or current position
Entry: Bottom toolbar → Tools → View → Freeze Panes
- Open the spreadsheet you want to review.
- Tap Tools at the bottom.
- Open the View tab.
- Tap Freeze Panes.
- Choose one of the following options:
- Current Position to freeze based on the selected cell position.
- Freeze First Row to keep the top row visible.
- Freeze First Column to keep the leftmost column visible.
- Scroll through the sheet and confirm that the frozen area stays in place.
Success Criteria
- Interface result: The frozen row or column remains visible while the rest of the worksheet scrolls.
- What you can do next: You can continue reviewing, editing, or checking other cells.
Tips While Using
- Common mistake: If you want to use Current Position, select the target cell before opening Freeze Panes.
- Environment note: This feature is available in spreadsheets, not in Writer or Presentation files.
2. Unfreeze panes
Entry: Bottom toolbar → Tools → View → Freeze Panes → Unfreeze Panes
- Open a spreadsheet that already has frozen panes.
- Tap Tools at the bottom.
- Open the View tab.
- Tap Freeze Panes.
- Tap Unfreeze Panes.
- Scroll through the sheet and confirm that all rows and columns move normally again.
Success Criteria
- Interface result: Previously fixed rows or columns no longer stay in place while scrolling.
- What you can do next: You can set a different freeze mode or continue reviewing the full sheet.
Tips While Using
- Common mistake: If no panes are currently frozen, this action may not change the sheet view.
- Environment note: Unfreeze only changes the current spreadsheet view state.