Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Unhide Sheet Tab in Excel (7 Effective Ways)

While working on a Microsoft Excel workbook, users can open multiple worksheets and switch between them to perform different tasks on every worksheet. The created sheet tabs of an Excel workbook are default displayed at the bottom of the Excel window. It allows a user quick navigation between the sheet tabs. Sometimes, the sheet tabs may be mistakenly hidden and it bothers the user. So, it is necessary to get access to the hidden sheet tabs, and for this, you need to unhide them. In this article, I will show you how to unhide sheet tab in Excel.


Download Practice Workbook

You can download the practice book from the link below.


7 Effective Ways to Unhide Sheet Tab in Excel

In this section, you will find 7 effective and suitable ways to unhide the sheet tab in Excel. I will demonstrate them one by one here. Let’s check them now!


1. Unhide Sheet Tab from View Tab

Let’s say, we have got a workbook and mistakenly the user has pressed the keyboard and the whole window looks like this. The sheet tabs have been hidden also, unfortunately.

Hidden Sheet Tab

We need to unhide the hidden sheet tab. In order to serve this purpose, proceed with the following steps.

 💡 Steps:

  • First of all, go to the View tab> select Unhide Window option.

  • Then Unhide dialog box will appear.
  • Here, select the workbook name you want to unhide and click OK.

Unhide Workbook in Excel

  • Hence, your workbook and sheet tab will be restored.

Unhide Sheet Tabs in Excel

Read More: How to Put Excel Tabs on Top of Worksheet (2 Easy Ways)


2. Using Advanced Option to Unhide Sheet Tab

Unlike Method 1, let’s say we have the worksheet but the sheet tab usually located at the bottom of the Excel window is now hidden.

So, our purpose is to unhide this hidden sheet tab. We will now the Advanced Option for unhiding the sheet tab. Follow the steps below to unhide the sheet tab.

 💡 Steps:

  • Firstly, go to the File tab and excel will open a menu list.
  • Here, select Option from the bottom side of the menu list.

  • Now, the Excel Options window will appear.
  • Here, select Advanced > check the Show sheet tabs option from the Display options for this workbook. The option is unmarked if your sheet tab is hidden.

  • Now, mark this option and click OK.

Show Sheet Tab in Excel

  • Hence, your Excel window will restore the sheet tab.

Read More: [Fixed!] Unable to Set the Visible Property of the Worksheet Class


3. Unhide Sheet Tab with Tab Bar Option

If you doubt that your workbook isn’t showing all the sheet tabs, then you can check whether any sheet tab is hidden. Just right-click on any of the sheet tabs and a list of options will appear. The Unhide option will be disabled in case of any sheet being hidden.

If you are sure that, one or more sheets or sheet tabs are hidden, then you have to unhide the hidden sheet tab. In order to do so, just proceed with the steps below.

 💡 Steps:

  • First of all, right-click on any of the sheet tabs and click Unhide from the options.

  • Now, the Unhide dialog box will appear.
  • Here, select the worksheet you want to unhide and click OK.

  • You can select as many sheets as you want to unhide. Just press CTRL and keep selecting> click OK.

  • As a result, your hidden sheet tabs will be unhidden.

Unhide Sheet Tab in Excel


4. Using VBA Code

Here, the sheet tabs are hidden from our workbook.

You can use the VBA code to unhide the hidden sheet tabs. So, let’s start the process like the one below.

 💡 Steps:

  • First of all, press ALT+F11 to open the Visual Basic editor window.
  • Now, right-click on any of the worksheets> select Insert> click Module.
  • Then, assign the VBA code to the module window. You can use the following.

 ➡ Code:

Sub UnhideTab()

ActiveWindow.DisplayWorkbookTabs = True

End Sub

VBA code to Unhide Sheet Tab in Excel

  • Now, press ALT+Q to switch back to the Excel worksheet window.
  • After that, press ALT+F8 to open the Macro dialog box. Select Macro name and click Run.

VBA macro dialog box to unhide sheet tab

  • Hence, you will be able to unhide the hidden sheet tabs.


5. Applying Custom Views Command

Are you familiar with the Custom Views command in Excel? Well, this command is a special feature of Microsoft Excel. Applying this command allows a user to get back to its previous state after making any change to the worksheet.

Proceed like the steps below to apply this command.

 💡 Steps:

  • Firstly, go to the View tab> click Custom Views.

  • Then, the Custom Views dialog box will open up. Click Add.

  • Now, type All Sheets in the Name field> click OK.

Now, you can hide as many sheets as you want for your work purpose.

If you want to get back the sheet tabs, just go to the View tab again and click Custom Views> select All Sheets and click Show.

Custom Views command to Unhide Sheet Tab

  • Hence Excel will unhide the hidden sheet tabs.

Read More: How to Unhide All Sheets in Excel Using VBA (4 Examples)


6. Using Visibility Option to Unhide Sheet Tab

The visibility option allows the user to hide and unhide sheet tabs. If you want to unhide the hidden sheet tabs, follow the steps below.

 💡 Steps:

  • First of all, go to the Home tab> select Format> click Hide & Unhide from the Visibility group> Unhide Sheet.

  • Here, the Unhide dialog box will show up.
  • Select the sheets you want to unhide (press CTRL and select multiple sheets) and click OK.

Unhide Sheet Tab in Excel

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

Read More: How to Unhide Multiple Sheets in Excel (4 Ways)


7. Using Shortcut Key

Apart from these heavy methods (if you are comfortable with shortcuts), you can unhide hidden sheet tabs with a keyboard shortcut.

  • All you have to do is to press ALT > H > O > U > H and the Unhide dialog box will open up.


Conclusion

In this article, I have tried to show you some methods to unhide the sheet tab in Excel. Hope you like the article. If you have better methods, questions, or feedback regarding this article, please don’t forget to share them in the comment box. For more queries, kindly visit our website ExcelDemy. Keep in touch. Have a great day!


Related Articles

Rafi

Rafi

Hey there! I am Md. Rafiul Hasan. Currently I am working as an Excel & VBA content developer. I like new ideas and want to explore the field of innovation. Excel has saved our worktime and made it easy for us to quick calculations. I am trying to make it easier for you to overcome the obstacles you face while working on Excel. Stay connected!

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo