Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Unhide Multiple Sheets in Excel (4 Ways)

You might want to hide several worksheets while using Excel to work with data that is dispersed across several worksheets. By hiding some worksheets and leaving only the ones that are actually useful visible, you may be able to reduce the amount of complexity or avoid showing your customers or management certain data. And occasionally, you might want to unhide some or all of the worksheets in a workbook that has some concealed pages. In this article, we will show you how to unhide multiple sheets in Excel.


Download Practice Workbook

You may download the following Excel workbook for better understanding and practice it by yourself.


4 Handy Ways to Unhide Multiple Sheets in Excel

A single Excel sheet can be hidden or unhidden with equal ease. But it’s critical to comprehend the procedure if you’re a novice user. The sheet can be revealed in a number of ways. Unhiding numerous sheets at once in a workbook is quite different. As a result, you will learn how to use the Format Tool, Keyboard Shortcuts, Unhide command, and VBA Code to unhide numerous sheets in Excel.


1.  Using Keyboard Shortcuts to Unhide Multiple Sheets

One or more keys are used as keyboard shortcuts to carry out menu functions or other typical tasks in an application or operating system. In general, keyboard shortcuts are less natural to use than point-and-click mouse actions. However, beginner users can use them in programs that they routinely use to navigate to places far more quickly than using the mouse. In the first step, we will use a keyboard shortcut to unhide multiple sheets in Excel.

Step 1:

  • Keyboard shortcuts is the sole sheet that is now visible, but we want to make all the sheets available below.
  • Simply press ALT+H+O+U+H in this section to bring up the unhide sheet box.

Sample Data Set

Step 2:

  • This will now reveal the window below.
  • As per usual, choose all the worksheets you want to reveal by holding down Ctrl.
  • Then, click OK.

Sample Data Set

Step 3:

  • Finally, it will reveal all the chosen sheets below.

Sample Data Set

Read More: How to View All Sheets in Excel at Once (5 Easy Ways)


2. Utilizing Format Tool to Unhide Multiple Sheets in Excel

In this part, you will learn to unhide multiple sheets in Excel by utilizing the Format tool  from the Home tab. Although this strategy is more time-consuming than the one mentioned above, it is always a good idea to be aware of other methods.

Step 1:

  • The only sheet that is now visible is Sheet 1, but we want to make all the sheets accessible.
  • Firstly, go to the Home tab.
  • Secondly, choose the Format tool.
  • Thirdly, open the Hide & Unhide command.
  • Then, click on the Unhide Sheet… option.

Sample Data Set

Step 2:

  • Consequently, this will now make the unhidden box visible.
  • Holding down Ctrl will allow you to select all of the worksheets you want to unhide.
  • Then, click OK.

Sample Data Set

Step 3:

  • Lastly, all of the selected sheets will be presented here.

Handy Ways to Unhide Multiple Sheets in Excel

Read More: How to Unhide All Sheets in Excel Using VBA (4 Examples)


3. Applying Unhide Command to Unhide Multiple Sheets

This is a somewhat easy way to unhide multiple sheets in Excel by doing a right-click on any of the sheets to open the unhide command.

Step 1:

  • Here, we want to unhide all the sheets below available, even if the Unhide command sheet is the only sheet that is now visible.
  • Now, right-click on any of the sheets available here to open this dialog box below.
  • Then, choose the Unhide command.

Handy Ways to Unhide Multiple Sheets in Excel

Step 2:

  • As a result, the unhide box will now be visible.
  • After that, you can choose all of the worksheets you want to unhide by holding down Ctrl.
  • Then, click OK.

Sample Data Set

Step 3:

  • Finally, this image will showcase all of the chosen sheets.

Handy Ways to Unhide Multiple Sheets in Excel

Read More: How to Unhide Very Hidden Sheets in Excel (2 Effective Methods)


4. Applying VBA Code to Unhide Multiple Sheets in Excel

VBA is a programming language that may be used for a variety of tasks, and different types of users can use it for those tasks. Using the Alt + F11 keyboard shortcut, you can launch the VBA editor. In the last section, we will generate a VBA code that makes it very easy to unhide multiple sheets in Excel.

Step 1:

  • Firstly, we will open the Developer tab.
  • Then, we will select the Visual Basic command.
  • Here, only one sheet is visible, named “VBA Code” but we want to unhide all the sheets below.

Handy Ways to Unhide Multiple Sheets in Excel

Step 2:

  • Here, the Visual Basic window will open.
  • After that, from the Insert option, we will choose the new Module to write a VBA code.

Handy Ways to Unhide Multiple Sheets in Excel

Step 3:

  • Now, paste the following VBA code into the Module.
  • To run the program, click the “Run” button or press F5.
Sub Unhide_Multiple_Sheets()
'Declaring variables
Dim Mysheet As Worksheet
'Using For each loop through each sheet
For Each Mysheet In ActiveWorkbook.Worksheets
'Unhiding each sheet
Mysheet.Visible = xlSheetVisible
Next Mysheet
End Sub

Handy Ways to Unhide Multiple Sheets in Excel

VBA Code Breakdown

  • Firstly, we specify a name for the subject as Unhide_Multiple_Sheets().
  • Secondly, we declare a variable as Dim Mysheet As Worksheet.
  • Finally, we will unhide all the sheets in a workbook as Visible = xlSheetVisible.

Step 4:

  • As a result, the resulting image will unhide each sheet clearly.

Handy Ways to Unhide Multiple Sheets in Excel


Conclusion

In this article, I’ve covered 4 handy methods to unhide multiple sheets in Excel. I sincerely hope you enjoyed and learned a lot from this article. Additionally, if you want to read more articles on Excel, you may visit our website, Exceldemy. If you have any questions, comments, or recommendations, kindly leave them in the comment section below.


Related Articles

Bishawajit Chakraborty

Bishawajit Chakraborty

I'm Bishawajit Chakraborty. Hello. I graduated from Rajshahi University of Engineering & Technology (RUET) with a degree in Mechanical Engineering. I'm working with ExcelDemy as a Content Developer for Excel & VBA. You can visit our website, Exceldemy if you'd like to read my published articles on MS Excel and VBA.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo