To find a hidden worksheet in Excel for Microsoft 365 on Windows, right-click any visible sheet tab, choose Unhide, select a sheet from the list, and click OK. If Unhide is unavailable or you cannot see any tabs, check the workbook’s display settings, protection, and whether the sheet is set to VeryHidden.
Excel calls each worksheet a sheet, although people often call its label at the bottom a tab. A hidden sheet is still part of the workbook; it is simply removed from the row of visible tabs. The steps below help you reveal one or more sheets and distinguish hidden sheets from other causes of missing tabs.
What You’ll Need
- The Excel workbook open in the desktop app, preferably with permission to change its sheets. If it is read-only or shared with restricted permissions, you may be able to inspect it but not save changes.
- If the workbook is protected, you may need the password from its owner to change its structure or reveal a protected sheet.
Step-by-Step
- Check whether the sheet tabs are visible. Look along the bottom edge of the Excel window for worksheet labels such as Summary or Data. If you can see at least one tab, continue to the next step. If you see no tabs at all, do not assume every sheet is hidden: Excel may have turned off the display of sheet tabs, or the workbook window may be hidden. Go to the later steps on display settings and hidden workbook windows.
- Open the Unhide command from a visible tab. Right-click any visible sheet tab, not the row or column headings in the worksheet. Choose Unhide from the context menu. You can also select Home > Format > Hide & Unhide > Unhide Sheet on the ribbon. If the command is unavailable, see Troubleshooting below.
- Choose the worksheet you want to reveal. In the Unhide dialog, select the sheet name and click OK. Excel makes that sheet visible and adds its tab to the row at the bottom. The dialog lists sheets that are hidden in the usual way; it does not show sheets set to VeryHidden.
- Repeat if you need to find more hidden sheets. Excel normally lets you unhide only one sheet at a time. Open Unhide again, select another name, and click OK. Repeat until the dialog has no more names you need to reveal. A sheet that remains absent from this list may be VeryHidden, or the workbook may be protected.
- Turn on sheet tabs if the entire row is missing. In Windows desktop Excel, choose File > Options > Advanced. Under Display options for this workbook, select the correct workbook in the drop-down if one is shown, then tick Show sheet tabs and click OK. This setting displays the tab strip; it does not change the hidden status of individual worksheets. On Mac, look in Excel > Settings (or Preferences) > View for the sheet-tab display option; labels and layout can vary by release.
- Check whether the tabs are merely squeezed out of sight. If the tab strip is visible but only one or two tabs appear, look for the horizontal scrollbar and the divider beside it. Drag the divider to give the sheet tabs more room, or use the small tab-navigation arrows at the lower left to move along the tab strip. The arrows scroll through visible tabs; they do not reveal hidden worksheets.
- Check for a hidden workbook window. A workbook window can be hidden separately from its worksheets. In Windows desktop Excel, open the View tab and choose Unhide in the Window group if that command is available. Select the workbook window in the dialog and confirm. This restores the workbook window; it is different from unhiding a worksheet. If Unhide is unavailable, there may be no hidden workbook window.
- Check workbook-structure protection. If Unhide is disabled or Excel will not change a sheet’s visibility, open the Review tab and check Protect Workbook. A workbook with its structure protected restricts actions such as hiding, unhiding, adding, or moving sheets. If you have authorization and the password, use the protection command to turn off workbook-structure protection, then try Unhide again. Ask the file owner for access rather than trying to bypass protection.
- Inspect VeryHidden sheets in the Visual Basic Editor. This is a desktop-only check for a workbook you are authorized to edit. On Windows, press Alt+F11 to open the Visual Basic Editor. In Project Explorer, expand the workbook’s project and select a worksheet. If Project Explorer is missing, press Ctrl+R. Open the Properties window with F4, find the Visible property, and check its value. A sheet marked 2 – xlSheetVeryHidden cannot be revealed using the regular Unhide dialog. Change the property to -1 – xlSheetVisible only if you are authorized to do so. On Mac, open the Visual Basic Editor from the Developer tab; keyboard shortcuts can vary with the keyboard and Excel version. If the VBA project is locked, ask its owner to make the change.
- Save and verify the result. Return to the worksheet window, confirm the restored sheet tab is present, and save the workbook if you have permission. Select the sheet and check its contents before making other changes. If you only wanted to inspect it, avoid editing data and close without saving if you do not want to keep any changes.
Common Mistakes
- Confusing the tab strip with hidden worksheets. If every tab has disappeared, first check Show sheet tabs and whether the workbook window is hidden. Those settings affect what you see, not whether each worksheet is marked hidden.
- Looking for hidden sheets in the tab-navigation arrows. The arrows at the lower left help move across tabs that are already visible. They do not open a list of hidden sheets. Use the Unhide command instead.
- Expecting Unhide to reveal several sheets at once. Select one sheet per dialog and repeat the command for other sheets. Do not mistake the fact that one sheet appeared for proof that no others are hidden.
- Assuming an empty Unhide list means the workbook has no concealed content. The list excludes VeryHidden sheets, and a hidden workbook window is a separate issue. Protection can also prevent the expected commands from being available.
- Changing a sheet’s visibility without checking with the owner. Hidden sheets can contain calculations, source data, or information intended to stay out of routine view. Reveal or edit them only when you have permission, and keep a backup when the workbook is important.
Tips
- Use sheet names as clues. Names such as Archive, Lookup, Notes, or Old Data may identify the missing worksheet, but confirm the contents before relying on it. An unhidden sheet may support formulas or reports elsewhere in the workbook.
- Check the status bar and tab area before changing settings. If tabs are present, the issue is likely an individual hidden sheet or a tab-strip layout problem. If no tabs are present, check workbook display settings first.
- Remember that hidden does not mean deleted. Formulas in visible sheets can still refer to cells on a hidden worksheet. Revealing the sheet makes it easier to inspect those inputs, but does not automatically update or repair formulas.
- Keep a clean copy before inspecting a complex workbook. Use File > Save As to create a separate copy if you may change visibility or workbook settings. This is especially useful when you are exploring an unfamiliar file or need to preserve its original presentation.
- Know the limits of Excel for the web. In a browser, you can usually right-click a visible sheet tab and choose Unhide, but the Visual Basic Editor is not available there. Open the workbook in desktop Excel for VeryHidden-sheet inspection and other advanced workbook-window checks.
Troubleshooting
Unhide is greyed out. First check whether any worksheet is hidden in the normal way; if none are, the command may have nothing to act on. Then check Review > Protect Workbook. A protected workbook structure can prevent visibility changes. If you have the password, remove the protection using Excel’s command and try again. If you do not, contact the owner.
The Unhide dialog opens but contains no sheet names. This means Excel has no normally hidden sheets available in that dialog. Check whether the tabs are being hidden by the workbook display setting, whether the workbook window itself is hidden, and whether the sheet may be VeryHidden. VeryHidden sheets require inspection in the desktop Visual Basic Editor, and some projects may be locked by their owner.
You cannot see any sheet tabs, so you cannot right-click one. In Windows, go to File > Options > Advanced and enable Show sheet tabs for the workbook. Also inspect the View tab for a hidden workbook window. If the tab strip is simply too narrow, drag its divider to make room. These checks address different causes, so try them separately rather than changing several settings at once.
The restored tab is still missing. Confirm that you are viewing the intended workbook, not another open file. Look across the full tab strip using the navigation arrows, and check whether the tabs have been scrolled out of view. If you used Unhide, verify that you selected the intended sheet name and clicked OK. In a shared or read-only workbook, your change may not be saved; check the file’s permissions and save status.
The Visual Basic Editor does not show the workbook project. In the editor, use View > Project Explorer or press Ctrl+R on Windows. Expand the project for the workbook you are checking, rather than selecting another open workbook. If the project is password-protected or you cannot edit the Visible property, stop and ask the workbook owner. Do not download unknown tools or run untrusted macros to reveal a sheet.
Frequently Asked Questions
Can I find hidden sheets without unhiding them?
In Windows desktop Excel, the Unhide dialog shows names of sheets hidden in the usual way before you reveal one. It does not list VeryHidden sheets. To inspect those, check the worksheet’s Visible property in the Visual Basic Editor if you have permission.
Why is the Unhide option missing from the right-click menu?
There may be no normally hidden worksheets, or workbook-structure protection may be on. It can also be a context-menu issue if you right-clicked in the worksheet grid instead of on a sheet tab. Try Home > Format > Hide & Unhide > Unhide Sheet when a tab is visible.
Can Excel hide a sheet so it does not appear in the Unhide list?
Yes. A sheet set to xlSheetVeryHidden does not appear in the regular Unhide dialog. Its visibility must be changed in the Visual Basic Editor, subject to workbook permissions and any project protection.
Does pressing Ctrl+Page Up or Ctrl+Page Down reveal a hidden sheet?
No. Those Windows shortcuts move between visible worksheets. They skip hidden sheets and do not change a sheet’s visibility. Use the Unhide command to reveal a normally hidden worksheet.
Can I unhide sheets in Excel for the web?
For sheets hidden in the usual way, right-click a visible sheet tab and choose Unhide if the command is available. The web app does not include the desktop Visual Basic Editor, so use desktop Excel to inspect VeryHidden sheets.
Will unhiding a sheet change its formulas or data?
Unhiding changes its visibility, not its cell contents. The sheet may still contain formulas, values, or links used elsewhere in the workbook, so avoid editing or deleting anything unless you understand its role.
Related
- How to Export an Excel Tab to Its Own Workbook
- Export an Excel Table as a Picture: Step-by-Step
- Export an Excel Sheet to an Image: Methods and Tips
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Create a Brochure in Microsoft Word: Layout, Steps and TipsTo create a brochure in Microsoft Word, start with a brochure template or set up a blank document…
- Excel Find and Replace Shortcut: Ctrl+H ExplainedIn Excel for Microsoft 365 on Windows, press Ctrl+H to open Find and Replace directly on the Replace…
- How to Schedule an Email in Outlook for iOS on iPhoneTo schedule an email in Outlook for iOS, compose your message, tap the three-dot menu, choose Schedule Send,…
- Compare Two Sheets in Excel: Differences and MethodsTo compare two sheets in the same Excel workbook, compare corresponding cells with a formula such as =IF(Sheet1!A1=Sheet2!A1,"Same","Different").…
- How to Clear Track Changes in WordTo clear tracked edits in Word, review them and choose Review > Accept > Accept All Changes to…
- Can You Hide a Column in a Power BI Table Visual?Not with a dedicated hide-column switch in a Power BI table visual. To make a column disappear, remove…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.