In this tutorial we’ll take a look at hiding a worksheet in Excel, but more importantly, how to “very hide” a worksheet to keep prying eyes away from your sensitive data.
You can download the file here and follow along. If you get a preview, look for the download arrow in the upper right hand corner.
Here we have a workbook called Very Hidden that has three worksheets:
If I want to hide the “Just Another Sheet”, all I need to do is right click on it, select “Hide” and it will be hidden from view:
It now appears in the dialog box that appears when you right click on any worksheet and choose “Unhide”.
But what if you don’t want others to know you have a hidden worksheet that is so easily accessible? The answer is that make that worksheet VERY HIDDEN!
To do this, open the Visual Basic Editor by using the keyboard shortcut Alt + F11. That will bring up this:
Notice in the upper section on the left you’ll see our workbook with the three worksheets listed below it:
And when you click on any of the worksheets, in the section below it will give you the Properties of that worksheet. The very last property is “Visible”. If you click on the drop down arrow to the right, you will see three options – Visible, Hidden, and Very Hidden. If you choose Very Hidden for the Data worksheet, it will become hidden and when you right click on any of the worksheets in the workbook and choose Unhide, it will not show up in the dialog box:
Now your worksheet is “very hidden” and hopefully won’t be accessible to those just poking around, unless they are familiar with VBA or this particular trick.
To reverse this, just bring up the Visual Basic Editor again (using Alt + F11), select the worksheet you want to view again, and change the property to Visible.
BTW, the workbook that I used for this example is a very popular post of mine called “How To Tie Photos To A Drop Down List Selection In Excel” and here is a link to that and some related tutorials if you are interested in learning how to do that:
What can you do next?
Share this post with others that can benefit from it!
Leave a comment or reply below – let me know what you think!
Subscribe to this blog for more great tips in the future!
Check out my YouTube channel – click on the YouTube icon below!