How to Hide or Unhide Sheets in WPS on Windows

Use hide or unhide sheets in WPS with 4 how-to topics, including 4 free topics and 0 membership-related topics; choose a topic from the index and follow the matching entry path.

How-to Index

How-to Guide

1. Hide a Sheet from the Right-Click Menu

Feature entry: Right-click a sheet tab → Hide

1. In the sheet tab bar, right-click the worksheet tab that you want to hide.
2. Click Hide.
3. Check the tab bar and confirm that the selected worksheet tab is no longer visible.

Success Criteria

• Interface result: The hidden worksheet tab no longer appears in the tab bar.
• What you can do next: You can still switch to and edit other visible worksheets.

Tips While Using

• A workbook must keep at least one visible worksheet.
• Hiding changes only the display state and does not remove worksheet data.

2. Hide a Sheet from the Ribbon

Feature entry: Home tab → Worksheet → Hide Sheet

1. Select the worksheet that you want to hide.
2. Click the Home tab.
3. Open the Worksheet menu.
4. Click Hide Sheet.

Success Criteria

• Interface result: The currently selected worksheet tab is hidden.
• What you can do next: You can continue editing data in other worksheets.

Tips While Using

• If the current sheet is the last visible worksheet, it cannot be hidden.
• Before using the ribbon path, confirm that the correct worksheet is selected.

3. Unhide a Sheet from the Right-Click Menu

Feature entry: Right-click any visible sheet tab → Unhide

1. In the sheet tab bar, right-click any visible worksheet tab.
2. Click Unhide.
3. In the dialog box, select the worksheet that you want to show again.
4. Click OK.

Success Criteria

• Interface result: The selected hidden worksheet appears again in the tab bar.
• What you can do next: After it is restored, you can open and edit that worksheet directly.

Tips While Using

• The Unhide command is useful only when the workbook already contains hidden sheets.
• Check the worksheet name before confirming to avoid restoring the wrong sheet.

4. Unhide a Sheet from the Ribbon

Feature entry: Home tab → Worksheet → Unhide Sheet

1. Click the Home tab.
2. Open the Worksheet menu.
3. Click Unhide Sheet.
4. In the dialog box, select the worksheet that you want to show.
5. Click OK.

Success Criteria

• Interface result: The selected worksheet appears again in the tab bar.
• What you can do next: The restored worksheet can be viewed, edited, and switched to normally.

Tips While Using

• If there are no hidden sheets, the dialog box will not provide a sheet to restore.
• In workbooks with many sheets, confirm the sheet name before restoring it.