How to Hide or Unhide Sheets in WPS on macOS

Use hide or unhide sheets in WPS on macOS through 4 how-to topics, all available without membership and all completed directly in WPS Spreadsheet.

How-to Index

How-to Guide

1. Hide a Sheet from the Right-Click Menu

Entry point: Right-click a sheet tab > Hide

1. In the sheet tab bar, right-click the sheet tab that you want to hide.
2. Select Hide.
3. The sheet disappears from the tab bar.

Success Criteria

• Interface result: The hidden sheet tab is no longer shown in the tab bar at the bottom.
• What you can do next: You can still switch to, edit, and save the other visible sheets.

Tips While Using

• Keep at least one sheet visible in the workbook.
• Hiding a sheet does not delete its data or formulas.

2. Hide a Sheet from the Home Tab

Entry point: Home tab > Worksheet drop-down menu > Hide Sheet

1. Open the spreadsheet file that you want to manage.
2. Click the Home tab.
3. Open the Worksheet drop-down menu.
4. Click Hide Sheet.

Success Criteria

• Interface result: The target sheet is hidden from the tab bar.
• What you can do next: You can continue editing other sheets or save the workbook.

Tips While Using

• Confirm that the current sheet is the one you want to hide before you start.
• If the workbook has only one sheet, the hide action is usually unavailable.

3. Unhide a Sheet from the Right-Click Menu

Entry point: Right-click any visible sheet tab > Unhide

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

Success Criteria

• Interface result: The selected hidden sheet appears again in the tab bar.
• What you can do next: You can switch to that sheet immediately to review or edit it.

Tips While Using

• If there are no hidden sheets, the Unhide option may be unavailable.
• After a sheet is restored, its data, formulas, and content remain unchanged.

4. Unhide a Sheet from the Home Tab

Entry point: Home tab > Worksheet drop-down menu > Unhide Sheet

1. Click the Home tab.
2. Open the Worksheet drop-down menu.
3. Click Unhide Sheet.
4. In the dialog box, choose the sheet that you want to show again.
5. Click OK.

Success Criteria

• Interface result: The selected hidden sheet appears again in the tab bar.
• What you can do next: You can continue editing, switching, or saving the workbook.

Tips While Using

• If multiple sheets are hidden, confirm the target sheet name in the dialog box before restoring it.
• This action does not require membership.