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.

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.

Sheet tabs in Excel

Let’s first hide Sheet 2 from these sheets.

  1. Right-click on the Sheet Tab for Sheet 2.
  2. Click on Hide from the context menu.
Hide Sheet 2

And it’s gone! You no more see any tab by Sheet 2 😲

To unhide sheet 2, follow these steps:

  1. Right-click on any sheet tab.

The following context menu will launch.

Context menu
  1. 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.

Hidden worksheets
  1. Click on the sheet that you want to unhide (Sheet 2 in our example).
  2. Press Okay, and that’s it. Sheet 2 reappears on the Sheets tab.
Sheet 2 unhidden

By doing this, you can unhide any single sheet at a time πŸš€

Another way to unhide a sheet in Excel is to:

  1. Go to the Home Tab.
  2. Click on the Format Button > Visibility > Hide & Unhide.
Visibility under Format button
  1. Hover your cursor around the Hide & Unhide button to see the following menu.
Hide/Unhide options
  1. Click on the option to Unhide Sheets and you’d again see the following window.
multiple worksheets hidden
  1. 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.

  1. Right-click on any sheet tab.
  2. 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).

Hidden Sheets
  1. Click on the first sheet that you want to unhide. A blue bar will cover it.
Unhide dialog box
  1. Hold down the Control key and select the next sheet that you want to unhide (Sheet 3).

Both the sheets will now turn blue.

Selecting multiple sheets
  1. Hold down the Control key again and select the next sheet that you want to unhide (Sheet 4).

All the sheets are now blue πŸ’™

All blue sheets

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.

Kasper Langmann, Microsoft Office Specialist
  1. Click Okay.

All the selected sheets are unhidden (they appear on the Sheet tab).

All sheets unhidden

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 πŸ™ˆ

Kasper Langmann, Microsoft Office Specialist
  1. Go to the View Tab > Custom views button.
The view tab

Clicking on this button, you’d see the Custom Views dialog box below.

Custom Views dialog box
  1. Click on the Add button.
Add button
  1. In the Add view dialog box as shown below, write any custom name. We are setting it to β€œAllSheets”.
  2. Click Okay.
Add a custom name

We’re done. Now let’s unhide Sheet 2, Sheet 3, and Sheet 4 from our sheets 🐀

Sheets 2, 3, and 4 hidden
  1. Go to the View Tab > Custom View.
 Custom View button

The custom view dialog box will have the button AllSheets saved.

  1. Select it and press the Show button. Or simply select and double-click the AllSheets button.
Selecting 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.

Unhide worksheets

Now let’s write a quick macro to unhide all the hidden sheets in this workbook.

  1. Press the Alt Key + F11 key to launch the Visual Basic editor as below.
Personal macro workbook
  1. Press the Control key + G. This will launch the immediate window to the bottom.
The immediate window
  1. Click in the Immediate window and write in the following code.

For Each ws In Sheets:ws.Visible=True:Next

  1. Press the F5 key to run the macro.

And here come the results. All the hidden sheets of your workbook will now be unhidden.

All unhidden sheets

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.

Other resources

You must be good at hiding sheets now. And what about hiding rows and columns?

Read our blog here to learn how to do that.