WPS Freeze keeps key fields visible in multidimensional tables while you scroll; this guide covers 3 core tasks, with 3 available without membership and 0 membership-related items.
At a Glance
| Metric | Value | Notes |
|---|---|---|
| Core tasks | 3 | Matches the number of rows in the How-to Index |
| Available without membership | 3 | 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
WPS Freeze is a table-view feature for multidimensional tables that keeps selected fields visible during horizontal scrolling. It helps you compare large sets of data without losing sight of key identifiers.
Core capabilities include:
- Freeze up to a selected field so that the chosen field and all fields to its left stay visible.
- Keep important fields on screen while you review more columns on the right.
- Remove the frozen state from the first field to return to normal scrolling.
This feature is useful for customer lists, project trackers, finance ledgers, and other wide tables where names, IDs, or owner fields need to remain visible.
System Requirements
| Item | Requirement |
|---|---|
| Operating system | A Windows desktop environment |
| App version | It is recommended to use the latest version of WPS Office |
| Network | A network connection is recommended when you open online multidimensional tables or shared data |
| Other | You need access to a table view and permission to use field header actions |
Download & Installation
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Installation method | Download the Windows installer and complete setup with the installation wizard |
| Check after installation | Open WPS, enter a multidimensional table view, and confirm that the field header context menu is available |
Source: WPS download page
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | In a multidimensional table view, you can right-click a field header to freeze up to that field, keeping the selected field and all fields to its left visible. You can remove the frozen state from the first field. | Excel supports Freeze Panes on the View tab to keep rows above and columns to the left of the selected cell visible, and it also supports unfreezing panes. | Google Sheets supports freezing rows or columns from the View menu and also supports unfreezing them. | Notion's official table view documentation explains table databases, column rearrangement, resizing, and wrapping. The cited official page does not describe a spreadsheet-style frozen-column workflow. | Acrobat Desktop Help focuses on PDF viewing, editing, and conversion, and does not document a native spreadsheet-style frozen-column feature. |
| WPS Advantages | Advantage: Freeze is available directly from the field header context menu, which fits multidimensional table workflows where users want to lock key fields quickly. | Compared with WPS: Excel uses worksheet-based freeze pane logic and is oriented toward traditional spreadsheet layouts. | Compared with WPS: Google Sheets provides standard row and column freezing in browser-based spreadsheets. | Compared with WPS: The cited Notion help page focuses more on database table management than on a directly documented frozen-column workflow. | Compared with WPS: Acrobat is designed for PDF workflows rather than table-based field freezing. |
| Official Source | — | Freeze panes in Excel | Freeze rows or columns in Google Sheets | Table view in Notion | Acrobat Desktop Help |
Overall Conclusion
For wide multidimensional tables, WPS Freeze offers a direct field-header workflow that keeps key fields visible during horizontal review. Excel and Google Sheets provide mature freeze controls in traditional spreadsheet environments, while the cited Notion and Adobe documentation focuses on different product workflows.
Use Cases
| No. | Scenario | Suitable for | Main pain point | How Freeze helps |
|---|---|---|---|---|
| 1 | Reviewing customer lists | Sales teams, operations teams | Names or IDs disappear during horizontal scrolling | Freeze customer name or ID fields |
| 2 | Tracking project progress | Project managers, team leads | Project names are hard to keep in view across many columns | Freeze project and owner fields |
| 3 | Checking finance ledgers | Finance teams, administrative staff | Amount columns are far from the entity information they belong to | Freeze entity and date fields |
| 4 | Reviewing shared data | Collaborators | It takes time to relocate the current record in wide tables | Freeze key identifier fields before scrolling |
| 5 | Verifying data entry | Data coordinators | Users need to keep looking back to the left side of the table | Freeze base fields to reduce repeated scrolling |
Membership & Benefits
Free vs WPS Premium
| Capability | Free users | WPS Premium |
|---|---|---|
| Freeze fields in table view | ✅ Available | ✅ Available |
| Core Writer, Spreadsheet, and Presentation apps | ✅ Available | ✅ Available |
| Some advanced PDF and extended tools | May be limited by feature | ✅ More advanced tools available |
| Cloud storage and selected value-added benefits | Basic allocation | Higher allocation or more added benefits |
Source: WPS Office pricing page
Recommendations
| Scenario | Recommended plan | Why |
|---|---|---|
| Everyday table review and organization | Free plan | Freeze itself is available for regular table browsing |
| Ongoing work that also needs more PDF, cloud, or extended tools | WPS Premium | Better suited to users who need more advanced features across the suite |
How to Subscribe
- WPS membership center: Subscribe now
Source: WPS Office pricing page