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.
How to Unhide Sheet Tab in Excel: 7 Effective Ways
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 out now!
1. Unhide Sheet Tab from View Tab
Let’s say we have a workbook and, mistakenly, the user has pressed the keyboard, and the whole window looks like this. The sheet tabs have also been hidden, unfortunately.
We need to unhide the hidden sheet tab. In order to serve this purpose, proceed with the following steps:
- First of all, go to the View tab> select the Unhide Window option.
- Then the Unhide dialog box will appear.
- Here, select the workbook name you want to unhide and click OK.
- Hence, your workbook and sheet tabs will be restored.
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 have the Advanced Option for unhiding the sheet tab. Follow the steps below to unhide the sheet tab.
- 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.
- Hence, your Excel window will restore the sheet tab.
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.
- 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.
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.
- 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.
Sub UnhideTab() ActiveWindow.DisplayWorkbookTabs = True End Sub
- Now, press ALT+Q to switch back to the Excel worksheet window.
- After that, press ALT+F8 to open the Macro dialog box. Select the macro name and click Run.
- 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 changes to the worksheet.
Proceed with the steps below to apply this command.
- 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 purposes.
If you want to get back the sheet tabs, just go to the View tab again, click Custom Views> select All Sheets and click Show.
- Hence, Excel will unhide the hidden sheet tabs.
Read More: How to Put Excel Tabs on Top of Worksheet
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.
- 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.
- As a result, hidden sheet tabs will be restored.
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.
- Now, unhide the sheets like Method 6.
Download Practice Workbook
You can download the practice book from the link below.
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. Keep in touch. Have a great day!