How to Unhide Excel Worksheet (Fix Gray Button + Very Hidden)

Q: What if I can't find the hidden worksheet in the Unhide dialog?

It's likely very hidden. Use VBA Editor to change its Visible property.

TWO TYPES OF HIDDEN

Regular hidden vs "Very Hidden" — know which you have

Type	Shows in Unhide dialog?	How to reveal
Hidden	✅ Yes	Right-click tab → Unhide
Very Hidden	❌ No	VBA: `xlSheetVisible`

QUICK DIAGNOSIS

What's your unhide issue?

Your Symptom	Reason	Solution
🔘 No "Unhide" in right-click menu	Workbook structure is protected	✅ See "Fix Gray Button" Tab
🔍 Target sheet missing from dialog	Sheet is set to "Very Hidden"	✅ See "Very Hidden Recovery" Tab
📋 Multiple sheets hidden	Excel defaults to single-select	✅ See "Batch Unhide" Tab
👁️ Unhidden but still no content	Rows/columns or window hidden	✅ Check rows/columns or unhide window

⚠️ Critical Warning: Before unhiding, confirm the HIDDEN TYPE! Regular hidden, very hidden, and workbook protection have COMPLETELY different recovery methods.

UNHIDE METHODS

Choose Your Method

Fix Gray Button (Standard Unhide)

Use this when the right-click "Unhide" button is gray, or the target sheet is missing from the dialog.

1

Unprotect the Workbook Structure

If the "Unhide" button is gray, the workbook structure is protected. Go to Review → Unprotect Workbook (enter password if required).

2

Right-Click Any Visible Sheet Tab

Right-click any visible worksheet tab → Select Unhide.

3

Select the Target Sheet

Choose the hidden sheet from the dialog → Click OK.

⚠️ Safety Alert: If you forgot the workbook protection password, you must use VBA or XML methods to remove workbook protection first!

✅ Pro Tip: The sheet name appears in the Unhide dialog in parentheses — this confirms it's a regular hidden sheet (recoverable via this method).

Batch Unhide (Multiple Sheets at Once)

Recover multiple hidden sheets simultaneously — great for monthly reports and multi-sheet summaries.

1

Microsoft 365 Users: Multi-Select

In the Unhide dialog, hold Ctrl and click each sheet you want → Click OK. All selected sheets unhide at once!

2

Older Versions: Kutools Plugin

Use Kutools' Show All Hidden Sheets feature to unhide every hidden sheet in one click.

3

VBA Method

Run this code to unhide ALL sheets:

Sub UnhideAll()

  Dim ws As Worksheet

  For Each ws In Worksheets

    ws.Visible = xlSheetVisible

  Next ws

End Sub

💡 Scenario Tip: Perfect for monthly reports where you hid previous months' sheets and need them all back quickly.

⚠️ Limitation: Older Excel versions (pre-365) only support single-select in the Unhide dialog — you'll need Kutools or VBA for batch unhide.

Very Hidden Recovery (VBA)

Use this when the target sheet is missing from the Unhide dialog — it's been set to "Very Hidden" via VBA.

⚠️ Security Note

Very hidden sheets often contain sensitive data or macros. Confirm you have permission before recovering them!

1

Open VBA Editor

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

2

Select the Target Sheet

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

3

Change the Visible Property

In the Properties window, find Visible → Change it from 2 - xlSheetVeryHidden to -1 - xlSheetVisible.

4

Close VBA Editor

Close the editor (Alt+Q). The sheet now appears in your workbook!

✅ Value Point: This is the ONLY method that recovers "very hidden" sheets — essential for advanced users managing sensitive workbooks.

ABOUT THIS GUIDE

About This Guide

Not all hidden sheets are hidden the same way. This page separates regular hidden, very hidden (VBA), and structure-protected sheets, then gives the matching recovery method for each situation.

FREQUENTLY ASKED

Frequently Asked Questions

Why is the "Unhide" button gray in Excel?

The workbook structure is protected. Go to Review > Unprotect Workbook (password required).

How to unhide a very hidden worksheet?

Use VBA Editor (Alt+F11), select the sheet, and change Visible property to -1 (xlSheetVisible).

Can I unhide multiple worksheets at once?

Yes! Microsoft 365 supports multi-select in the Unhide dialog. Older versions need Kutools or VBA.

How to unhide a worksheet on Mac?

Right-click sheet tab > Unhide. For very hidden sheets, use VBA Editor (Alt+F11) as on Windows.

What if I can't find the hidden worksheet in the Unhide dialog?

It's likely "very hidden". Use VBA Editor to change its Visible property.

How to unhide a hidden window in Excel?

Go to View > Unhide, select the window, and click OK. This is different from worksheet unhide.

CONTINUE LEARNING

Recovered Your Worksheet? Keep It Visible!

🛡️

Protect Unhidden Worksheets

Prevent accidental hiding or deletion of your recovered sheets.

Learn More →

🔀

Combine Worksheets

Merge your unhidden sheets into one. Consolidate, VSTACK, and VBA methods.

Learn More →

🔍

Find Answers in Sheets

Search your unhidden worksheets for answers. Search techniques and verification.

Learn More →

QUICK LINKS

Continue Exploring

SOURCES

Sources & References

This guide was written and fact-checked against Microsoft's official Excel documentation.

Hide or unhide worksheets — Microsoft Support