Office Settings & Configuration

How to Unhide a Hidden Excel Workbook or Worksheet on Mac

Maira Mehtab Oct 20, 2026 869 views

Question details

The user needs to restore the visibility of an entire Excel workbook or specific individual worksheets that have been hidden on a Mac.

How to Unhide a Hidden Excel Workbook or Worksheet on Mac

Product: Microsoft Excel
Device & OS: Mac
Scenario: Opening an Excel file but being unable to see the expected contents, either because the entire application window shows no active workbook, or specific sheet tabs are missing.
Observed behavior: The Excel application launches and the file opens, but the workbook contents are not visible on the screen, or certain worksheet tabs are absent from the bottom navigation bar.

Before you start

Ensure that your Excel application is open and the target file is fully loaded, even if the application window appears blank or grayed out.

Solution 1Recommended

Unhide an Entire Excel Workbook

Use this method if you open an Excel file and the entire window appears empty without any gridlines or cells visible.

Sometimes an entire workbook is hidden from view rather than closed. You can restore it using the tools available in the main ribbon.

Navigate to the View tab

With the Excel application active on your Mac, look at the top ribbon menu and click on the 'View' tab.

Click on Unhide

In the Window group of the View ribbon, locate and click the 'Unhide' button to open the Unhide dialog box.

Select and restore the workbook

Select the name of your hidden workbook from the list provided in the dialog box, then click 'OK' to make it visible again.

Disabled Unhide Button: If the 'Unhide' button is grayed out, it means there are no hidden workbooks currently open in your Excel application.

Solution 2

Unhide Specific Excel Worksheets

Follow these steps if your workbook is visible but specific sheet tabs are missing from the bottom of the window.

Manage Spreadsheets Easily

Unhide Workbooks and Worksheets Effortlessly in WPS Office

WPS Office provides an intuitive and user-friendly spreadsheet tool that makes managing hidden sheets and workbooks incredibly simple on your Mac.

1. Open your file in WPS Office: Launch WPS Office on your Mac and open your spreadsheet document.
2. Access the View settings: Click on the 'View' tab in the top ribbon to manage your overall workbook visibility.
3. Unhide the workbook or sheet: Click 'Unhide Window' to reveal hidden workbooks, or simply right-click any sheet tab at the bottom to unhide specific missing worksheets.

Easily unhide workbooks, rows, columns, and worksheets with a highly intuitive user interface.Fully compatible with Microsoft Excel formats, including .xlsx, .xls, and .csv.Free, lightweight, and fast spreadsheet editor designed for Mac and other major platforms.

microsoft office alternative - wps office

Frequently Asked Questions

Why is the Unhide option grayed out when I right-click a sheet tab?

The Unhide option is grayed out if there are no hidden worksheets in the current workbook, or if the workbook structure is protected by a password, which prevents sheets from being hidden or unhidden.

Can I unhide multiple worksheets at once in Excel for Mac?

In Microsoft 365 or newer versions of Excel for Mac, you can unhide multiple sheets at once. Simply hold down the Command key while selecting multiple sheets in the Unhide dialog box, then click OK. Older versions require you to unhide them one by one.

How do I hide a workbook or worksheet again?

To hide an entire workbook, go to the View tab and click 'Hide' in the Window group. To hide a specific worksheet, right-click its sheet tab at the bottom and select 'Hide' from the context menu.

Does hiding a worksheet delete its data or affect formulas?

No, hiding a worksheet only removes it from your immediate view. All data, formulas, and cell references remain completely intact and will continue to calculate normally in the background.

Office App Problems