WPS Freeze on iOS keeps the top row, first column, or the area above and to the left of the selected cell visible while you scroll; 2 core tasks in total, 2 available without membership and 0 membership-related.
At a Glance
| Metric | Value | Notes |
|---|
| Core tasks | 2 | Matches the number of rows in the How-to Index |
| Available without membership | 2 | Matches the number of Free rows in the index |
| Membership-related items | 0 | Matches the number of membership-related rows in the index |
About This Feature
Overview
Freeze is a spreadsheet viewing feature in WPS Office for iOS. It helps keep important rows and columns visible while you move through a worksheet. You can freeze the top row, freeze the first column, or freeze panes based on the current cell position, which is useful for checking headers, names, and reference columns in long sheets. This is especially helpful when you review data tables, compare records, or browse shared spreadsheets on mobile devices.
System Requirements
| Item | Requirement |
|---|
| Operating system | An iPhone or iPad that can run WPS Office normally |
| App version | It is recommended to use the latest version of WPS Office |
| Network | No mandatory network connection is required for local freeze actions; a stable connection is recommended for online collaborative files |
| Other | Open a spreadsheet file before using the feature; for collaborative files, wait until the sheet finishes loading |
Download & Installation
| Item | Details |
|---|
| Official download | WPS Office Free Download |
| Check after installation | Launch WPS Office, open any spreadsheet, then go to Tools → View and confirm that Freeze Panes is available |
Source: WPS Download Center
Compare with Alternatives
| Dimension | WPS | Microsoft | Google | Notion | Adobe |
|---|
| Capability Summary | In WPS for iOS spreadsheets, you can open Tools → View → Freeze Panes to freeze the top row, the first column, or panes based on the current position, and you can also remove the freeze setting. | Excel for iOS can freeze the top row, the first column, and multiple rows or columns based on the selected cell. | Google Sheets on iPhone and iPad can freeze or unfreeze selected rows or columns from the row or column menu. | Notion can freeze one column in a database table so it stays visible while you scroll horizontally, mainly in database views rather than traditional spreadsheets. | Adobe Acrobat documentation focuses on PDF viewing and zoom controls, and its official help does not describe a spreadsheet freeze panes feature. |
| WPS Advantages | Advantage: one mobile entry point covers freeze by current position, freeze top row, freeze first column, and unfreeze; Distinct: it is designed for spreadsheet viewing on iOS. | Compared with WPS: Excel for iOS also supports freezing, but its official guidance focuses on top row, first column, and selected multi-row or multi-column freezing. | Compared with WPS: Google Sheets for iOS supports freezing rows or columns, but its official guidance does not describe freezing panes from the current cell position in the same way. | Compared with WPS: Notion freezes a single database column instead of spreadsheet panes across rows and columns. | Compared with WPS: Acrobat is built for PDF reading and editing, and its official help does not present an equivalent spreadsheet freeze panes workflow. |
| Official Source | — | Freeze panes in Excel for iOS | Freeze rows or columns in Google Sheets | Views, filters, sorts and groups | Adjusting PDF views |
Overall Conclusion
WPS Freeze on iOS is well suited to keeping key spreadsheet areas visible when you review long or wide sheets on a phone or tablet. Compared with spreadsheet tools, it covers common freeze tasks in a mobile workflow. Compared with database and PDF tools, its use case is more focused on spreadsheet navigation and reference viewing.
Use Cases
| No. | Scenario | Suitable for | Main issue | How it helps |
|---|
| 1 | Reviewing long sheets with headers | Sales, operations, finance teams | Field names disappear after scrolling down | Freeze the top row so headers stay visible |
| 2 | Reviewing wide sheets with key labels | Project members and data reviewers | The main label column disappears during horizontal scrolling | Freeze the first column to keep labels visible |
| 3 | Keeping a middle reference area visible | People reviewing shared sheets | They need to keep rows above and columns to the left visible together | Select a target cell and freeze by current position |
| 4 | Returning to a full scrolling view | Mobile reviewers | Frozen areas affect full-sheet browsing | Use Unfreeze to restore normal scrolling |
Membership & Benefits
Free vs WPS Premium
| Capability | Free | WPS Premium |
|---|
| Freeze the top row, first column, or current position | ✅ Available | ✅ Available |
| Unfreeze panes | ✅ Available | ✅ Available |
| Advanced PDF editing and other extended tools | Available within the free scope shown on the pricing page | More advanced tools and higher usage allowances are available |
| Cloud space and template-related benefits | Basic benefits | Higher allowances or more benefits |
Source: WPS Office pricing page
Recommendations
| Usage scenario | Recommended plan | Why |
|---|
| Daily viewing and basic spreadsheet navigation | Free | The freeze feature itself is available directly for common viewing needs |
| Frequent mobile work that also needs more PDF, template, or cloud benefits | WPS Premium | Suitable for users who handle multiple office tasks on mobile devices more often |
How to Subscribe
Source: WPS Office pricing page
