- There are 2 methods to hide Excel sheets.
- One of them offers more security and makes it harder to find the sheet again.
- They can be performed from the Excel window, without needing to download anything.
If you use Excel for most of your work, you’ll want to understand how to hide an Excel sheet to keep your screen better organized. There are two different ways to do this, one offering more privacy than the other, and they can both be done through Excel with no additional tools.
How to Hide a Sheet in Excel
This is the simplest way to hide a sheet. It’s quick and works in any version of Excel.
Step 1. Open your Excel file.
Step 2. Right-click on the sheet you want to hide.
Step 3. Click on ‘Hide’ in the menu.
The sheet will disappear from the visible bar but it’s still there in the document.
Hiding Multiple Sheets at Once
If you have multiple sheets that you want to hide, it’s easy to hide them all at the same time.
Hold down the ‘CTRL’ button to select multiple sheets at once, then click ‘Hide’.
How to Unhide a Sheet
If you need the sheet to be visible again for any reason, here’s how you can do it.
Step 1. Right-click on any of the sheet tabs you can still see.
Step 2. Click ‘Unhide.’
Step 3. Click on the sheet you want to see then click ‘Ok.’
The sheet should be visible again.
How to Hide a Sheet Using the ‘Very Hidden’ Method
If you don’t want anyone to find your sheet, there’s a different method you can use that adds extra security. This ensures your sheet doesn’t show up on the Unhide menu, so no one else can access it. You need to use the VBA Editor.
Step 1. Open the Excel file.
Step 2. Press Alt + F11 on your keyboard.
Step 3. In the Project window find the file name and click the plus sign.
Step 4. Open ‘Microsoft Excel Objects.’
Step 5. Click on the sheet you want to hide.
Step 6. Press F4 to open the ‘Properties’ window.
Step 7. Click the drop-down menu next to ‘Visible.’
Step 8. Change it from ‘-1 – xlSheetVisible’ or ‘0 – xlSheetHidden’ to ‘2 – xlSheetVeryHidden.’
The sheet should now be completely hidden unless someone knows how to search for it.
How to Unhide a ‘Very Hidden’ Sheet
If you used the VBA method, you’ll need to go back into the same menu to bring the sheet back.
Step 1. Press Alt + F11 to open the VBA window.
Step 2. Go to the Properties section.
Step 3. Find the ‘Visible’ setting.
Step 4. Change it back to ‘-1 – xlSheetVisible.’
This should reveal your sheet again when you open the Excel file.
