You might want to hide several worksheets while using Excel to work with data that is dispersed across several worksheets. The amount of complexity can be reduced or certain data can be avoided by hiding some worksheets and leaving only the most useful ones visible. 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.
How to Unhide Multiple Sheets in Excel: 4 Handy Ways
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.
- 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.
- 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.
- Finally, it will reveal all the chosen sheets below.
Read More: How to Open New Sheet in Excel
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.
- 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.
- 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.
- Lastly, all of the selected sheets will be presented here.
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.
- 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.
- 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.
- Finally, this image will showcase all of the chosen sheets.
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.
- 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.
- Here, the Visual Basic window will open.
- After that, from the Insert option, we will choose the new Module to write a VBA code.
- 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
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.
- As a result, the resulting image will unhide each sheet clearly.
Download Practice Workbook
You may download the following Excel workbook for better understanding and practice it by yourself.
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. If you have any questions, comments, or recommendations, kindly leave them in the comment section below.