Hide or unhide sheets in WPS on iOS helps you manage sheet 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 |
About This Feature
Overview
Hide or unhide sheets is a built-in spreadsheet management feature in WPS Office for iOS. It helps you control whether a worksheet appears in the workbook tab bar. After a sheet is hidden, its data remains in the workbook, but the sheet tab is no longer shown. This is useful for organizing workbooks with many sheets, temporarily putting helper sheets out of view, and keeping the interface cleaner during review or presentation.
Core capabilities include:
- Hide a sheet: remove the current worksheet from the visible tab bar.
- Unhide a sheet: restore a previously hidden worksheet to the tab bar.
- Keep workbook data intact: hiding a sheet does not remove its data or workbook relationships.
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 hide or unhide actions |
| Other | Open a spreadsheet file with two or more worksheets, and keep at least one sheet visible |
Download & Installation
Before you use hide or unhide sheets, install WPS Office on your iOS device.
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Installation method | Open the official download page, get the iOS version, and complete installation by following the on-screen instructions |
| Post-install check | Launch WPS Office, open a spreadsheet file, and confirm that sheet tabs are visible |
Source: WPS download page
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | Supports hiding a worksheet in a spreadsheet on iOS and restoring it with unhide; hidden sheet data stays in the workbook. | Excel supports hiding and unhiding worksheets, and data in hidden worksheets can still be referenced from other worksheets and workbooks. | Google Sheets states that on iPhone and iPad, hiding or unhiding sheets must be done on a computer. | Notion supports showing or hiding database properties in list views, but it does not provide spreadsheet worksheet hide or unhide controls. | Adobe Acrobat supports organizing PDF pages, such as adding, cropping, extracting, and organizing pages, but not spreadsheet worksheet visibility management. |
| WPS Advantages | Advantage: WPS lets you hide and unhide worksheet tabs directly on iOS for mobile workbook cleanup. | Compared with WPS: similar worksheet visibility control is available, but the cited guidance focuses on desktop, Mac, and web workflows. | Compared with WPS: the official iPhone and iPad guidance says hide or unhide sheets should be done on a computer, so direct mobile handling is more limited. | Compared with WPS: property visibility is useful for database presentation, but it is not a worksheet tab management workflow. | Compared with WPS: Acrobat is designed for PDF page organization rather than spreadsheet sheet visibility. |
| Official Source | — | Hide or Unhide worksheets | Protect, hide & edit sheets - iPhone & iPad | List view | Organize PDF pages in Acrobat on the web |
Overall Conclusion: If you need to manage worksheet visibility directly on a mobile device, WPS on iOS fits that workflow well. Microsoft Excel offers comparable worksheet behavior, while Google’s official iOS guidance is more limited for this task. Notion and Adobe are better suited to database presentation and PDF page organization rather than worksheet hide or unhide actions.
Use Cases
| No. | Scenario | Suitable For | Main Pain Point | How WPS Helps |
|---|---|---|---|---|
| 1 | Organizing multi-sheet reports | Mobile office users | Too many tabs make switching slower | Hide temporary sheets and keep frequently used tabs visible |
| 2 | Putting helper sheets out of view | Data organizers | Helper sheets distract from the main sheet | Hide helper sheets while keeping the main sheet visible |
| 3 | Simplifying a workbook before presenting | Presenters | Not every sheet should be shown during review | Hide sheets that are not needed for the presentation |
| 4 | Restoring previously hidden sheets | Collaborators | A needed sheet is no longer visible | Use unhide to bring the sheet back |
| 5 | Keeping data without visual clutter | Everyday spreadsheet users | Data should stay in the file without staying on screen | Hide the sheet while keeping workbook content intact |
Membership & Benefits
Free vs WPS Premium
| Capability | Free | WPS Premium |
|---|---|---|
| Hide sheets | ✅ Available | ✅ Available |
| Unhide sheets | ✅ Available | ✅ Available |
| Basic spreadsheet editing | ✅ Available | ✅ Available |
| Additional advanced office features | Available within the free scope shown on the product page | More advanced features are available depending on the subscription plan |
Source: WPS Office pricing page
Recommendations
| Scenario | Recommended Plan | Why |
|---|---|---|
| You only need to hide or unhide sheets | Free | This feature can be used without membership |
| You also need more advanced office features | WPS Premium | Suitable if you want additional tools and broader benefits in the same subscription |
How to Subscribe
- Subscription page: Get WPS Premium
Source: WPS Office pricing page