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

Method 1 – Using View Tab

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

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

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

• Your workbook and sheet tabs will be restored.

Method 2 – Using Advanced Option

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.

• Your Excel window will restore the sheet tab.

Method 3 – Using the 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.

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

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

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

Method 5 – Using the 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.

• Excel will unhide the hidden sheet tabs.

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

Method 6 – Using Visibility Option

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.

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

Method 7 – Using a 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

• How to Create Tabs Automatically in Excel
• How to Create Tabs Within Tabs in Excel
• How to Group Tabs Under a Master Tab in Excel
• How to Change Worksheet Tab Color in Excel
• [Fixed!] Excel Sheet Tabs Hidden Behind Taskbar

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