How to Hide and Unhide Excel Worksheets from a Workbook

If you are looking for how to hide and unhide Excel worksheets from a workbook, then you are in the right place. In some situations, while using Excel, we may want to hide one or more worksheets. Hiding a worksheet may be useful if we want to make the worksheet invisible for some reason. On the other hand, you might need to unhide the hidden worksheets. When a worksheet is hidden, its sheet tab is also hidden. In this article, we’ll try to discuss how to hide and unhide Excel worksheets from a workbook.


Download Practice Workbook


2 Ways to Hide and Unhide Excel Worksheets from a Workbook

Excel offers different methods to hide worksheets. We can hide both single and multiple worksheets at a time by using those methods. And all of them are very handy to apply.


1. Using Right-Click on Sheet Tab

The simplest way to hide and unhide worksheets is to use right-click on the worksheet. We just need to follow some steps.


1.1 Hiding Single and Multiple Worksheets

Suppose we have some worksheets in our Excel file. We just want to hide the Using Right-click worksheet as shown in the below image.

Using Right-click on Sheet Tab

Steps:

  • Firstly, right-click on the name of the worksheet i.e. Using Right-click.
  • Secondly, choose Hide from the options.

hide and unhide excel worksheets from a workbook

  • Eventually, the Using Right-click worksheet will be hidden and we then will have the rest of the worksheets.

hide and unhide excel worksheets from a workbook

Furthermore, we can hide multiple worksheets at a time by following some simple steps. In the picture below, we can see 7 worksheets. We just want to hide all of the worksheets except the Utilizing Format Option sheet. We can’t hide it all because Excel doesn’t allow us to hide all the worksheets from an Excel file.

Steps:

  • Firstly, click all the worksheets we want to hide while pressing CTRL.
  • Secondly, right-click on any of the worksheet names.
  • Thirdly, click Hide.

  • Eventually, all the worksheets we have selected will become hidden.

hide and unhide excel worksheets from a workbook


1.2 Unhiding Single and Multiple Worksheets

Now, we want to unhide the hidden worksheet. It can be single or multiple. The procedure is the same.

Steps:

  • Firstly, right-click on any of the worksheet names. In this case, it is Utilizing Format Option.
  • Secondly, click Unhide.

  • Consequently, an Unhide window will appear. There we will see the names of hidden worksheets. In this case, we have only one worksheet name because we have hidden only one worksheet.
  • Thirdly, we can select any of the worksheets or multiple worksheets (if they exist) from this list. In this case, we have selected Using Right-click.
  • Finally, click OK.

  • Eventually, we have done the unhide of the worksheet Using Right-click. And we can see this at the bottom of the Excel sheet.

hide and unhide excel worksheets from a workbook

In case of unhiding multiple worksheets, just select the worksheets while pressing the CTRL key and choose the Unhide option. Let’s inform us in the comments section if you’re unable to do that.


2. Utilizing Format Option

Using the Format option is another way to hide and unhide worksheets. We can hide and unhide both single and multiple worksheets by using this method.


2.1 Hiding Worksheets

Suppose we have the 5 worksheets shown in the picture below. We need to hide the Utilizing Format Option worksheet.

Utilizing Format Option

Steps:

  • Firstly, select the worksheet we want to hide. Here, it is Utilizing Format Option.
  • Secondly, go to Home > select Cells > choose Format > click Hide & Unhide > select Hide Sheet.

hide and unhide excel worksheets from a workbook

Eventually, we will see that the worksheet is hidden.


2.2 Unhiding Worksheets

Again, if we want to unhide worksheets, go to Home > select Cells > choose Format > click Hide & Unhide > select Unhide Sheet.

Utilizing Format Option

  • Eventually, an Unhide window will appear.
  • Secondly, select the worksheets we want to unhide. Press OK.

hide and unhide excel worksheets from a workbook

Consequently, we’ll see that all of our hidden worksheets are now unhidden.


Using Keyboard Shortcut to Unhide Sheets in Excel

Excel shortcut is a very useful and easy method to unhide sheets. Suppose we have only one sheet named Keyboard Shortcut which is in the unhide mode. We have other sheets too, but they are hidden. We need to unhide them.

Keyboard Shortcut to Unhide Sheets in Excel

Steps:

  • Firstly, press ALT + H + O + U + H.
  • Eventually, an Unhide window will appear.
  • Secondly, select the sheets which we want to unhide. Here we have selected all the sheets because we want to unhide all of them.
  • Thirdly, click OK.

hide and unhide excel worksheets from a workbook

Consequently, all the hidden sheets will now become unhidden like this.


Unhiding Sheets Using Excel VBA

We can also use Excel VBA macro to unhide sheets. Suppose we have only one unhidden sheet which is VBA. We want to unhide other sheets too.

Unhiding Sheets Using Excel VBA

Steps:

  • Firstly, right-click on the sheet name which is VBA.
  • Secondly, select View Code.

hide and unhide excel worksheets from a workbook

  • Thirdly, click View > select Immediate Window.

  • An Immediate window will appear like this.

hide and unhide excel worksheets from a workbook

  • Fourthly, write the following code in the Immediate window.
for each sh in worksheets: sh.visible=true: next sh

  • Finally, press ENTER.
  • Consequently, all the sheets will become unhidden now.

hide and unhide excel worksheets from a workbook


Things to Remember

  • The Custom Views feature does not work with Data Table. The moment when we add a Data Table, the Custom Views feature becomes unusable.
  • We can’t hide all the worksheets at a time because Excel files need a minimum single worksheet to exist.
  • In addition, we can do additional things like unhiding sheets, unhiding sheets by name by using the VBA code.

Conclusion

These are the ways how we can hide and unhide Excel sheets easily if we study this article properly. Please feel free to visit our Excel learning platform ExcelDemy for further queries.

Kawser

Kawser

Hello! Welcome to my Excel blog! It took me some time to be a fan of Excel. But now I am a die-hard fan of MS Excel. I learn new ways of doing things with Excel and share them here. Not only how-to guide on Excel, but you will get also topics on Finance, Statistics, Data Analysis, and BI. Stay tuned! You can checkout my courses at Udemy: https://www.udemy.com/user/exceldemy/

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo