How to Hide and Unhide Worksheets in WPS on Android

Use Hide Worksheet in WPS on Android through 2 how-to topics: Hide Worksheet and Unhide Worksheet; choose a topic from the index and follow the steps.

How-to Index

How-to Guide

1. Hide Worksheet

Entry: Tap a worksheet tab → Hide

1. Tap the worksheet tab that you want to hide to open the floating toolbar.
2. Tap Hide on the floating toolbar.
3. The current worksheet is hidden.
4. After that, the worksheet tab no longer appears in the tab bar.

Success Criteria

• Interface result: The hidden worksheet tab no longer appears in the tab bar.
• What you can do next: You can continue viewing and editing other visible worksheets.

Tips While Using

• Common mistake: Make sure you tap the correct worksheet tab before hiding it.
• Environment note: You cannot hide the last visible worksheet in a workbook.

2. Unhide Worksheet

Entry: All Worksheets → Unhide

1. Tap the All Worksheets button at the far right of the worksheet tab bar to open the drop-down list.
2. Review the full worksheet list.
3. Find the worksheet that is currently hidden.
4. Tap Unhide on the right side of that worksheet.
5. The worksheet appears again in the worksheet tab bar.

Success Criteria

• Interface result: The hidden worksheet appears again in the worksheet tab bar.
• What you can do next: You can open the worksheet and continue viewing or editing its content.

Tips While Using

• Common mistake: If you do not check the full worksheet list, it may seem as if the worksheet was deleted.
• Environment note: To unhide a worksheet, you must open the original workbook that contains the hidden sheet.