In Excel for Microsoft 365 on Windows, press Alt, then H, O, U, and S one key at a time. In the Unhide dialog, select the sheet and press Enter. This ribbon Key Tip sequence opens the unhide list; it is not a single key combination. The workbook must be open, and the sheet must be hidden rather than deleted.
What You’ll Need
- Excel for Microsoft 365 on a Windows computer, with the workbook open.
- A workbook containing at least one hidden worksheet. The shortcut cannot restore a deleted sheet.
- If the workbook structure is protected, permission and the password to remove that protection before changing which sheets are visible.
You do not need to enable macros to unhide an ordinary hidden sheet. If you are using Excel for Mac or Excel for the web, see the platform notes in the steps below: the Windows key sequence is not a universal shortcut across all versions.
Step-by-Step
- Open the workbook and check the sheet tabs. Look along the bottom of the Excel window, where visible worksheet tabs appear. A hidden worksheet will not have a tab there. If you do not see any tabs at all, the workbook may have sheet-tab display turned off; that is different from hiding every individual sheet. You can still try the ribbon sequence, but first confirm that you are in the correct workbook and worksheet window.
- Click inside the workbook grid. Select any cell in the workbook so Excel is active, rather than another application or a text box. The Key Tips are for the Excel ribbon, so they may not respond as expected if a cell is being edited. If you see a text cursor inside a cell, press Esc once to leave edit mode before continuing.
- Start the Key Tip sequence with Alt. Press and release Alt. Do not hold it down while typing the remaining letters. Excel displays small letter labels on ribbon tabs and commands; these labels are called Key Tips. If the labels do not appear, click the worksheet grid once and press Alt again.
- Choose the Home tab. Press H. This moves the Key Tip focus to the Home tab. If the letters on your screen differ because of your Excel version, language, or customized ribbon, follow the visible labels rather than guessing. The goal is to open Home and then reach the Format menu.
- Open the Format menu. Press O. On the standard Microsoft 365 Windows ribbon, this opens the Format menu in the Cells group. If you prefer, you can click Home on the ribbon, then click Format. The visible menu provides the same route and is useful if your keyboard layout or ribbon customization changes the labels.
- Open the Hide & Unhide submenu. Press U to open Hide & Unhide. If the Key Tip sequence does not match what you see, use the mouse: choose Home > Format > Hide & Unhide. This menu contains commands for hiding and showing rows, columns, and worksheets, so take care to select the sheet command rather than an option for rows or columns.
- Choose Unhide Sheet. Press S to select Unhide Sheet. Alternatively, click Unhide Sheet in the submenu. Excel opens a dialog listing worksheets that are hidden and eligible to be shown. The dialog may list just one name or several. It does not display sheets that were deleted, and a very hidden sheet will not normally appear in this list.
- Select the worksheet and confirm. Use the arrow keys to highlight the sheet you want, then press Enter; you can also click its name and choose OK. Excel returns to the workbook and adds that sheet’s tab. If you selected the wrong one, repeat the sequence and unhide the intended sheet. Excel unhides one worksheet per use of this dialog, so repeat the steps for each additional sheet.
- Check that the sheet is available. Look at the sheet tabs and click the restored tab to confirm that it opens. If the tab is outside the visible part of the tab bar, use the sheet-navigation arrows at the lower left of the window or widen the Excel window. Those arrows move through tabs; they do not unhide sheets. If the Unhide Sheet command was unavailable, use the troubleshooting section below before assuming the sheet is gone.
Mac: The Windows sequence Alt, H, O, U, S is not the standard Mac route. In Excel for Mac, use the menu bar and choose Format > Sheet > Unhide, then select the worksheet and confirm. Depending on the keyboard and macOS settings, ribbon Key Tips can behave differently, so the menu path is the dependable option when the Windows sequence does not apply.
Excel for the web: Use the worksheet-tab context menu if it offers Unhide, or look for Home > Format > Hide & Unhide > Unhide Sheet on the ribbon. The browser and version can affect available keyboard Key Tips, so use the on-screen command if the Windows sequence does not open the dialog. A workbook opened in a browser may also have editing restrictions set by its owner.
Common Mistakes
- Holding every key together. This is a sequence of Key Tips, not a chord such as Ctrl+Shift+S. Press and release each key in turn: Alt, H, O, U, S.
- Using the row or column unhide shortcut. Excel has separate commands for rows and columns. A shortcut intended to show hidden rows will not show a worksheet. Use the Hide & Unhide submenu and choose Unhide Sheet.
- Expecting all hidden sheets to return at once. The dialog lets you select one sheet per operation. If several are hidden, repeat the process and check the tab bar after each one.
- Assuming a missing tab means a hidden sheet. A sheet may have been deleted, the workbook may have no visible sheet tabs, or the workbook structure may be protected. The Unhide dialog helps distinguish an ordinary hidden sheet from a sheet that is not available to unhide.
- Choosing a sheet based only on its position. The dialog lists sheet names, not a preview of their contents. If names are similar, read the full name carefully before confirming, then check the restored sheet before making edits.
Tips
- Use the menu path if you forget the letters. The mouse route Home > Format > Hide & Unhide > Unhide Sheet gives you the same result and makes it clear which command you are selecting. It is also a practical fallback after an Office update or ribbon customization.
- Know the difference between hidden and very hidden. A normal hidden sheet is listed in the Unhide dialog. A very hidden sheet is a workbook setting generally used by workbook authors and is not exposed through that dialog. If you own the file, you may be able to change its Visible property in the Visual Basic Editor. Only do that if you are authorized and comfortable using VBA; follow your organization’s macro policy.
- Check for workbook structure protection before changing anything else. When workbook structure is protected, Excel can disable actions such as hiding, unhiding, renaming, or moving sheets. The protection control is on Review > Protect Workbook. If protection is enabled, ask the workbook owner for authorization and the password; do not try to bypass the restriction.
- Keep the sequence available as a note. For the standard Windows ribbon, remember “Alt, H, O, U, S” as five separate presses. If the sequence stops at a menu, look at the Key Tips currently displayed and continue from those labels. Press Esc to cancel a menu and begin again if you lose track.
- Expect sheet visibility to affect everyone using the file. Unhiding a worksheet changes the workbook itself, not just your personal view. In a shared or business workbook, follow the owner’s instructions and save only if you are meant to make that change.
Troubleshooting
The sequence does nothing. Make sure the desktop Excel workbook is active, press and release Alt, and look for Key Tips before pressing H. If you are editing a cell, press Esc first. If the Key Tips shown do not match the expected letters, your language, ribbon layout, or Excel build may use different labels. Cancel with Esc and use the visible ribbon commands instead.
Unhide Sheet is dimmed or unavailable. First check whether the workbook structure is protected. If it is, ask the owner or administrator to provide authorized access and the password. Also confirm that you are using a workbook format and editing mode that permits changes; a read-only file or a browser session with view-only permissions will not let you change sheet visibility. Do not make a separate copy to get around a restriction unless the owner permits it.
The Unhide dialog opens but shows no sheet names. Excel has no ordinary hidden worksheet available in that dialog. The sheet may already be visible but off the screen in the tab bar, it may have been deleted, or it may be very hidden. If you suspect a very hidden sheet and you have permission, ask the workbook author or an Excel administrator to inspect it. A very hidden sheet typically needs its visibility changed in the Visual Basic Editor; the regular shortcut cannot reveal it.
The sheet is unhidden but you still cannot find its tab. Use the tab-navigation arrows at the bottom left to scroll through sheet tabs, or widen the workbook window. If all tabs are absent, check Excel’s display settings for sheet tabs. On Windows, open File > Options > Advanced, find Display options for this workbook, and confirm Show sheet tabs is selected. This setting displays tabs; it does not change whether an individual sheet is hidden.
You selected a sheet, but changes are blocked. Unhiding a tab does not remove protection from the worksheet’s cells or the workbook’s structure. If Excel shows a protection message when you try to edit, ask the file owner for the appropriate password or permissions. If the sheet appears but cannot be changed, its contents may be protected even though its visibility has been restored.
Frequently Asked Questions
What is the keyboard shortcut to unhide a sheet in Excel?
In Excel for Microsoft 365 on Windows, press Alt, H, O, U, S in order, then choose a sheet in the dialog and press Enter. These are sequential ribbon Key Tips, not keys held down together.
Can I unhide a sheet with one keystroke?
No standard single-key shortcut directly unhides a worksheet. The Windows Key Tip sequence opens the Unhide dialog, where you must choose the sheet. If you only use the mouse occasionally, the Home > Format > Hide & Unhide > Unhide Sheet path is an equivalent option.
Can I unhide several sheets at the same time?
No. The standard Unhide dialog restores one worksheet at a time. Repeat the command for each sheet you need to show. The dialog lists the available hidden sheets, so you can choose the next name without changing anything else in the workbook.
Why is my hidden sheet missing from the Unhide list?
It may be very hidden, already visible with its tab outside the current view, deleted, or unavailable because of workbook protection or editing permissions. A very hidden sheet cannot be restored through the ordinary Unhide dialog. Ask the workbook owner to check its status if you do not have permission to inspect workbook settings.
Does the Windows shortcut work in Excel for Mac?
Do not rely on the Windows Key Tip sequence on a Mac. Use Format > Sheet > Unhide from the Excel menu bar, select the sheet, and confirm. Keyboard behavior can depend on macOS and Excel settings, while the menu route is straightforward.
Related
- Strikethrough in Excel: Keyboard Shortcut and How to Use It
- How to Split a Page in Excel for Viewing or Printing
- How to Split Cells in Half in Excel: 3 Practical Methods
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Cell Service in Jurong East: What to CheckIf you mean a business called “Excel Cell Service” in Jurong East, I can’t reliably confirm that such…
- Can You Merge Cells in OneNote? Steps and LimitsYes. In the OneNote desktop app for Windows, you can merge adjacent cells in a table: select the…
- How to Indent Bullet Points in ExcelTo indent a bullet point in Excel, put a bullet character at the start of a cell’s text,…
- Excel Shortcut Keys for Fill Color: Windows and MacIn Excel for Microsoft 365 on Windows, press Alt, then H, then H to open the Fill Color…
- How to Make Columns in Word After a Title or HeadingTo put text in columns below a full-width title in Microsoft Word, select the body text and choose…
- Insert an Image in an Excel Comment Box or NoteTo put a picture inside an Excel comment box, create a legacy note, then set its fill to…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.