How to find the very hidden sheets in an Excel workbook
A workbook that looks clean can still carry sheets you can't see — an old pricing model, the source data behind a chart, a client tab from the last version. Some of them don't even show up in Excel's Unhide dialog. Here's how to find them before you send the file.
The three visibility states
Every worksheet in an .xlsx file has a visibility state stored in the workbook XML. There are three of them:
- Visible — a normal tab you can see and click.
- Hidden — the tab is gone from the strip, but you can bring it back by right-clicking any tab and choosing
Unhide. - Very hidden — the state is set to
veryHiddenin the XML. This sheet does not appear in the Unhide dialog at all, so most people never learn it exists. It can only be revealed through VBA or by editing the XML directly.
That third state is the one that catches people out. A very hidden sheet is invisible through the normal interface, so it quietly rides along with every copy of the workbook you send — often holding exactly the numbers you didn't mean to share.
veryHidden, the only ways to see it again are VBA or opening the file's XML. Assuming a workbook is clean because the Unhide dialog is empty is exactly how these sheets leak.Hiding a sheet doesn't protect its data
It's worth being blunt about this: hiding a sheet is a display flag, nothing more. The full contents stay in xl/worksheets/ inside the file, uncompressed and readable. Anyone who receives the workbook can unhide an ordinary hidden sheet in two clicks, and a very hidden one with a few lines of VBA. If a sheet holds something sensitive, hiding it is not a safeguard — the data travels with the file either way.
How to check every sheet in Excel
To audit a workbook by hand:
- Right-click any sheet tab and choose
Unhideto reveal ordinary hidden sheets. Bring each one back and look at what it holds. - For very hidden sheets, open the VBA editor with
Alt+F11. In the Project pane every worksheet is listed regardless of state; select one and set itsVisibleproperty to-1 (xlSheetVisible)to expose it. - Review each sheet you find, then decide whether it belongs in the copy you're sending.
This works, but it's manual, it needs macros enabled, and it's easy to miss a sheet. It also does nothing about the author and company metadata stored elsewhere in the file.
A faster check, without uploading the file
Because the file is often the sensitive part, uploading it to an online tool is the wrong move. Barecopy runs entirely in your browser: drop the workbook on the page and it reads the visibility state of every sheet and lists any that are hidden or very hidden, by name, so nothing is buried. The file is never transmitted — you can switch off your internet after the page loads and it still works.
See which sheets are hiding in your workbook
Drop your .xlsx on Barecopy. It flags hidden and very hidden sheets by name, and strips the author, company and comment metadata — locally, on your device.
Why Barecopy flags sheets instead of deleting them
Barecopy detects hidden and very hidden sheets and shows you their names, but it deliberately leaves them in place. That's an honest design choice, not a limitation: deleting a sheet can break formulas, named ranges and chart references elsewhere in the workbook, so silently removing one could quietly corrupt your numbers. The right action is to open the file in Excel, review each flagged sheet, and decide what stays.
So think of this as a detection and awareness feature. The sheets are kept by design; Barecopy makes sure you know about them before you hit send. At the same time it does clean the things that are always safe to remove — the author and "last modified by" names in docProps, the company field, and the authors attached to threaded comments — and that part is free.
Frequently asked
What is a "very hidden" sheet in Excel?
It's a worksheet whose state is set to veryHidden in the workbook XML. Unlike an ordinary hidden sheet, it doesn't appear in the right-click Unhide dialog, so most people never know it's there. It can only be revealed through VBA or by editing the XML — which is exactly why it's a common accidental-leak vector.
Can recipients see the data in my hidden sheet?
Yes. Hiding is only a display flag; the data still lives in xl/worksheets/ inside the file. A recipient can right-click a tab and choose Unhide for an ordinary hidden sheet, or use a little VBA for a very hidden one. Hiding a sheet protects nothing.
Does Barecopy delete hidden sheets?
No. It flags hidden and very hidden sheets by name so you know they're there, but it doesn't remove them, because deleting a sheet can break formulas and references elsewhere in the workbook. Review each one in Excel and decide. Barecopy still strips the standard author, company and comment metadata for free.