

There are many worksheets in your workbook, which are old but you are afraid to delete them? Or you just don’t want people to find your sheet? In this article we learn how to hide worksheets in Excel and how to make them ‘very hidden’.
Contents
You can also do this with many sheets at the same time. Therefore, select all the worksheets you want to hide by pressing Ctrl or Shift when clicking on each sheet name. Next, right click on one of the selected worksheet names and click on ‘Hide’ as described above.
Unhiding sheets works the same way by right clicking on any sheet name (number 1), clicking on Unhide (number 3). A new window opens then in which you can select which sheet you want to unhide. The keyboard shortcut to unhide worksheets on Windows computers is Alt –> o –> h –> u. For more information about how to unhide worksheets, please refer to this article.
But please keep in mind: Hidden worksheets are still there and everybody can unhide them. There is no hint that there are hidden worksheets in a workbook, unless you right-click on a worksheet and click on unhide.
How to make an Excel worksheet “very hidden”
Excel offers another option for hiding sheets. If you don’t want your sheets to be easily unhidden, you can change the visibility to “very hidden”. This can only be done within the VBA editor.
Follow these steps for set the worksheet to very hidden:
For easily unhiding very hidden worksheets please take a look at this article.
Comfortably set sheets to very hidden with Professor Excel Tools.
The Excel add-in “Professor Excel Tools” offers a worksheet manager. You can easily select all the worksheets you want to either
Download and try it for free now. Just click on this link and the download starts immediately.
This function is included in our Excel Add-In 'Professor Excel Tools'
Learn more Download Free Trial
(No sign-up, download starts directly)
More than 10k people on Facebook can't be wrong.
'Professor Excel Tools': Add more than 60 amazing features to Excel!
Professor's Error Helper for Excel: Solve any error in Excel.
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.