16. Excel Tips - Hiding sheets - secret trick
There are 2 ways to hide a sheet.
Most people know the first way:
Format => Sheet => hide
Not many know the second way:
Press ALT + F11 to bring up the VBA editor.
.. and change the visible option as shown:
To the untrained eye, this Very Hidden sheet is difficult to find.
If you don't see the "properties" box, single click on "Sheet2" and press F4
Training Video on how to hide sheets:
»
- Nick's blog
- Login or register to post comments
- 7321 reads
Recent comments
5 years 34 weeks ago
6 years 20 weeks ago
6 years 32 weeks ago
6 years 35 weeks ago
6 years 36 weeks ago
6 years 42 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago