This how-to guide includes 3 topics: freeze to the current cell, freeze the top row, and freeze the first column; 3 items are available without membership and 0 are membership-related.
How-to Index
| No. | Topic | Membership Requirement |
|---|---|---|
| 1 | 1. Freeze to the Current Cell | Free |
| 2 | 2. Freeze the Top Row | Free |
| 3 | 3. Freeze the First Column | Free |
How-to Guide
1. Freeze to the Current Cell
Entry path: Spreadsheet editing view → View → Freeze
- Open the spreadsheet you want to work with.
- Place the cursor in the cell at the lower-right position of the area you want to keep visible.
- Tap View.
- Tap Freeze.
- Select Freeze to Current Cell.
- The rows above and columns to the left stay fixed while you continue scrolling through the sheet.
Success Criteria
- Interface result: When you scroll the worksheet, the rows above and columns to the left of the selected cell remain visible.
- What you can do next: You can continue reviewing, editing, filtering, or checking data.
Tips While Using
- Common mistake: If the cursor is placed in the wrong cell, the frozen range may not match what you expect.
- Environment note: You need to be in an editable worksheet view before using this option.
2. Freeze the Top Row
Entry path: Spreadsheet editing view → View → Freeze
- Open the target spreadsheet and enter the worksheet.
- Tap View.
- Tap Freeze.
- Select Freeze Top Row.
- Scroll down to confirm that the header row stays visible.
Success Criteria
- Interface result: The first row remains visible during vertical scrolling.
- What you can do next: You can continue reading lower rows without losing the header information.
Tips While Using
- Common mistake: If your headers are not in the first row, use Freeze to the Current Cell instead.
3. Freeze the First Column
Entry path: Spreadsheet editing view → View → Freeze
- Open the target spreadsheet and enter the worksheet.
- Tap View.
- Tap Freeze.
- Select Freeze First Column.
- Scroll horizontally to confirm that the first column stays visible.
Success Criteria
- Interface result: The first column remains visible during horizontal scrolling.
- What you can do next: You can continue reviewing data on the right while keeping the key identifier column visible.
Tips While Using
- Common mistake: If the key field is not in the first column, use Freeze to the Current Cell for a more flexible frozen range.