Restore Hidden Sheets and a Disabled Ribbon in Excel
Question details
The user needs to restore access to worksheets and ribbon commands in Excel.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- An Excel workbook appears without visible worksheets, and the user cannot access the ribbon normally.
- Observed behavior
- All worksheets appear hidden, and the ribbon is disabled or not fully visible.
Open the affected workbook in Excel and check whether its window, sheet tabs, or only the ribbon commands are missing. If workbook structure protection is enabled, have the correct password available.
Unhide the workbook and restore sheet tabs
Use these display settings when the workbook window or worksheet tabs are hidden.
In Excel, select View > Unhide. If a workbook appears in the list, select it and choose OK.
In Excel for Windows, select File > Options > Advanced. Under Display options for this workbook, select the affected workbook, check Show sheet tabs, and select OK.
Right-click a visible sheet tab, select Unhide, choose a hidden sheet, and select OK. Repeat as needed.

Remove workbook structure protection
Use this when workbook structure protection prevents you from unhiding worksheets.
Restore the ribbon and enable editing
Use these checks when ribbon commands are collapsed or unavailable.
Work with spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files and continue working with them in WPS Spreadsheets for an easy move between office suites.

Frequently Asked Questions
Why is View > Unhide unavailable in Excel?
View > Unhide is unavailable when there is no hidden workbook window to restore. To unhide a worksheet instead, right-click a visible sheet tab and select Unhide.
How do I show missing sheet tabs in Excel for Windows?
Go to File > Options > Advanced. Under Display options for this workbook, select the workbook and check Show sheet tabs.
Why can't I unhide a worksheet?
Workbook structure protection may prevent changes to sheet visibility. Check Review > Protect Workbook and turn off protection with the correct password before using the sheet tab's Unhide command.
How do I bring back Excel's ribbon commands?
Select Ribbon Display Options near the top of the window and choose Show Tabs and Commands or the equivalent option in your Excel version. If commands remain unavailable, check for a Protected View message or an open dialog.




