To unhide a worksheet in Excel for Microsoft 365 on Windows, right-click any visible sheet tab, choose Unhide, select the sheet, and click OK. To reveal a hidden workbook window instead, select View > Unhide and choose the workbook; if you mean a file hidden in a Windows folder, turn on File Explorer’s Hidden items view.
First identify what is hidden
Excel users can mean several different things when they say a file is hidden. A worksheet may be hidden while its workbook stays open; an entire workbook window may be hidden; or the workbook file itself may have the Hidden attribute in Windows. These situations have different fixes, so first check what you can see.
- If the workbook is open and you can see some sheet tabs, but a particular tab is missing, the worksheet is probably hidden.
- If Excel is open but the workbook’s cells and tabs are nowhere to be seen, its window may be hidden or minimized.
- If the workbook does not appear in the folder where you expect it, check whether Windows is hiding the file or whether it was moved, renamed, or deleted.
Hiding a worksheet or window does not normally delete its contents. However, hiding is not a security measure: someone with access to the workbook may be able to reveal the content. Use file permissions and appropriate access controls when information must be protected.
Unhide a worksheet from its sheet tab
The quickest method works when at least one worksheet tab is visible and the workbook’s structure is not protected. In Excel for Microsoft 365 on Windows:
- Right-click a visible worksheet tab at the bottom of the Excel window. If you use a touchpad, a two-finger click may act as a right-click.
- Choose Unhide from the context menu. If the option is unavailable, see the troubleshooting sections below.
- In the Unhide dialog box, select the worksheet name you want to restore.
- Click OK. The tab returns to the row of sheet tabs.
Excel’s standard Unhide dialog lets you select one worksheet at a time. If several sheets are hidden, repeat the steps for each one. The list contains sheets that Excel considers hidden and eligible to unhide; it does not show sheets set to the special VeryHidden state through VBA.
You can also use the ribbon: select Home > Format > Hide & Unhide > Unhide Sheet, then choose a name and click OK. This route is useful if you prefer the ribbon or cannot easily right-click the tab. Unhiding restores the sheet; it does not change its cell contents, formulas, formatting, or position in the workbook.
Unhide a workbook window
A hidden workbook window is different from a hidden worksheet. The workbook may still be open, but Excel is not displaying its window. To restore it in Excel for Microsoft 365 on Windows, select View > Unhide, select the workbook in the dialog, and click OK. The View tab’s Unhide command is available when Excel has a hidden workbook window to restore.
Afterward, the workbook’s sheets and their tabs should be visible as usual, except for any individual worksheets that are separately hidden. If you do not see the workbook in the Unhide dialog, it may not be open in that Excel instance. Check the Window controls or use File > Open to locate and open the workbook again. A minimized workbook is not necessarily hidden; check the Windows taskbar or Excel’s open-window controls before assuming the window was hidden.
On Mac, the commands can differ slightly by Excel version. Look for the workbook under the Window menu and use its Unhide command if available. Excel for the web does not provide the same desktop workbook-window hiding controls, so open the file in the desktop app if you need to manage a hidden workbook window.
Understand VeryHidden worksheets
Excel has a worksheet visibility state called VeryHidden. It is commonly used by workbook designers who want a sheet to stay out of the ordinary Unhide list. A VeryHidden sheet cannot be restored by right-clicking a tab or using Home > Format > Hide & Unhide > Unhide Sheet. This setting is not encryption or strong protection; someone who can edit the workbook in desktop Excel may be able to change it.
If you are authorized to edit the workbook and the file is trusted, you can inspect this setting in the Visual Basic Editor on Windows:
- Save a copy of the workbook first. Changing VBA properties is different from using the ordinary Unhide command, and a saved copy gives you a fallback.
- Press Alt+F11 to open the Visual Basic Editor. In the Project Explorer, find the workbook and select the worksheet object you want to reveal. If the Project Explorer is not visible, use View > Project Explorer.
- Press F4 to display the Properties window if it is not already open. Find the Visible property and change it from 2 – xlSheetVeryHidden to -1 – xlSheetVisible.
- Return to Excel and check that the worksheet tab is visible. Save the workbook if the change is intended.
The exact property display can vary slightly, but the important distinction is between xlSheetVisible, xlSheetHidden, and xlSheetVeryHidden. Do not change code or properties in an unfamiliar workbook merely to make a sheet appear. On Mac, the Visual Basic Editor is also available in desktop Excel, but the keyboard shortcut can depend on the keyboard and function-key settings; open it from Excel’s Developer tools if the shortcut does not work. Excel for the web does not provide the VBA editor.
Check workbook structure protection
If Unhide is disabled, or Excel will not let you change sheet visibility, the workbook’s structure may be protected. Structure protection can prevent sheets from being added, deleted, moved, renamed, hidden, or unhidden. It is separate from protecting a worksheet’s cells: a sheet can have protected cells without the workbook structure being protected, and the reverse can also be true.
In Windows desktop Excel, check the Review tab for Protect Workbook. If the workbook structure is protected, use the authorized password to turn off that protection, then unhide the sheet and restore protection if appropriate. The command may display a prompt for the password when you try to change the protected structure. If you do not know the password, ask the workbook owner or administrator for access. Do not assume that renaming the file or changing a file extension will remove protection.
Some workbooks are managed by an organization, contain macros, or use protection as part of a workflow. Ask the owner before changing their setup, especially if the workbook is shared or used for reporting. Unhiding a sheet can expose data that other users were not intended to see, even though hiding alone does not securely protect that data.
When sheet tabs or the Unhide command are missing
A missing tab does not always mean the worksheet is hidden. The sheet-tab area itself may be turned off, squeezed out of view, or obscured by the horizontal scrollbar. Check the following before changing workbook settings:
- Look for the small sheet-navigation arrows at the lower left of the Excel window. Use them to scroll through tabs that are outside the visible area.
- Drag the divider beside the horizontal scrollbar to make more room for sheet tabs, if the tab area has been compressed.
- In Windows desktop Excel, open File > Options > Advanced. Under Display options for this workbook, check Show sheet tabs. This setting controls whether tabs are displayed; it does not unhide a particular worksheet.
- If Unhide is dimmed, check for workbook structure protection. If the sheet is VeryHidden, use the Visual Basic Editor method only if you are authorized and the workbook is trusted.
If you are working in a shared workbook or a workbook opened in read-only mode, your permissions may limit changes. Make sure you have an editable copy and that you are looking at the correct open workbook. A file can also have multiple similarly named versions, so check the title bar and the folder location before concluding that a sheet has disappeared.
Reveal a hidden Excel file in Windows
If the workbook is absent from File Explorer rather than missing from the Excel window, Windows may be hiding the file. In Windows 11, open the folder in File Explorer, select View > Show > Hidden items, and look for the workbook. In Windows 10, use the View tab and select the Hidden items checkbox. A hidden file may appear slightly faded.
If you find the workbook and want to make it visible permanently, right-click it, choose Properties, and clear the Hidden checkbox on the General tab. Select Apply and confirm whether the change should apply to just the file or to the folder and its contents, if Windows offers that choice. Be cautious when changing a folder’s attributes: you may reveal other files that were intentionally hidden.
File Explorer’s Hidden items setting changes what Windows displays; it does not unhide worksheets inside the workbook. Conversely, Excel’s Unhide command cannot make a hidden file appear in a folder. If the file still is not listed, check other likely folders, search by its name or the .xlsx, .xlsm, or .xls extension, and review the Recycle Bin or your organization’s backup and cloud-storage history. Hidden-item display does not recover a deleted or moved file.
Excel for the web and Mac differences
In Excel for the web, worksheet tabs can generally be unhidden from the sheet-tab context menu when the workbook permits the change. The desktop ribbon and dialog may look different from the Windows instructions, and VBA-based VeryHidden settings require desktop Excel. If the web app does not offer the needed control, choose Open in Desktop App, provided you have permission and access to the installed program.
Excel for Mac also supports ordinary worksheet unhide operations, but ribbon layouts and menu locations can differ from Windows. Try control-clicking or right-clicking a visible sheet tab and choosing Unhide, or look for the sheet-unhide command on the Home ribbon. For a hidden workbook window, check the Window menu. If a command is missing, confirm whether the file is open in desktop Excel, whether its structure is protected, and whether you have edit access.
Frequently Asked Questions
Why is Unhide greyed out in Excel?
Common causes include workbook structure protection, no ordinarily hidden worksheets, or working in a view or app that does not expose the command. If the sheet is VeryHidden, the standard Unhide dialog will not list it. Check protection and confirm you are using desktop Excel if the workbook relies on VBA.
Can I unhide multiple Excel sheets at once?
The standard Unhide dialog restores one sheet at a time. Repeat the dialog for each hidden sheet. If a workbook contains many sheets, ask its owner whether they intended them to be hidden before changing the workbook’s layout or using a macro.
Does hiding a worksheet protect its data?
No. Hiding mainly changes what is displayed. A user may be able to unhide an ordinary hidden sheet, and a VeryHidden sheet is not encrypted. Use appropriate workbook access controls or remove sensitive information from a file that should not contain it.
How do I unhide an Excel file on my computer?
If it is missing from a Windows folder, enable View > Show > Hidden items in Windows 11 File Explorer or the Hidden items checkbox on Windows 10. If the workbook is open but its contents are missing, use Excel’s worksheet or workbook-window unhide commands instead.
Why can’t I see any sheet tabs?
The tabs may be switched off, scrolled out of view, or squeezed by the scrollbar; alternatively, the workbook window may be hidden. In Windows desktop Excel, check File > Options > Advanced > Display options for this workbook > Show sheet tabs, then check the View > Unhide command for a hidden workbook window.
Related
- What Is Power Query? Excel Data Cleanup Explained
- AI and Power Query: What It Can and Cannot Do in Excel
- Power Query Split Cell Into Rows: Steps and Examples
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Shortcut for a New Sheet: Shift+F11In Excel for Microsoft 365 on Windows, press Shift+F11 to insert a new worksheet in the current workbook.…
- How to Delete a Page in the Middle of a Word DocumentTo delete a page in the middle of a Word document, place the cursor on that page, select…
- PowerPoint Audio Controls: Add and Customize PlaybackTo add audio controls to a PowerPoint slide, insert an audio file with Insert > Audio, select the…
- Google Sheets Data Validation for Duplicate EntriesYes. Google Sheets can reject duplicate entries with a custom-formula data validation rule: for a list in A2:A,…
- How to Archive Years of Emails in OutlookTo archive years of email in Outlook, search for messages older than a chosen date, review the results,…
- Excel Page Break Dotted Lines: Meaning and Fixes ExplainedExcel page break dotted lines mark where the worksheet is expected to split across printed pages. To hide…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.