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
- Add new comment
- 1090 reads

Recent comments
5 hours 32 min ago
8 hours 55 min ago
9 hours 18 min ago
15 hours 21 min ago
16 hours 12 min ago
1 day 7 hours ago
1 day 7 hours ago
1 day 10 hours ago
1 day 18 hours ago
2 days 13 hours ago