how to unhide very hidden sheets in excel

Unveiling Excel: Unhiding Very Hidden Sheets

By Rachel Williams
AD

Ever encountered aocumented sheet in your Excel workbook that has Gone MIA? Don't despair. Some careful digging can unearth those hidden gems. Here's how to unhide very hidden sheets in Excel.

Before we dive in, ensure you're working with Excel 2016 or later. Older versions may have slightly different procedures. Let's get started!

The Villa of Visibility

We'll explore two paths to reach your concealed sheet: Classically via the Home tab and secretly through the VBA route.

AD
How to Unhide Very Hidden Sheets in Excel (2 Effective Methods) - ExcelDemy
How to Unhide Very Hidden Sheets in Excel (2 Effective Methods) - ExcelDemy
How to Unhide Sheets in Excel
How to Unhide Sheets in Excel
Unhide Hidden Sheets in Excel (Show Worksheet Tabs)
Unhide Hidden Sheets in Excel (Show Worksheet Tabs)

Don't worry, no coding experience is needed for the VBA method - just copying and pasting some pre-made code.

acciGally Trail: Unhide via Excel's Ribbon

There's a chance your sheet isn't as hidden as you thought. Excel's Home tab might help you find it.

How to unhide hidden sheets in excel || Excel work Online || Download Software || by Suhani Malik
How to unhide hidden sheets in excel || Excel work Online || Download Software || by Suhani Malik
How to Unhide Very Hidden Sheets in Excel (2 Effective Methods) - ExcelDemy
How to Unhide Very Hidden Sheets in Excel (2 Effective Methods) - ExcelDemy

Follow these steps:

  • Open your Excel workbook.
  • Click on the XL at the top left corner to switch to the main sheet.
  • Go to the 'Home' tab.
  • In the 'Editing' section, click on 'Find & Select'.
  • Select 'Go To Special...

Now, tick 'Visible' and click 'OK'. Voila! Your hidden sheet should appear in the list. Select it and click 'OK'.

AD

Whispering Windows: Use VBA to Unhide

If the above method fails (perhaps your sheet isn't just hidden, but totally deleted from the window list), VBA is your secret weapon.

Follow these steps:

  • Press 'ALT + F11' to open the Visual Basic Editor.
  • Click 'Insert', then 'Module'.
  • Paste the following code in the module:
  • "'Sheets"github_sheet_name_here".Visible = True"
    
    Replace 'github_sheet_name_here' with your sheet's actual name.

Access Denied: Handling Protected Sheets

excel sheets in your workbook are protected. Here's how to unhide them.

AD

Follow these steps:

Changing Permissions: Unhide Assigned Protected Sheets

  • Right-click the sheet tab, click 'View Code'.
  • Remove any unhide-protected code (like "Sheets.github_sheet_name_here".Visible = false).
  • Click 'Design Mode', then 'Exit Design Mode'.

Revoking Remotes: Unhide Assigned Protected Hidden Sheets via VBA

If your sheet is totally invisible and protected, use VBA to change its protection status.

  • Open VBA as described earlier.
  • Paste this code in a module:
  • "'Sheets"github_sheet_name_here".Protection = xlNoProtection"
    
    Replace 'github_sheet_name_here' with your sheet's actual name.

Now, your hidden sheet should be visible and unprotected. Save your changes and close the VBA window.

AD

And there you have it! Regardless of how well your Excel sheets try to hide, with these methods, they'll reveal their true selves. Happy un-hiding!

AD