How to Delete All Hidden Sheets in Excel at Once

The fastest way to delete every hidden sheet

To delete all hidden sheets in Excel at once, you have two real options: the built-in Document Inspector, or a macro. Deleting them one by one means unhiding each tab, right-clicking, and confirming, over and over. On a workbook with a dozen hidden staging tabs, that's a slow afternoon.

The catch most guides miss: some sheets are "very hidden," a state you can only set through VBA, and they don't show up in the right-click Unhide list at all. Here's how the options compare.

Method	Catches very-hidden sheets?	Asks before deleting?
Unhide + right-click Delete	Only what you can see	Yes, per sheet
Document Inspector	Often misses them	No, removes silently
Free macro	Yes	Yes, one prompt

TL;DR: Key takeaways

• Excel has no one-click menu button to delete every hidden sheet, but two methods get it done fast.
• Document Inspector (File > Info > Check for Issues) removes hidden worksheets, but it also strips other hidden data and can miss very-hidden sheets.
• A free macro deletes every hidden and very-hidden sheet after a single confirmation, and reports the count.
• Deleting a sheet is permanent. There's no undo once you save, so make a backup first.
• If a hidden sheet feeds a formula or named range, deleting it can break those calculations. Check dependencies before you clear it.

First, know what "hidden" really means

Excel worksheets have three visibility states, and this is the part that trips people up.

Visible is normal. Hidden is what you get from right-clicking a tab and choosing Hide. You can bring those back with right-click, then Unhide. Very hidden is the sneaky one: a sheet set to xlSheetVeryHidden through VBA. It doesn't appear in the Unhide list, so most people don't even know it's there.

Legacy workbooks are full of both kinds. A tab someone hid two years ago, a staging sheet a macro made very hidden and never cleaned up. If you want to see what's lurking first, unhide every sheet at once and take a look before you delete anything.

Method 1: Document Inspector (built-in)

Excel's Document Inspector is the native way to strip hidden content before sharing a file.

1. Go to File > Info.
2. Click Check for Issues, then Inspect Document.
3. Click Inspect, then find the Hidden Worksheets result and click Remove All.

It works, but know its limits. It removes hidden worksheets in one go, but it can also strip other hidden data you tick, like comments and document properties, and it does it silently with no per-sheet check. Microsoft's own guide to removing hidden data with Document Inspector warns that deleting hidden sheets with data can change your formula results. It also tends to miss very-hidden sheets, so it isn't the clean sweep it looks like.

Method 2: Delete all hidden sheets with a macro

To delete all hidden sheets in Excel at once, including the very-hidden ones, a macro is the reliable route. Download Delete All Hidden Sheets. It's a free .xlsm file with one macro. No signup, and it runs offline, so your workbook stays on your machine.

First time running one of our macros? See How to run our tools for the 30-second setup.

1. Open the workbook you want to clean, and save a backup copy first.
2. Press Alt + F8, pick DeleteAllHiddenSheets, and click Run.
3. It counts the hidden and very-hidden sheets and asks you to confirm before deleting anything.
4. Click Yes, and it removes them all, then reports how many it deleted.

The key line is how it decides what to delete. Here's the logic:

Sub DeleteAllHiddenSheets()
    Dim ws As Worksheet
    Dim toDelete As New Collection
    Dim i As Long
    For Each ws In ActiveWorkbook.Worksheets
        If ws.Visible <> xlSheetVisible Then toDelete.Add ws   ' hidden AND very hidden
    Next ws
    Application.DisplayAlerts = False
    For i = 1 To toDelete.Count
        toDelete(i).Delete
    Next i
    Application.DisplayAlerts = True
End Sub

Two things matter here. It checks Visible <> xlSheetVisible, so it catches both hidden and very-hidden sheets, not just the ordinary hidden ones that most forum snippets target. And it collects the sheets into a list first, then deletes them, because deleting inside a For Each loop makes Excel skip sheets. The downloadable macro does the same, plus the confirmation prompt.

A word of warning: this can't be undone

Deleting a worksheet is permanent. Undo won't bring it back, and once you save and close, it's gone for good. That's why the macro asks you to confirm first, and why step one is always to save a backup copy.

There's a second risk worth a look. If a hidden sheet holds data that a visible sheet references, a lookup table, a rates sheet, a named range, deleting it will break those formulas and leave #REF! errors behind. Before you clear a workbook you didn't build, audit what the workbook actually depends on so you don't delete the one sheet everything relies on.

Example: cleaning up an inherited workbook

An accountant at a manufacturing firm in Coimbatore takes over a costing workbook built by someone who left years ago. It opens with 6 visible tabs, but the file is 40 MB and slow. Poking around in VBA, she finds 14 more sheets, some hidden, some very hidden, full of abandoned scratch calculations.

Removing them by hand would mean unhiding each one, and the very-hidden sheets wouldn't even show up in the Unhide menu. She'd have to flip each one's visibility in the VBA editor before she could delete it.

Instead she saves a backup, runs the macro, and confirms when it reports 14 hidden sheets. They all go in one pass, the file drops to 9 MB, and it opens quickly again. A morning of spelunking turns into about ten seconds, backup safely in hand.

FAQ

How do I delete all hidden sheets in Excel at once?

Two ways. Use Document Inspector (File > Info > Check for Issues > Inspect Document > Remove All hidden worksheets), or run a macro that deletes every non-visible sheet in one pass. The macro is more thorough because it also catches very-hidden sheets, which Document Inspector often misses.

What is the difference between hidden and very hidden sheets?

A hidden sheet is one you hid with right-click Hide, and you can bring it back with right-click Unhide. A very-hidden sheet is set to xlSheetVeryHidden through VBA, and it does not appear in the Unhide list at all. You can only reveal it by changing its visibility in the VBA editor.

Can I recover a hidden sheet after I delete it?

No. Deleting a worksheet is permanent, and Undo does not restore it. Once you save and close the file, the sheet and its data are gone. Always save a backup copy of the workbook before you delete hidden sheets, so you have a version to fall back on if you cut one you needed.

Does Document Inspector remove very hidden sheets?

Often not. Document Inspector targets ordinary hidden worksheets, so a sheet set to very-hidden through VBA can slip past it, and past most simple macros too. A macro that deletes any sheet whose visibility is not xlSheetVisible catches both states, which is why it's the more complete cleanup.

Will deleting hidden sheets break my formulas?

It can. If a visible sheet references a hidden one through a lookup, a named range, or a direct cell link, deleting that hidden sheet leaves #REF! errors in its place. Microsoft flags this risk too. Check what your formulas depend on before clearing hidden sheets from a workbook you didn't build.

What to do next

Save a backup first. That one habit turns an irreversible action into a safe one.

Download the free Delete All Hidden Sheets macro and run it on a copy of your workbook. It's the thorough way to delete all hidden sheets in Excel at once, very-hidden ones included, with a confirmation prompt so nothing disappears without your say-so. For a first pass, see the full guide to Excel productivity macros.