When using Freeze on iOS, common questions focus on freeze range, unfreeze steps, and display behavior; this section includes 4 common questions and 3 glossary terms.
FAQ
How do I freeze multiple rows or columns?
- Select the cell that matches the position you want to freeze from.
- Go to Tools → View → Freeze Panes.
- Tap Current Position to freeze the rows above and columns to the left of that cell.
Can I still filter or edit after freezing panes?
- Yes, you can continue scrolling, reviewing, and editing spreadsheet content.
- Freeze changes the viewing layout and does not change cell content.
- If needed, unfreeze panes at any time to return to a full scrolling view.
Why can’t I find the Freeze Panes option?
- Make sure the file you opened is a spreadsheet.
- Tap Tools at the bottom, then open the View tab to look for Freeze Panes.
- If your interface looks different, update WPS Office and try again.
How can I tell which rows or columns are currently frozen?
- Scroll the worksheet slightly.
- Check which rows or columns stay fixed while other content moves.
- If you want to reset the range, unfreeze panes first and then apply a new freeze option.
Glossary
| Term | Definition |
|---|---|
| Freeze Panes | A viewing method that keeps selected rows or columns visible while you scroll through a spreadsheet. |
| Freeze First Row | Keeps the top row fixed so headers remain visible during vertical scrolling. |
| Freeze First Column | Keeps the leftmost column fixed so identifiers such as names or numbers remain visible during horizontal scrolling. |