To find a normally hidden worksheet in Excel for Microsoft 365 on Windows, right-click any visible sheet tab, choose Unhide, select the sheet, and choose OK. If the sheet is not listed, it may be set to VeryHidden, the workbook structure may be protected, or the sheet tabs themselves may be out of view. You will need access to the workbook, and you may need permission or a password to change its settings.
What You’ll Need
- The Excel workbook open in the desktop app or Excel for the web.
- At least one visible worksheet tab to open the Unhide command. Excel requires a workbook to have at least one visible sheet.
- For a VeryHidden sheet, Excel’s Visual Basic Editor and permission to change the workbook. You do not need to write or run a macro.
- If workbook structure protection is enabled, the password or help from the workbook owner may be required.
Step-by-Step
- Open the workbook and locate its sheet tabs. Look along the bottom of the Excel window for worksheet tabs, such as Summary or Data. If you do not see any tabs, continue to the troubleshooting section: the workbook may be set to hide the tab bar, rather than having every sheet hidden. If the file opens in Protected View, only enable editing if you trust its source.
- Open the Unhide command from a sheet tab. In Windows, right-click any visible sheet tab and choose Unhide. In Excel for Microsoft 365 on Mac, Control-click or right-click a visible sheet tab and choose Unhide. You can also use the ribbon: choose Home > Format > Hide & Unhide > Unhide Sheet. The command applies to the current workbook.
- Choose the sheet to reveal. In the Unhide dialog, click the name of the hidden worksheet and select OK. Excel displays its tab alongside the other sheet tabs. If the dialog lists several sheets, you must unhide them one at a time; repeat the command for each one you want to show. Unhiding a sheet does not change its cell contents or formulas.
- Check that the sheet is available. Click the newly visible tab and confirm that it is the worksheet you expected. If the tab appears off-screen, use the sheet-tab navigation arrows at the lower left of the window to scroll through tabs. Those arrows move the tab strip; they do not unhide sheets. To change the tab’s position, drag it after it is visible.
- If the sheet is missing from the dialog, check for VeryHidden status. Excel’s Unhide dialog lists sheets set to the ordinary Hidden state, but it does not list sheets set to VeryHidden. On Windows desktop Excel, press Alt+F11 to open the Visual Basic Editor. If your keyboard uses media-function keys, you may need Fn+Alt+F11. In the editor, open Project Explorer with Ctrl+R if it is not visible, then expand the project for the workbook and locate the sheet under Microsoft Excel Objects.
- Change the sheet’s Visible property. Select the relevant sheet object in Project Explorer, then press F4 to display the Properties window. Find the Visible property. Choose -1 – xlSheetVisible from its dropdown, or change the value from 2 – xlSheetVeryHidden to -1 – xlSheetVisible. Return to Excel and confirm that the sheet tab now appears. This changes a setting; it does not run a macro.
- Use the Mac Visual Basic Editor if needed. Excel for Mac also has a Visual Basic Editor, though the keyboard shortcut can depend on the keyboard and system settings. Open it from Excel’s Tools > Macro > Visual Basic Editor menu when available, or use the Visual Basic command on the Developer tab. In the editor, select the worksheet object, open Properties, and set Visible to xlSheetVisible. If you cannot find the editor or change the property, use desktop Excel on a computer where you have the required access.
- Close the editor and save the workbook. After making a change, return to Excel and verify the result before saving. Use Ctrl+S on Windows or Command+S on Mac. If you want to preserve the original, choose File > Save As and save a separate copy. Do not save a changed workbook over a shared original unless you are authorized to do so.
Common Mistakes
- Looking only at the sheet tabs. A hidden worksheet has no visible tab, so its absence does not mean it was deleted. Start with the Unhide dialog before assuming the data is gone.
- Expecting VeryHidden sheets in the Unhide dialog. The dialog only shows sheets in the ordinary Hidden state. If the dialog is empty or does not contain the sheet you were told to find, inspect the Visible property in the Visual Basic Editor.
- Confusing hidden sheets with hidden rows or columns. A sheet is a whole worksheet tab. Hidden rows and columns are parts of a visible worksheet; use the row or column headings and the relevant Unhide commands to reveal those instead.
- Assuming sheet protection and workbook structure protection are the same. Protecting a worksheet controls actions on that sheet, while protecting workbook structure can block actions such as hiding, unhiding, renaming, or moving sheets. A worksheet password is not necessarily the password needed to change workbook structure.
- Changing the wrong worksheet’s property. In the Visual Basic Editor, verify the selected object and its displayed sheet name before changing Visible. Projects can contain several sheets with similar names, and the object name may differ from the tab name.
- Expecting to undo the property change like a cell edit. Changing a sheet’s visibility in the editor is not a normal cell operation and may not be reversed with Ctrl+Z. If you are unsure, save a separate copy first.
Tips
- Use the sheet’s tab name as a clue. The visible tab name may differ from its code name in the Visual Basic Editor. Check the Properties window’s identifying information and confirm the sheet’s name before making changes.
- Reveal only what you need. Hidden sheets may contain intermediate calculations, source data, or content not intended for everyday editing. Unhiding a sheet makes it visible; it does not establish that its contents should be changed or shared.
- Keep an original copy. Before changing a workbook you did not create, use Save As to keep an unchanged version. This is especially useful if you are checking a VeryHidden sheet or working with a protected workbook.
- Remember that visible is not the same as unprotected. After revealing a worksheet, you may still be unable to edit its cells because the sheet itself is protected. Ask the owner for the appropriate password or an editable copy rather than trying to bypass protection.
- Know the limits of Excel for the web. Excel for the web can reveal ordinary hidden worksheets using the sheet-tab context menu’s Unhide option when it is available. It does not provide the desktop Visual Basic Editor for changing a VeryHidden sheet’s property. Open the workbook in desktop Excel for that task.
Troubleshooting
- Unhide is unavailable or greyed out. Check whether the workbook structure is protected. In desktop Excel, open the Review tab and look for Protect Workbook. If structure protection is active, an authorized person must remove it; Excel may ask for a password. Do not confuse this with the Protect Sheet command.
- The Unhide dialog is empty. There may be no sheets in the ordinary Hidden state. Check whether the workbook is the correct file, whether the sheet was deleted, or whether a sheet is VeryHidden. On desktop Excel, inspect the worksheet objects’ Visible properties in the Visual Basic Editor. If the project is locked or access is denied, contact the workbook owner.
- No sheet tabs appear at the bottom. On Windows, open File > Options > Advanced, scroll to Display options for this workbook, select the correct workbook if needed, and enable Show sheet tabs. On Mac, check Excel’s Settings or Preferences for the workbook display option to show sheet tabs; its location can vary by Excel release. Also widen the Excel window, since a narrow window can make the tab strip difficult to see.
- You cannot see every tab, even after unhiding a sheet. The tab navigation arrows may indicate that some tabs are outside the visible portion of the strip. Use the arrows to scroll, or widen the window. A scrollbar or hidden tab area is not proof that a worksheet is hidden.
- The Visual Basic Editor will not open or the property cannot be changed. Confirm you are using the desktop app, not Excel for the web. A locked VBA project, workbook permissions, or structure protection can prevent access. If you do not own the file, ask its owner or administrator to reveal the sheet or provide an approved copy.
- The sheet still looks blank or incomplete. Check whether rows or columns inside the newly visible sheet are hidden, filtered, or outside the current scroll area. Also check whether the sheet contains formulas linked to other workbooks; revealing it does not restore missing links or data.
Frequently Asked Questions
Can I find a hidden sheet without using VBA?
Yes, if it is in the ordinary Hidden state. Right-click a visible tab, choose Unhide, select the worksheet, and choose OK. VBA is only needed to change a VeryHidden sheet’s visibility property in desktop Excel.
Why is my sheet not listed in the Unhide window?
It may be VeryHidden, there may be no ordinary hidden sheets, or you may have opened a different workbook. If you use desktop Excel and have permission, inspect the sheet’s Visible property in the Visual Basic Editor. A VeryHidden sheet does not appear in the standard dialog.
Can I unhide a sheet if the workbook is protected?
It depends on the protection. Workbook structure protection can prevent unhiding sheets and may require a password to turn off. Sheet protection usually controls editing on an individual worksheet rather than whether it can be unhidden. Ask the owner for access if you do not have the password.
Can Excel for the web show VeryHidden sheets?
Excel for the web can reveal ordinary hidden sheets where its Unhide command is available, but it does not include the Visual Basic Editor needed to change a VeryHidden setting. Use desktop Excel and obtain permission to make that change.
Will unhiding a sheet change its data?
No. Unhiding changes the worksheet’s visibility, not its cell values or formulas. However, a visible sheet may contain sensitive or unfinished information, so check that it is appropriate to expose before sharing the workbook.
How do I hide the sheet again?
In desktop Excel, right-click its tab and choose Hide, or use Home > Format > Hide & Unhide > Hide Sheet. The ordinary Hide command sets it to Hidden, not VeryHidden. Workbook structure protection may prevent the change.
Related
- How to Filter in Google Sheets: Step-by-Step Guide
- Fill Color in Excel Using Keyboard Shortcuts on Windows
- How to Fill Half a Cell in Excel with Color Using Shapes
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Merge Cells Within Regions in Excel: Steps and LimitsYes. In Excel for Microsoft 365 on Windows, you can merge cells within a region by selecting a…
- Remove Formatting in Word: Keyboard Shortcuts ExplainedIn Microsoft Word for Windows, press Ctrl+Spacebar to remove direct character formatting, such as manually applied bold or…
- Google Sheets Scenario Filter: How to Rebuild ItGoogle Sheets does not have a built-in feature called Scenario Filter. To rebuild one, either create a filter…
- How to Make a Booklet in Microsoft Word, Step by StepTo make a booklet in Microsoft Word, set the document’s page layout to Book fold, write and format…
- SUMIF Negative Values in Google Sheets: A Clear GuideTo add negative numbers in Google Sheets, use SUMIF with the criterion "<0". If the values are in…
- Copy the Same Date Down an Excel Column Without Auto-FillTo copy the same date down an Excel column without Excel increasing it, enter the date in the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.