Forum Discussion

Wendykilo's avatar
Wendykilo
Iron Contributor
Aug 14, 2025

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:

  1. Press Alt + F11 to open VBA.
  2. In the Project Explorer, right-click a sheet → Properties.
  3. 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.

Resources