WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • Excel VBA All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » Unhide Sheets in Excel

Unhide Sheets in Excel

Different Methods to Unhide Excel Sheets

Unhiding a 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.

Unhide-Sheets-in-Excel

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

You can download this Unhide Sheets Excel Template here – Unhide Sheets Excel Template

Method #1 – Using Right Click

  • Step 1: To unhide the sheet, we need to right-click any of the worksheet tabs.

Unhide Single Sheet Example 1.1

  • Step 2: Once you right-click, you could see the below options.

Unhide Single Sheet Example 1.2

  • Step 3: In these options, select the “Unhide” option, and you will see a list of all the worksheets that are hidden.

Unhide Single Sheet Example 1.3

  • Step 4: Select the worksheet that you want to unhide and click on, OK. It will unhide the selected sheet.

Unhide Single Excel Sheet

  • Step 5: Now, I can see the worksheet named “WS1” in my sheet tab.

Unhide Single Sheet Example 1.4

Method #2

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

  • Step 1: To unhide single excel sheet go to Home > Format > Hide & Unhide > Unhide Sheet

Unhide Single Sheet Example 2.1

  • Step 2: Upon clicking that option, as shown in the above image, we could see the below window.

Unhide Single Sheet Example 2.2

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.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course
  • Step 1: Just press ALT + H + O + U + H to open the unhide sheet box.

Unhide Single Sheet Example 3.1

  • Step 2: This will open the below window.

Unhide Single Sheet Example 3.2

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

Method #4 – Unhide Multiple Sheets

Unhide window can only unhide single sheets at a time, but imagine you have to unhide 10 sheets, then repeating the same set of tasks 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 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

Unhide All Worksheet 1.1

  • I have used the For Each loop in VBA 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.

Unhide All Worksheet 1.2

  • Now insert a new module under the INSERT option.

Unhide All Worksheet 1.3

  • In the new module, paste the copied code.

Unhide All Worksheet 1.4

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

Unhide All Sheets

Method #5 – Unhide All Worksheets Except Particular Worksheet

There are situations where we need to unhide all the 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 “Workings.”

The 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

Unhide All Worksheet Except One

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

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

Method #6 – Unhide Only Specific Excel Sheet

Similarly, if you want to unhide only a specific excel sheet, VBA can do this as well. For example, if you want to unhide only the worksheet named “Workin,” 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

Unhide Single Worksheet using VBA

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 a downloadable template. You can learn more from the following articles –

  • Comparison Chart in Excel
  • Auditing Tool in Excel
  • Percentage Change Excel Formula
  • Hide Columns in VBA
6 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download Unhide Sheets Excel Template

New Year Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More