How to Unhide Sheets in Excel: Step-by-Step (Unhide Tabs)
Just like cells, columns, and rows – you can also hide sheets in Excel 📝
Hiding sheets is the most fault-proof way to hide some data but still have it there in your Excel file. And what about accessing it again after it’s hidden?
Unhide those sheets again – simple! How do you do that?
There are many ways how you can unhide sheets in Excel and the guide below will teach you all these ways. So let’s jump in.
Table of Contents
How to unhide a single tab in Excel
Let’s warm up with the steps to unhide a single sheet tab in Excel. And it’s really simple.
Here is the sheet tab in Excel.
Let’s first hide Sheet 2 from these sheets.
- Right-click on the Sheet Tab for Sheet 2.
- Click on Hide from the context menu.
And it’s gone! You no more see any tab by Sheet 2 😲
To unhide sheet 2, follow these steps:
- Right-click on any sheet tab.
The following context menu will launch.
- Click on the Unhide Button.
The Unhide window will open that contains all the hidden sheets. Until now, we have only hidden Sheet 2, so we see it there.
- Click on the sheet that you want to unhide (Sheet 2 in our example).
- Press Okay, and that’s it. Sheet 2 reappears on the Sheets tab.
By doing this, you can unhide any single sheet at a time 🚀
Another way to unhide a sheet in Excel is to:
- Go to the Home Tab.
- Click on the Format Button > Visibility > Hide & Unhide.
- Hover your cursor around the Hide & Unhide button to see the following menu.
- Click on the option to Unhide Sheets and you’d again see the following window.
- Choose the sheet to be unhidden and press ‘Okay’.
The selected sheet will be unhidden. Easy, right 💡
Unhide multiple tabs (Microsoft 365)
If you are subscribed to an older version of Excel, you’d have to perform all the steps above to unhide each sheet.
However, if you are a Microsoft 365 user, you can unhide multiple Excel sheets in one go 💪 Here’s how to do it.
- Right-click on any sheet tab.
- From the context menu, click on the Unhide Button.
The Unhide window will open that contains all the hidden sheets. This time we have three hidden sheets (Sheet 2, Sheet 3, and Sheet 4).
- Click on the first sheet that you want to unhide. A blue bar will cover it.
- Hold down the Control key and select the next sheet that you want to unhide (Sheet 3).
Both the sheets will now turn blue.
- Hold down the Control key again and select the next sheet that you want to unhide (Sheet 4).
All the sheets are now blue 💙
If you want to select multiple sheets that come consecutive in the Unhide Sheet dialog box above, you can use the Shift key ✌
Select the first sheet that you want to unhide, press down the Shift key, and select the last sheet that you want to unhide. With the Shift key, all the sheets in between the first and last sheet are selected at once.
- Click Okay.
All the selected sheets are unhidden (they appear on the Sheet tab).
You can do this with Microsoft 365. However, older versions of Excel do not allow unhiding multiple sheets like that. So, it might take you a good time to unhide each sheet individually ⌛
Unhide all sheets in Excel with Custom View
Here’s another way how you can instantly unhide all the sheets in your workbook.
Before you follow these steps, make sure none of the sheets of your workbook are hidden. They must all be visible 🙈
- Go to the View Tab > Custom views button.
Clicking on this button, you’d see the Custom Views dialog box below.
- Click on the Add button.
- In the Add view dialog box as shown below, write any custom name. We are setting it to “AllSheets”.
- Click Okay.
We’re done. Now let’s unhide Sheet 2, Sheet 3, and Sheet 4 from our sheets 🐤
- Go to the View Tab > Custom View.
The custom view dialog box will have the button AllSheets saved.
- Select it and press the Show button. Or simply select and double-click the AllSheets button.
Pressing this button will unhide all the sheets of your workbook in a single click. That’s how you can unhide multiple sheets together using Custom Views 😵
Unhide all sheets with the VBA code
There’s yet another method of how you can unhide all the hidden sheets 🎯
So here’s our Excel workbook that has 5 sheets in total, and we have hidden two of them.
Now let’s write a quick macro to unhide all the hidden sheets in this workbook.
- Press the Alt Key + F11 key to launch the Visual Basic editor as below.
- Press the Control key + G. This will launch the immediate window to the bottom.
- Click in the Immediate window and write in the following code.
For Each ws In Sheets:ws.Visible=True:Next
- Press the F5 key to run the macro.
And here come the results. All the hidden sheets of your workbook will now be unhidden.
See that? Not all VBAs are difficult to run 🏃♀️
That’s it – Now what?
So now you know four different ways how to unhide sheets in Excel. You can unhide single and multiple sheets in Excel. Unhide them by saving a custom view in Excel and with a VBA code too.
Love how versatile Excel is? We love it too 😍
But that’s not it. There are so many more tools, features, and functions in Excel that will equally surprise you. Like the VLOOKUP, SUMIF, and IF functions – my personal favorites from Excel.
Want to start learning them already? Hop on here and enroll in my 30-minute free email course to get your hands on them.
You must be good at hiding sheets now. And what about hiding rows and columns?