How To Unhide Sheets In Excel: Step-by-Step Methods And Solutions

Hidden sheets can be frustrating, especially when you need quick access to important data. Learn how to unhide them within seconds.

Shreeya Thakur

0 min read

How To Unhide Sheets In Excel: Step-by-Step Methods And Solutions

0 min read

Table of content:

How to Unhide Excel Sheets:
Troubleshooting Unhiding Issues
Advanced Unhiding Techniques
Frequently Asked Questions

Excel is a staple in data management, but even experienced users sometimes struggle when sheets seem to vanish from a workbook. Hidden sheets can be frustrating, especially when you need quick access to important data. Fortunately, unhiding sheets is straightforward once you know where to look.

This article will take you through easy-to-follow steps and advanced tricks on how to find hidden sheets,

How to Unhide Excel Sheets:

1. Using Right-Click to Unhide

The simplest way to unhide a sheet is with a right-click:

Right-click any visible sheet tab at the bottom of your workbook.
If there are hidden sheets, select "Unhide…" from the menu.
A list of hidden sheets appears—select the one you want to restore and click “OK.”

This is a fast, efficient way to unhide one or two sheets, but it can be tedious if you have many hidden sheets.

2. Using the Home Tab

You can also access the "Unhide" option through the Home tab:

Go to the Home tab, then find the Format button in the Cells group.
Select Hide & Unhide, then choose Unhide Sheet.

This method lets you quickly view and unhide any hidden sheets.

3. Using Keyboard Shortcuts

Shortcuts can make unhiding sheets even faster:

Press Alt + H, then O, then U.

This sequence opens the Unhide dialog box, making you look like an Excel pro!

4. Using VBA to Unhide All Sheets at Once

If you have multiple hidden sheets, using VBA (Visual Basic for Applications) can save time:

Press ALT + F11 to open the VBA editor.
Insert a new module and paste the following code:

Sub UnhideAllSheets()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Sheets
ws.Visible = xlSheetVisible
Next ws
End Sub

Press F5 to run the macro, and all hidden sheets will appear.

This is especially helpful if you’re working with a large workbook with many hidden sheets.

Troubleshooting Unhiding Issues

Workbook Protection Issues

If the “Unhide” option is grayed out, your workbook might be protected:

Go to the Review tab and select Unprotect Workbook (you may need a password).
Once unprotected, right-click any sheet tab and select “Unhide.”

Understanding Very Hidden Sheets

Excel allows developers to create “very hidden” sheets, which can’t be unhidden through the regular menu:

Press ALT + F11 to open the VBA editor.
In the Project Explorer, locate your workbook and select the hidden sheet.
In the Properties window, change the Visible property from xlSheetVeryHidden to xlSheetVisible.

This is a more advanced method, usually used by developers to keep data out of view.

Advanced Unhiding Techniques

Creating a Macro for Unhiding Sheets

Go to the View tab, select Macros, then Record Macro.
Unhide sheets as usual, then stop recording.
You can assign this macro to a shortcut key for easy access whenever you need it.

Adding the Macro to the Quick Access Toolbar

Click the drop-down arrow on the Quick Access Toolbar, choose More Commands, and select Macros.
Add your macro, making it easy to unhide sheets in a single click.

Frequently Asked Questions

Q1. How do I unhide a single sheet in Excel?

Right-click a visible sheet tab, select Unhide, then choose the sheet you want.

Q2. Why is the Unhide option grayed out?

This could indicate that the workbook is protected. Unprotect it under the Review tab.

Q3. Can I unhide multiple sheets at once?

Office 365 allows you to select and unhide multiple sheets. For older versions, use VBA to unhide them all at once.

Q4. Are hidden sheets saved when I close Excel?

Yes, any hidden sheets will remain hidden when you reopen the workbook.

Q5. How can I troubleshoot unhiding issues?

Check workbook protection, ensure you’re not in shared mode, and restart Excel if you encounter glitches.

Suggested Reads:

Edited by

Shreeya Thakur

Sr. Associate Content Writer at Unstop

I am a biotechnologist-turned-content writer and try to add an element of science in my writings wherever possible. Apart from writing, I like to cook, read and travel.