Hide and Unhide Excel Worksheets from a Workbook
Hi folks, we hope you are learning a great deal from our series on workbook and worksheet management. If you missed out on any information visit our archives as we have already discussed viewing workbooks and worksheets, making them adept for multitasking. We thought you might be little bored with all the learning and no play so this post is about hide and seek.
In some situations, you may want to hide one or more worksheets. Hiding a worksheet may be useful if you want to make the worksheet invisible for some reasons. When a worksheet is hidden, its sheet tab is also hidden. An important thing to remember here is that you can’t hide all the worksheets. At least one worksheet must be visible in a workbook.
Table of Contents
Hide and unhide a single worksheet from the workbook
In this workbook (below image), there are five worksheets: Revenues worksheet, Sales worksheet, Accounts worksheet and two blank worksheets Sheet4 and Sheet5.
You can hide a worksheet in two ways. Say I want to hide the Sales worksheet. The first way is right click on the Sales worksheet tab, a shortcut menu appears. In the list, you will find two options: Hide and Unhide. Unhide option is dim right now as there is no worksheet hidden in this workbook. Select the “hide” command from the list.
The Sales worksheet is hidden. To unhide the hidden worksheet, right-click on any worksheet tab, choose Unhide from the list, Unhide dialog box appears.
Choose Sales and click OK to unhide the Sales worksheet.
Remember one thing here, Sales was in between Revenues and Accounts worksheets. When I unhide the Sales worksheet, it appears exactly in the same location it was before hiding.
In another way, you can use the Hide Sheet command in the Home Ribbon.
Hiding more than one worksheet
This time I want to hide three worksheets at a time. I select Sales worksheet tab, press and hold the CTRL key on my keyboard, and select tabs Accounts and Sheet4.
Then I click on the Format drop down in the Home ribbon, then Hide & Unhide control, and finally click on the Hide Sheet command.
Sales, Accounts and Sheet4 worksheets are hidden from the tab list.
To unhide again the worksheets, I click again on the Format drop down in the Home ribbon, then Hide & Unhide control and then click on the Unhide sheet command.
Unhide dialog box appears. Though you can hide more than one worksheet in one go, but you can’t unhide all the hidden worksheets in one click. You will have to unhide one by one.
You can’t hide all the worksheets from the list. Let’s try to hide all the worksheets in this workbook. I select all the worksheets, and right click on worksheet tab, and select Hide option from the list.
Microsoft Excel dialog box comes with a warning message: “A workbook must contain at least one visible worksheet”. I click OK, the dialog box disappears.
So that’s it for today folks! Keep excelling, do post us your questions or feedbacks in the comments.