Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.

How to unhide sheets

While working with Excel, we are able to hide or show selected worksheets.  In some cases, it is necessary for us to hide worksheets to control or simplify the display of information, or to prevent unwanted changes in the values and formula in some sheets.  

Figure 1.  Final result:  How to unhide sheets

When we encounter files with hidden sheets, we can easily unhide the sheets through either of these methods:

  • Right-click method
  • Format menu
  • Custom View

Right-click method to unhide sheets

This is the simplest method to unhide sheets in Excel.  Suppose we have a file with three sheets, but only Sheet1 is visible in the window.  

Figure 2.  Sample file with hidden sheets

In order to unhide the other worksheets, we follow these steps:

  • Right-click the visible sheet tab at the bottom of the workbook named Sheet1 and select Unhide

Figure 3.  Selecting the unhide option

The Unhide dialog box will appear, showing a list of sheet names for the hidden sheets.   In this case, the hidden sheets are Sheet2 and Sheet3.

Figure 4.  Selecting the worksheet to unhide

  • We select the sheet we want to unhide, Sheet 2, and click OK.

Figure 5.  Output: Unhide a sheet through right-click method

Sheet2 will be instantly unhidden and visible on the window.  

Unhide sheet in Format Menu

There is another way to unhide sheets through the Home tab > Format button.  

  • From the drop-down menu, select Hide & Unhide under Visibility and click Unhide Sheet.  

Figure 6.  Unhide Sheet option

The Unhide dialog box will appear just like in the previous example.  Then we get to select the sheet that we want to unhide, say Sheet3, and click OK.  

Figure 7.  Selecting to unhide Sheet3

Sheet 3 will then be visible and unhidden.  

Figure 8.  Output:  Unhide a sheet through Format menu

The first two methods show how to unhide sheets one by one.  There is another method that allows us to unhide sheets all at once.  

Unhide all sheets

In order to unhide multiple sheets or all sheets, we follow these steps:  

  • Click View tab > Custom Views

Figure 9.  Custom View ribbon button

The Custom Views dialog box will appear.

Figure 10.  Custom Views preview

  • Click Add to launch the Add View dialog box.  We enter a name for the custom view, for instance, Unhide all sheets

Figure 11.  Add View dialog box

Note that the checkboxes for Print settings and Hidden rows, columns and filter settings are ticked.  When we click OK, we have already created a custom view that will show all hidden sheets.

How to unhide all sheets?

Suppose we have hidden Sheet2 and Sheet3 and now we want to unhide them, we only have to click Custom View, select the view “Unhide all sheets” that we have created earlier, the click Show.  

Figure 12.  Show the selected Custom View

In an instant, we will be able to unhide all hidden sheets at the same time.  

Figure 13.  Output: Unhide all sheets

Instant Connection to an Excel Expert

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

Leave a Comment

avatar

Subscribe to Excelchat.co

Get updates on helpful Excel topics

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc