Forum Discussion
Wendykilo
Aug 14, 2025Iron Contributor
Excel’s "Very Hidden" Sheets… even the Unhide menu can’t find them
Just learned that Excel has a "Very Hidden" sheet state.
Unlike normal hidden sheets, these don't show up in the “Unhide” menu at all.
To create one:
- Press Alt + F11 to open VBA.
- In the Project Explorer, right-click a sheet → Properties.
- Change Visible from -1 (Visible) or 0 (Hidden) to 2 (Very Hidden).
Now, only VBA (or the Developer tab) can bring it back. Perfect to keep things tidy or prevent accidental edits.
Did anyone else know about this ninja-level Excel feature?
1 Reply
Good for you that you found this useful feature, well done!
Not to rain on your parade, but many Excel developers know about it.