Use this guide to complete 2 how-to topics for hide or unhide sheets in WPS on Android; both topics are available without membership, and the index below links directly to each section.
How-to Index
| No. | Topic | Membership Requirement |
|---|---|---|
| 1 | 1. Hide a Sheet | Free |
| 2 | 2. Unhide a Sheet | Free |
How-to Guide
1. Hide a Sheet
Entry point: Tap a sheet tab → Hide
- Tap the worksheet tab that you want to hide to open the floating toolbar.
- Tap Hide on the floating toolbar.
- The worksheet is hidden and no longer appears in the top tab bar.
Success Criteria
- Interface result: The selected worksheet tab disappears from the top tab bar.
- What you can do next: You can continue viewing or editing other visible worksheets.
- No side effect: The worksheet data remains in the workbook.
Tips While Using
- Common mistake: Make sure you tap the correct worksheet tab before hiding it.
- Environment limit: The workbook must keep at least one visible worksheet.
2. Unhide a Sheet
Entry point: Tap another visible sheet tab → Unhide
- Tap another visible worksheet tab to open the floating toolbar.
- Tap Unhide on the floating toolbar.
- Select the worksheet that you want to restore.
- Tap OK to make the worksheet visible again.
Success Criteria
- Interface result: The selected worksheet appears again in the top tab bar.
- What you can do next: You can open and edit the restored worksheet immediately.
- No side effect: Existing workbook content and other worksheet states remain unchanged.
Tips While Using
- Common mistake: If you do not tap another visible sheet tab first, the unhide option may not appear.
- Environment limit: Unhide is only meaningful when the workbook already contains hidden worksheets.