WPS Freeze on iOS helps keep key rows and columns visible while you scroll a spreadsheet; it includes 2 core tasks, with 2 available without membership and 0 membership-related items.
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 keeps important rows or columns visible while you move through a worksheet. This is useful when you need to keep headers, labels, or reference columns on screen while reviewing larger tables on an iPhone or iPad.
Core capabilities include:
- Freeze the first row, first column, or the current position so reference information stays visible while scrolling.
- Unfreeze panes to return the worksheet to normal scrolling.
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 so menu paths and feature states stay consistent |
| Network | Freeze and unfreeze are local viewing actions and do not require a constant network connection; downloading the app and account services require internet access |
| Other | Open a spreadsheet file in WPS before using this feature |
Download & Installation
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Installation | Install WPS Office on your iPhone or iPad, sign in if needed, and open a spreadsheet to use Freeze |
| Check after installation | Open any spreadsheet, go to Tools → View, and confirm that Freeze Panes is available |
Source: WPS Download Center
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | On iOS, WPS lets you open Freeze Panes from Tools → View and freeze the first row, first column, or the current position, then unfreeze when needed. | Microsoft Word does not provide an equivalent freeze panes feature for tables; official Microsoft answers describe split panes or repeated header rows as nearby alternatives. | Google Sheets on iPhone and iPad supports freezing or unfreezing rows and columns from the row or column menu. | Notion table views support table databases, row and column arrangement, and property display, but the official help page does not describe freezing rows or columns. | Adobe Acrobat community guidance explains that PDF content is static and does not provide spreadsheet-style freeze panes for table viewing. |
| WPS Advantages | Advantage: WPS provides a direct mobile entry for freezing the first row, first column, or the current position, which is useful for reviewing larger worksheets on a smaller screen. | Compared with WPS: official Microsoft guidance does not describe an equivalent spreadsheet-style freeze panes feature in Word tables. | Compared with WPS: Google Sheets also supports mobile freeze and unfreeze actions, while WPS additionally supports freezing from the current cell position for more flexible reference areas. | Compared with WPS: Notion focuses on database views and table organization, and the official page does not describe row or column freezing. | Compared with WPS: Acrobat is designed for PDF viewing and editing, and the official discussion does not describe freeze panes for table navigation. |
| Official Source | — | Freeze Panes in Word | Freeze, group, hide, or merge rows & columns | Table view | Freezing Rows and Columns in PDF Table |
Overall Conclusion
For mobile spreadsheet review, the main value of freeze panes is keeping reference information visible while you scroll. WPS provides a direct iOS workflow for freezing and unfreezing panes, including freezing from the current position, which fits larger worksheet review on iPhone and iPad.
Use Cases
| No. | Scenario | Suitable For | Main Pain Point | Solution |
|---|---|---|---|---|
| 1 | Reviewing spreadsheets with headers | Students, admins, finance users | Column names disappear after scrolling down | Freeze the first row to keep headers visible |
| 2 | Checking ID or name columns | Sales teams, teachers, operations users | Key labels disappear after scrolling sideways | Freeze the first column to keep identifiers visible |
| 3 | Reviewing data in the middle of a large sheet | Users working with complex tables | Both upper and left reference areas are needed | Select a target cell and freeze from the current position |
| 4 | Returning to a full scrolling view | All spreadsheet users | A frozen layout is no longer needed | Unfreeze panes to restore normal scrolling |
| 5 | Browsing long sheets on mobile | iPhone and iPad users | Small screens make it easy to lose context while scrolling | Use Freeze to improve orientation during review |
Membership & Benefits
Free vs WPS Premium
| Capability | Free | WPS Premium |
|---|---|---|
| Freeze and unfreeze panes | ✅ Available | ✅ Available |
| Basic spreadsheet viewing | ✅ Available | ✅ Available |
| Additional advanced office and PDF benefits | Available within the free scope shown on the pricing page | Includes broader access to advanced features and benefits |
| Cloud storage | 1 GB | 20 GB, based on the pricing page |
Source: WPS Office pricing page
Recommendations
| Scenario | Recommended Plan | Why |
|---|---|---|
| Daily spreadsheet review and light editing | Free | Freeze itself is available directly and fits light work or study tasks |
| Users who also need more advanced office features | WPS Premium | Suitable when you also need broader PDF, template, cloud, or other advanced capabilities |
How to Subscribe
- WPS membership page: Subscribe now
Source: WPS Office pricing page