Forum Discussion

samserrano's avatar
samserrano
Copper Contributor
Nov 02, 2025

Hide Sheet after missusing shortcut Alt+H+W

I was working on an inventory and frequently using the shortcut mentioned above. Unfortunately, during one of those times, I must have misused it, and my sheet became hidden. Since then, I’ve tried multiple methods to unhide it, but none have worked. I would really appreciate your assistance in resolving this issue.

admin
community
excel
Excel for web
Formulas and Functions
Macros and VBA
office 365

2 Replies

  • m_tarler's avatar
    m_tarler
    Bronze Contributor
    Nov 05, 2025

    you probably clicked Alt+W+H and need to click 'unhide' on the View tab or use Alt+W+U

  • Kidd_Ip's avatar
    Kidd_Ip
    MVP
    Nov 05, 2025

    Try this:

     

    1: Try the standard unhide

    1. Right‑click on any visible sheet tab at the bottom.
    2. Select Unhide….
    3. If your missing sheet is listed, select it and click OK.

    If it’s not listed, that means it’s “Very Hidden.”

     

    2: Use the VBA editor to unhide “Very Hidden” sheets

    1. Press Alt + F11 to open the VBA editor.
    2. In the left pane (Project Explorer), expand your workbook.
    3. Select the sheet you can’t see.
    4. In the Properties window (press F4 if it’s not visible), look for the property Visible.
    5. Change it from xlSheetVeryHidden to xlSheetVisible.
    6. Close the VBA editor and return to Excel—the sheet should now be visible.

     

    3: Check workbook protection

    If the sheet still won’t unhide:

    • Go to Review → Protect Workbook.
    • If protection is enabled, you may need the password to unprotect before unhiding sheets.

     

     

Resources