How do you unhide a worksheet that is missing from the Unhide list?

If the sheet doesn't appear in the Unhide dialog, it is 'very hidden' — usually set by VBA. Press Alt+F11 to open the VBA editor, select the sheet in the Project Explorer, and set its Visible property to -1 (xlSheetVisible).

How do you unhide multiple worksheets at once in Excel?

In Microsoft 365 you can hold Ctrl and click several sheets in the Unhide dialog, then click OK. Older versions hide one at a time unless you use a macro or add-in.

How do you unhide a worksheet in Excel on a Mac?

The steps are the same: Control-click (or right-click) a sheet tab, choose Unhide, and pick the sheet. Very hidden sheets still need the VBA editor (Alt+F11).

Can you unhide a worksheet without the password?

No. If workbook structure protection uses a password, Excel will not let you unhide sheets without it. Removing someone else's protection without permission is not supported.

How Do You Unhide a Worksheet in Excel? (Direct Answer + Fixes)

DIRECT ANSWER

How Do You Unhide a Worksheet in Excel?

💡 The short answer

Right-click any visible sheet tab at the bottom of the workbook → choose Unhide → select the hidden sheet from the list → click OK. That's it — the tab slides back into view. Prefer the menu? Use Home → Format → Hide & Unhide → Unhide Sheet.

Hidden worksheets keep all their data and formulas intact — they're just tucked out of the way, usually on purpose. Unhiding takes under five seconds and works the same on Windows and Mac (on Mac, right-click = Control-click, or just right-click if you have a two-button mouse).

THREE WAYS TO DO IT

3 Ways to Unhide a Worksheet

🖱️ Right-Click the Tab

Fastest — the menu is already in front of you

Right-Click tab

Right-click any visible tab → Unhide → OK

📋 Home Menu Route

Useful when no tab feels handy to click

Home → Format → Unhide Sheet

Format dropdown → Hide & Unhide → Unhide Sheet

🎯 Select All Hidden

When several sheets are hidden at once

Ctrl + Click each

Microsoft 365: multi-select in the Unhide dialog

✅ Done? The tab reappears at the bottom and you can click straight into it. Nothing was deleted — hiding never removes data.

STEP BY STEP

Follow Along: Unhide a Worksheet Right Now

1

Right-click any visible sheet tab

Any tab you can still see will do — right-click it (Control-click on Mac). The shortcut menu opens with an Unhide… option at the bottom.

💡 If the option is grayed out, jump down to the "Can't Unhide?" section — your workbook structure is likely protected.

2

Choose the hidden sheet from the list

The Unhide dialog lists every hidden sheet in the workbook. Click the one you want — or hold Ctrl to pick several at once if you're on Microsoft 365.

3

Click OK and start working

Excel brings the sheet back and switches to it. All content, formulas, and formatting are exactly where you left them.

4

No right-click? Use the ribbon instead

On the Home tab, click Format (in the Cells group) → hover Hide & Unhide → Unhide Sheet…. Then pick the sheet and click OK.

Keyboard: Alt+H+O+U+H (Windows) gets you to Unhide Sheet

TROUBLESHOOTING

Can't Unhide? Match Your Problem

Symptom	Why	Fix
🚫Unhide option is grayed out	Workbook structure is protected	Review → Unprotect Workbook (enter password if prompted)
🔍Sheet missing from the Unhide list	Sheet is set to "very hidden" via VBA	Use VBA to flip Visible to `xlSheetVisible` (steps below)
👁️Tab is back but sheet looks empty	Rows/columns hidden, or window scrolled off	Select all → Format → Row/Column → Unhide

Fix the "very hidden" sheet (the one that won't show in the list)

1

Open the VBA editor

Press Alt + F11 (Windows) or Fn + Option + F11 (Mac).

2

Select the hidden sheet

In the Project Explorer (left panel), click the worksheet that's missing from the Unhide dialog.

3

Change its Visible property

In the Properties window, set Visible from 2 - xlSheetVeryHidden to -1 - xlSheetVisible. Close the editor and the sheet reappears.

💡 Quicker still — a one-line macro: paste this into a module and run it to make every sheet visible at once:

Sub UnhideAllSheets()
  Dim ws As Worksheet
  For Each ws In ThisWorkbook.Worksheets
    ws.Visible = xlSheetVisible
  Next ws
End Sub

⚠️ A note on protected workbooks: If "Unprotect Workbook" asks for a password you don't have, Excel won't let you unhide the sheets. Only the workbook owner (or someone with authorization) can remove structure protection. Very-hidden sheets often hide sensitive data — confirm you have permission before poking at them.

MAC USERS

Unhiding on Mac Excel

Same flow as Windows:

Control-click (or right-click) any sheet tab → Unhide → pick the sheet → OK.
Or use the Format menu on the ribbon → Hide & Unhide → Unhide Sheet….
Very-hidden sheets still need the VBA editor — press Fn + Option + F11.

✅ One habit worth keeping: If a workbook looks like it's "lost data," check for hidden sheets before assuming anything was deleted — hiding is reversible in one click.

FREQUENTLY ASKED

Common Questions About Unhiding Worksheets

How do you unhide a worksheet in Excel?

Right-click any visible sheet tab and choose 'Unhide'. Pick the hidden sheet in the dialog and click OK. Or use Home > Format > Hide & Unhide > Unhide Sheet.

Why is the Unhide option grayed out?

The workbook structure is protected. Go to Review > Unprotect Workbook and enter the password if asked, then Unhide becomes available.

What if my worksheet isn't in the Unhide list?

It's likely set to 'very hidden' by VBA. Open the VBA editor (Alt+F11), select the sheet, and set its Visible property to -1 (xlSheetVisible).

Can I unhide several worksheets at once?

Yes, in Microsoft 365 hold Ctrl and click each sheet in the Unhide dialog before hitting OK. Older versions hide/unhide one at a time without a macro.

Does hiding a worksheet delete its data?

No. Hiding only makes the tab invisible; every cell, formula, and format stays intact and unhides instantly.

How do I unhide a worksheet if the workbook is password-protected?

You need the structure-protection password. Unprotect the workbook under Review, then unhide normally. Bypassing someone else's password isn't supported.

CONTINUE LEARNING