How to Unhide a Sheet Tab in Excel (7 Methods)

Method 1 – Unhide Sheet Tab from View Tab:

Suppose you have a workbook where the sheet tabs are accidentally hidden. To restore them, follow these steps:

Hidden Sheet Tab

  • Go to the View tab.
  • Select Unhide Window.

  • In the Unhide dialog box, choose the workbook name you want to unhide and click OK.

Unhide Workbook in Excel

  • Your workbook and sheet tabs will be restored.

Unhide Sheet Tabs in Excel


Method 2 – Using Advanced Option to Unhide Sheet Tab:

If the sheet tab is hidden (located at the bottom of the Excel window), follow these steps:

  • Click the File tab.
  • Select Options.

  • In the Excel Options window, go to Advanced.
  • Check the Show sheet tabs option under Display options for this workbook.

  • Click OK to restore the sheet tab.

Show Sheet Tab in Excel

  • Your Excel window will restore the sheet tab.


Method 3 – Unhide Sheet Tab with Tab Bar Option:

If you suspect hidden sheet tabs, right-click any sheet tab:

  • Choose Unhide from the options.

  • In the Unhide dialog box, select the worksheet you want to unhide and click OK.

  • You can select multiple sheets by pressing CTRL.

  • Your hidden sheet tabs will be unhidden.

Unhide Sheet Tab in Excel


Method 4 – Using VBA Code:

To unhide sheet tabs using VBA code:

  • Press ALT+F11 to open the Visual Basic editor.
  • Right-click on any worksheet, select Insert, and click Module.
  • Add the following code:
Sub UnhideTab()

ActiveWindow.DisplayWorkbookTabs = True

End Sub

VBA code to Unhide Sheet Tab in Excel

  • Press ALT+Q to return to the Excel worksheet.
  • Press ALT+F8, select the macro name, and click Run.

VBA macro dialog box to unhide sheet tab

  • You will be able to unhide the hidden sheet tabs.


Method 5 – Applying Custom Views Command:

Custom Views in Excel allow you to revert to a previous state after making changes.

Follow these steps:

  • Go to the View tab and click Custom Views.

  • In the Custom Views dialog box, click Add.

  • Name it All Sheets and click OK.

  • Hide sheets as needed.

  • To unhide sheet tabs, go to View, click Custom Views, select All Sheets, and click Show.

Custom Views command to Unhide Sheet Tab

  • Excel will unhide the hidden sheet tabs.

Read More: How to Put Excel Tabs on Top of Worksheet


Method 6 – Using Visibility Option to Unhide Sheet Tab:

The visibility option allows you to hide and unhide sheet tabs. To unhide hidden sheet tabs, follow these steps:

  • Go to the Home tab.
  • Select Format and click Hide & Unhide from the Visibility group.
  • Choose Unhide Sheet.

  • In the Unhide dialog box, select the sheets you want to unhide (use CTRL to select multiple sheets) and click OK.

Unhide Sheet Tab in Excel

  • As a result, the hidden sheet tabs will be restored.


Method 7 – Using Shortcut Key:

If you’re comfortable with shortcuts, you can unhide hidden sheet tabs using a keyboard shortcut:

  • Press ALT > H > O > U > H.
  • The Unhide dialog box will open

  • Unhide the sheets as described in Method 6.

Download Practice Workbook

You can download the practice workbook from here:


Related Articles


<< Go Back to Sheets Tab in Excel | Excel Parts | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Rafiul Hasan
Rafiul Hasan

Rafiul Hasan, holding a BSc in Naval Architecture and Marine Engineering from Bangladesh University of Engineering & Technology, contributes significantly to the ExcelDemy project with almost 1.6 years of dedicated work. Currently an Excel and VBA Content Developer, he has a passion for problem-solving. Authoring over 100 articles for ExcelDemy showcases expertise in Microsoft Office Suites and Data Analysis. In addition to content development, Rafiul actively engages with the ExcelDemy forum, offering valuable solutions to user queries and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo