How to Hide and Unhide Worksheets in Excel
Pinterest Whatsapp
Advertisement

Need to tidy up an Excel document? Here’s how to hide one or more worksheets.

Excel is a very powerful piece of software, and it can produce spreadsheets that are packed with functionality 3 Excel Dashboard Tips You Have to Try 3 Excel Dashboard Tips You Have to Try Use our Excel dashboard tips to organize and show off data from a complex spreadsheet. With your neat dashboard, you'll see key data points at a glance. Read More . However, sometimes these documents can get rather unwieldy.

One way to make them a little more user-friendly is to hide Sheets that aren’t used on a regular basis. This might be a result of certain Sheets being archived, or using a Sheet as a means of setting up functions or formulas behind the scenes.

You don’t have to delete content from an Excel file in order to render it inaccessible. Here’s our guide on how to hide Sheets from view.

How to Hide a Worksheet in Excel

Hiding a sheet in Excel is a snap. You can do it in just a few simple steps:

  1. Click the sheet you want to hide.
  2. Navigate to Home > Cells > Format.
  3. Under Visibility, click Hide Sheet.
  4. To unhide the sheet, repeat steps 1 through 3, but now click Unhide.

Hey presto, your sheet will be hidden from view until you change these settings. Need to hide multiple sheets at once or hide sheets extra well? We have a few more methods in store for you.

Hiding Multiple Excel Worksheets

Excel allows users to hide one or more worksheets at once, it’s all a matter of how you make your selection. If you only need to hide a single sheet, you can click it as normal. Otherwise, hold down Shift to select adjacent sheets, and Control if they’re non-adjacent.

how to hide and unhide sheets in excel

As you can see above, I’ve chosen to select Sheet2 and Sheet3. Once your selection is made, head to the Cells section of the Home tab and looks for Format.

how to hide and unhide sheets in excel

Use the Format dropdown menu to access Hide & Unhide and then select Hide Sheet.

how to hide and unhide sheets in excel

Now, look to the Sheet tabs and your selection should be hidden.

how to hide and unhide sheets in excel

Here’s a handy shortcut These Excel Shortcuts Will Save You Time and Effort These Excel Shortcuts Will Save You Time and Effort Read More for when you’re comfortable with hiding Sheets: use Alt + O, then press H twice in a row.

Unhiding a Worksheet in Excel

You can unhide a Sheet the same way that you hid it, but there’s a quicker alternative. Right-click a Sheet’s tab and select Unhide.

how to hide and unhide sheets in excel

This will open up the dialog below:

how to hide and unhide sheets in excel

Just click the Sheet you want to reveal, then click OK.

Of course, the above method demonstrates just how easy it is for someone else to unhide a sheet that you’ve hidden. If you’re really looking to keep something concealed, then you’ll have to resort to using Visual Basic How to Build a Custom Excel Toolbar of VBA Macros How to Build a Custom Excel Toolbar of VBA Macros Ready to supercharge your Microsoft Excel productivity? A custom toolbar can do just that. We'll show you how to put all your Excel macros within reach. Read More .

Hiding an Excel Worksheet With Visual Basic

Visual Basic can be an intimidating prospect if you’re just getting started The Excel VBA Programming Tutorial for Beginners The Excel VBA Programming Tutorial for Beginners VBA is a Microsoft Office power tool. You can use it to automate tasks with macros, set triggers, and lots more. We'll introduce you to Excel visual basic programming with a simple project. Read More , but this task is actually very straightforward. There’s a property built into Excel that renders a Sheet “very hidden” — it’s just a matter of tweaking a certain value in the Visual Basic Editor.

Open your spreadsheet and open the Visual Basic Editor from the Developer tab. You might need to add the tab to the Ribbon from the Options menu.

how to hide and unhide sheets in excel

Once you’re in the Editor, select the Sheet you want to hide from the Project window.

how to hide and unhide sheets in excel

Then, switch to the Properties window and find the Visible attribute.

how to hide and unhide sheets in excel

Using the dropdown How to Create a Dropdown List in Excel How to Create a Dropdown List in Excel Excel supports versatile dropdown list options. Use them to control user input. We'll show you how to add dropdown lists to your Excel spreadsheets. Read More , we can switch to Hidden, which is the same as the normal controls we just went through. We can also select Very Hidden, which means that anyone using the spreadsheet has to dip into Visual Basic in order to reveal the sheet.

This is useful if you want to ensure that no one will accidentally make changes, or if there’s something that you want to keep out of sight for other reasons. The Unhide option won’t appear as it would normally, so it will be impossible to detect the extra sheet without accessing the Visual Basic Editor.

Select Very Hidden, then head back to Excel. Your Sheet will be obscured, and the Unhide option should be grayed out.

how to hide and unhide sheets in excel

In order to reverse the process, just open up the Editor and change the parameter back.

Be Careful What You Hide

Being able to hide a particular Excel worksheet can come in very handy, but it can also cause some major headaches.

If you pass on ownership of the document 5 Excel Document Settings You Must Never Forget to Check 5 Excel Document Settings You Must Never Forget to Check When you pick an Excel template or share a spreadsheet, it may contain custom settings that you don't want anyone to see. Always check these settings. Read More to another person, make sure they’re aware of any Sheets that you may have hidden. Otherwise, they may be left scratching their head trying to figure out where certain values are being sourced from, or how a particular function is set up.

Do you have any tips on how to hide and unhide Sheets effectively in Excel? Are you looking for assistance with a technique from this guide? Why not join the conversation in the comments section below?

Enjoyed this article? Stay informed by joining our newsletter!

Enter your Email

Leave a Reply

Your email address will not be published. Required fields are marked *