Office Settings & Configuration

Restore Hidden Sheets and a Disabled Ribbon in Excel

Algirdas JasaitisAlgirdas Jasaitis Nov 18, 2026 869 views

Question details

The user needs to restore access to worksheets and ribbon commands in Excel.

Restore Hidden Sheets and a Disabled Ribbon 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.
Before you start

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.

Solution 1Recommended

Unhide the workbook and restore sheet tabs

Use these display settings when the workbook window or worksheet tabs are hidden.

1
Unhide the workbook

In Excel, select View > Unhide. If a workbook appears in the list, select it and choose OK.

2
Show sheet tabs

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.

3
Unhide worksheets

Right-click a visible sheet tab, select Unhide, choose a hidden sheet, and select OK. Repeat as needed.

Unhide the workbook and restore sheet tabs
When Unhide is unavailable: The workbook may not contain a normally hidden sheet, or its structure may be protected. Check Review > Protect Workbook before trying again.
Free Microsoft Office alternative

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.

Work with worksheets in a familiar spreadsheet interfaceCompatible with Microsoft Excel formats, including XLSX and XLSFree and lightweight for everyday office tasksOpen existing files to make the transition from Microsoft Office easier
microsoft office alternative - wps office

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.