How to Hide and Unhide Worksheets in WPS on iOS

Use Hide Worksheet with 2 how-to topics, including 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 point: 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 immediately.
4. After that, the worksheet tab no longer appears in the tab bar.

Success Criteria

• UI state: the hidden worksheet tab disappears from the tab bar.
• Next actions: you can continue viewing or editing other visible worksheets.
• No side effects: hiding the worksheet does not delete its data.

Tips While Using

• Common mistakes: if you tap the wrong worksheet tab, you may hide the wrong sheet. Check the tab name before you continue.
• Environment limits: at least one worksheet must remain visible, so you cannot hide every worksheet in the workbook.

2. Unhide Worksheet

Entry point: All Sheets → Unhide

1. Tap the All Sheets button at the far right of the worksheet tab bar to open the list.
2. Review all worksheets in the current workbook.
3. Find the hidden worksheet and tap Unhide on its right side.
4. After it is restored, the worksheet appears again in the tab bar and can be opened normally.

Success Criteria

• UI state: the hidden worksheet appears again in the tab bar.
• Next actions: you can tap the restored worksheet and continue viewing or editing it.
• No side effects: the original worksheet content and data stay unchanged.

Tips While Using

• Common mistakes: if you do not check the All Sheets list, it may seem like the worksheet was deleted.
• Environment limits: the Unhide action is available only for worksheets that are currently hidden.