Unhide Sheets in Excel

Unhiding Excel Sheets

Unhiding single excel sheet is as easy as hiding them. But as a new learner, it is important to know the process. We can unhide the sheet in several ways we will show each one of them now in this article.

Example #1 – Unhide Single Excel Sheet

There are various ways by which you can unhide single excel sheet.

Method #1

To unhide sheet we need to right-click any of the worksheet tabs.

Once you right-click you could see below options.

In these options select “Unhide” option and you will see list of all the worksheets that are hidden.

Select the worksheet that you want to unhide and click on OK, it will unhide the selected sheet.

Now I can see worksheet named “WS1” in my sheet tab.

Method #2

This method is more tedious than the above one but it is always a good option to know different techniques.

To unhide single excel sheet go to Home > Format > Hide & Unhide > Unhide Sheet

Upon clicking that option as shown in the above image we could see the below window.

As usual, select the worksheet that you want to unhide and click on Ok, it will unhide the selected sheet.

Method #3

Now comes a more efficient one i.e. using Excel Shortcut Key. Yes, we can unhide the sheet using the shortcut key.

Just press ALT + H + O + U + H to open the unhide sheet box.

This will open the below window.

As usual, select the worksheet that you want to unhide and click on Ok, it will unhide the selected sheet.

Example #2 – Unhide Multiple Sheets

So far we have seen ways of unhiding sheets in excel. So far so good but unfortunately we cannot unhide all the sheets at once with the above options. Unhide window can only unhide single sheet at a time, but imagine you have to unhide 10 sheets then repeating the same set of task for 10 times is frustrating. So, how do we unhide all the worksheets once??

We can unhide all the sheets by writing the VBA code in excel, below is the vba code to unhide all the hidden worksheets in the workbook.

Code:

Sub Unhide_All_Worksheets()

    Dim WSht As Worksheet

    For Each WSht In ActiveWorkbook.Worksheets
        WSht.Visible = xlSheetVisible
    Next WSht

End Sub

I have used the “For Each” loop to unhide the worksheet. What you have to do is to copy the above code and go to your worksheet, then press ALT + F11 to open Visual Basic Editor.

Now insert new module under INSERT option.

In the new module paste the copied code.

Now run this code it will unhide all the hidden worksheets in the workbook.

Example #3 – Unhide All Worksheets Except Particular Worksheet

There are situations where we need to unhide all the excel worksheets except the specific worksheet, in such cases also we can use VBA Coding. Assume you want to unhide all the worksheets except the worksheet named as “Workings”.

Below code will do the same.

Code:

Sub Unhide_All_Except_One()

     Dim WSht As Worksheet

     For Each WSht In ActiveWorkbook.Worksheets
         If WSht.Name <> "Workings" Then
         WSht.Visible = xlSheetVisible
         End If
     Next WSht

End Sub

Now run this code and it will unhide all excel worksheets except the one named as “Workings”

You can change the worksheet name from “Workings” to your worksheet name.

Example #4 – Unhide Only Specific Excel Sheet

Similarly, if you want to unhide an only specific excel sheet, VBA can do this as well. For example, if you want to unhide only the worksheet named “Workings” then we can use this code.

Code:

Sub Unhide_One_Sheet()

     Dim WSht As Worksheet

     For Each WSht In ActiveWorkbook.Worksheets
         If WSht.Name = "Workings" Then
         WSht.Visible = xlSheetVisible
         End If
     Next WSht

End Sub

Like this using various techniques, we can unhide multiple sheets in excel.

Recommended Articles

This has been a guide to Unhide Sheets in Excel. Here we discuss how to unhide single and multiple worksheets using different methods in excel with downloadable excel sheet. You can learn more from the following articles –

• Example to Build Comparison Chart
• Excel Auditing Tool | Trace Precedents
• Percentage Change Excel Formula | Examples
• Hide Columns in VBA
• Hide Excel Formula
• Using Gridlines in Excel
• Insert Watermark in Excel