Hide Excel Sheet/Tab – Complete Guide

Excel Short Cut Tricks

When I was creating an excel dashboard, there were multiple sheets which I used for calculation purpose and never wanted anybody to make any changes on it. So I found very awesome feature to hide an excel tab:

Though there are multiple ways to hide the excel sheet tab:

1. Hide From Home Menu
  • Select the Sheet which you want to hide and Go To “Cells” Section under Home Menu as shown in below picture:

Excel Tricks

Once you hide the sheet, you may unhide the same through “Unhide Sheet” option.

Note: Sheet should not be protected while hiding the sheet

2. Hide From Right Click on Sheet Name
  • You may also hide the sheet in just a single right click on Sheet Name and unhide the same on just one right click on any sheet tab name. See below:

Excel Tricks

 

3. Disable the option to Unhide Sheet
    • You learnt how to hide the sheets above however there are instances when you do not want to allow any user to see Hidden Sheets. So you can do this also by using “Very Hidden” feature

 

    • Go To VBA Editor Window either of below step:

1. Press “ALT+F11” on the workbook where you wanted to perform this “Very Hidden” functionality
2. Right Click on any Sheet Tab, Click on View Code

    • Here you can see in below image that how to open VBA Editor Window

 

Excel Tricks

 

    • Once you open the VBA Editor window, you will see your sheet name on the left side as below:

 

Excel Tricks

 

    • Click on “View” from “Menu” option. Then Go To “Properties Window”. See Below:

 

Excel Tricks

 

    • Go To “Properties” window and select “2–xlSheetVeryHidden” under “Visible” category. Please see below:

 

Excel Tricks

    • Now Go back to excel workbook and when you will right click on sheet tab, you will not find the option to Unhide the sheet. See below Image:

 

Excel Tricks

So this is a complete guide of hiding sheets/tabs in a workbook. Hope you liked it.

Author:
Excelsirji.com was started with the thought of making people experience easy while working with Excel, data analytics, vba, automations etc.

Leave a Reply

avatar