How to Use WPS Freeze on iOS

Use WPS Freeze on iOS through 2 operation topics in a spreadsheet; both topics are available without membership, with 2 free items and 0 membership-related items.

How-to Index

How-to Guide

1. Freeze the top row, first column, or current position

Entry: Bottom toolbar → Tools → View → Freeze Panes

1. Open the spreadsheet that you want to review.
2. Tap Tools at the bottom.
3. Open the View tab.
4. Tap Freeze Panes.
5. Choose Current Position, Freeze Top Row, or Freeze First Column based on your needs.
6. Scroll through the sheet and confirm that the frozen area stays visible.

Success Criteria

• Interface result: The selected frozen row or column remains visible while the worksheet scrolls.
• You can continue: You can keep browsing, editing, or checking other cells.

Tips While Using

• Common mistake: If you want to freeze by current position, select the target cell before opening the Freeze Panes menu.
• Environment note: If a collaborative file loads slowly, wait until the sheet content is fully displayed before you continue.

2. Unfreeze panes

Entry: Bottom toolbar → Tools → View → Freeze Panes → Unfreeze Panes

1. Open a spreadsheet that already has frozen panes.
2. Tap Tools at the bottom.
3. Open the View tab.
4. Tap Freeze Panes, then choose Unfreeze Panes.
5. 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 at the edge of the screen.
• You can continue: You can browse the full worksheet normally in both directions.

Tips While Using

• Common mistake: If you do not see the unfreeze option, first confirm that the current sheet already has a freeze setting applied.