Hide or unhide sheets in WPS on iOS helps you manage worksheet visibility in a workbook; this guide covers 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 |
| Version limit | None stated | The feature information does not list a version restriction |
| Membership limit | None | The feature information does not list a membership restriction |
About This Feature
Overview
Hide or Unhide Sheets is a built-in spreadsheet feature in WPS Office for iOS that controls whether worksheet tabs remain visible in a workbook.
Core capabilities include:
- Hide a sheet: remove a selected worksheet from the tab bar while keeping its data in the workbook.
- Unhide sheets: restore hidden worksheets so they appear again in the tab bar.
- Keep workbook data intact: hiding changes visibility only and does not remove worksheet content.
This feature is useful when you want to simplify a workbook with many tabs, temporarily hide supporting sheets, or prepare a cleaner workbook view before sharing or presenting.
System Requirements
| Item | Requirement |
|---|---|
| Operating system | An iPhone or iPad that can run WPS Office |
| App version | It is recommended to use the latest version of WPS Office |
| Network | No mandatory network connection is required for local hide or unhide actions; sign-in, sync, and collaboration work better with network access |
| Other | Open a spreadsheet file with two or more worksheets so the hide or unhide options can be used |
Download & Installation
Before using this feature, install WPS Office on your iPhone or iPad and open a spreadsheet file with multiple worksheet tabs.
| 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 file |
| Check after installation | Launch WPS Office, open a workbook with multiple sheets, and tap a sheet tab to confirm the related options are available |
Source: WPS Download Center
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | On iOS, WPS lets you hide or unhide worksheet tabs from the sheet-tab toolbar, while keeping worksheet data in the workbook. | Excel lets users hide or unhide worksheets, and hidden worksheet data can still be referenced from other worksheets and workbooks. | Google Sheets lets users hide sheets, but its help page notes that hiding is not the same as protection and viewers may still access hidden content in some cases. | Notion does not provide traditional workbook sheet hiding; it mainly manages visibility through database views, property visibility, filters, and groups. | Adobe Acrobat focuses on organizing PDF pages, such as adding, extracting, splitting, and arranging pages, rather than hiding spreadsheet worksheets. |
| WPS Advantages | Advantage: The entry point is centered on worksheet tab actions in the mobile spreadsheet interface, which is convenient for quick workbook cleanup on iOS. | Compared with WPS: Microsoft documents worksheet hiding clearly, but its official guidance is centered on desktop and web workflows rather than an iOS sheet-tab toolbar flow. | Compared with WPS: Google Sheets supports hiding, but its official guidance emphasizes that hidden sheets are not protected content. | Compared with WPS: Notion is better suited to database presentation control than workbook sheet visibility management. | Compared with WPS: Adobe Acrobat is designed for PDF page organization, not spreadsheet sheet visibility control. |
| Official Source | — | Hide or Unhide worksheets | Protect, hide & edit sheets | Views, filters, sorts & groups | Organize PDF pages in Acrobat on the web |
Overall Conclusion
If you want to manage worksheet visibility quickly on a mobile device, WPS provides a direct sheet-focused workflow on iOS. Microsoft Excel and Google Sheets also support hiding sheets, while Notion and Adobe are designed for different content organization models.
Use Cases
| No. | Scenario | Suitable for | Main issue | How this feature helps |
|---|---|---|---|---|
| 1 | Cleaning up monthly report tabs | Finance and operations teams | Too many worksheet tabs make navigation slower | Hide sheets that are not needed for the current review |
| 2 | Hiding helper calculation sheets | Spreadsheet editors | Supporting sheets distract from the main worksheet | Keep helper sheets in the workbook but out of the visible tab list |
| 3 | Preparing a workbook for presentation | Presenters and managers | Extra sheets may distract during a demo | Hide non-presentation sheets before sharing the screen |
| 4 | Organizing shared workbooks | Team members | Multi-sheet files become harder to scan during collaboration | Adjust which sheets stay visible in the tab bar |
| 5 | Keeping archive sheets without deleting them | Project contributors | Historical sheets should remain available but not always visible | Hide archive sheets and restore them when needed |
Membership & Benefits
Free vs WPS Premium
| Feature | Free | WPS Premium |
|---|---|---|
| Hide sheets | ✅ Available | ✅ Available |
| Unhide sheets | ✅ Available | ✅ Available |
| Basic spreadsheet editing | ✅ Available | ✅ Available |
| Additional advanced services and extended tools | Available within the free offering shown on the pricing page | Available according to the selected subscription plan |
| Cloud storage | 1 GB | 20 GB |
Source: WPS Office pricing page
Recommendations
| Scenario | Recommended plan | Why |
|---|---|---|
| You only need to hide or restore sheets | Free | This feature itself does not require membership for everyday workbook organization |
| You also need more cloud storage or broader advanced services | WPS Premium | A better fit if you also want expanded storage or additional premium capabilities |
How to Subscribe
- Subscribe here: Get WPS Premium
Source: WPS Office pricing page