Excel Unhide Shortcut: Show Hidden Rows, Columns & Sheets

In Excel for Microsoft 365 on Windows, select the row or column headers around the hidden area, then press Ctrl+Shift+9 to unhide rows or Ctrl+Shift+0 to unhide columns. To show a hidden worksheet, press Alt, then H, O, U, and S in sequence, and choose the sheet in the dialog.

Which unhide shortcut should you use?

Excel has different commands for hidden rows, hidden columns, and hidden worksheets. The shortcut depends on what disappeared, so first identify whether row numbers, column letters, or a sheet tab is missing.

Rows: Select the row headers immediately above and below the hidden rows, then press Ctrl+Shift+9. On a US keyboard, this is also described as Ctrl+Shift+(.
Columns: Select the column headers on either side of the hidden columns, then press Ctrl+Shift+0. On a US keyboard, this corresponds to Ctrl+Shift+).
Worksheets: Use Alt, H, O, U, S in that order, then select the worksheet and confirm.

These are Windows shortcuts. The Alt sequence is a series of ribbon key tips, not a chord: press and release each key rather than holding all four letters together. If a shortcut does nothing, use the ribbon method below; keyboard layouts and Windows settings can affect whether particular key combinations work.

Unhide rows with the ribbon or mouse

For a visual route, select the row headers on both sides of the hidden rows. For example, if row 8 is hidden, select row headers 7 and 9. Right-click the selection and choose Unhide. You can also use Home > Format > Hide & Unhide > Unhide Rows.

When several consecutive rows are hidden, select the visible row headers immediately before and after the gap. If rows 8 through 11 are hidden, select rows 7 and 12. Excel treats the selected boundary as the area in which it should reveal hidden rows. You can select a larger range if you do not know exactly where the hidden rows are.

To reveal hidden rows throughout a worksheet, select the entire sheet using the small triangle at the top-left corner between the row numbers and column letters, then choose Home > Format > Hide & Unhide > Unhide Rows. This affects hidden rows on that sheet, so avoid it if you only intend to reveal a small section.

Unhide columns and handle the shortcut conflict

To unhide columns, select the column letters on both sides of the gap. If column C is hidden, select B and D, then use the shortcut or choose Home > Format > Hide & Unhide > Unhide Columns. You can also right-click the selected column headers and choose Unhide. To reveal every hidden column on the sheet, select the whole worksheet first.

The Windows shortcut Ctrl+Shift+0 is easy to misread: it uses the zero key, not the letter O. It may also be intercepted by Windows or unavailable with some keyboard and regional settings. If it fails, do not assume the columns cannot be restored; use the ribbon path or right-click method. On a Mac, common default equivalents are Command+Shift+9 for rows and Command+Shift+0 for columns, but menu labels and keyboard behavior can vary with the keyboard layout. The ribbon route is a dependable alternative: Home > Format > Hide & Unhide.

Show a hidden worksheet

A hidden worksheet is different from hidden rows or columns. On Windows, press Alt, H, O, U, S in sequence to open the Unhide dialog. Choose the worksheet name and select OK. Or right-click any visible sheet tab, choose Unhide, select the sheet, and confirm.

You can also use the ribbon: Home > Format > Hide & Unhide > Unhide Sheet. Excel’s standard Unhide dialog restores one sheet at a time. If the Unhide command is unavailable or the expected sheet is not listed, check whether the workbook structure is protected and whether the sheet is hidden in a special way, as explained below.

In Excel for Mac, right-click a visible sheet tab and choose Unhide, or use the equivalent Format controls available in the ribbon. If the keyboard shortcut differs on your Mac, the sheet-tab menu avoids having to guess which key combination your layout uses.

Why unhide may not work

A shortcut only reveals cells that Excel considers hidden and that are included in your selection. If the command appears to fail, check these common causes before changing the workbook more broadly:

The hidden area is outside the selection. Include the visible row or column headers on both sides, or select the whole sheet before using Unhide.
The row height or column width is zero. This can look just like hiding. Select the affected row or column headers and use Home > Format > Row Height or Column Width, then enter a positive value.
A filter is hiding records. Filtered-out rows are not ordinary hidden rows. Clear or adjust the filter using the filter controls, or choose Data > Clear when appropriate. Unhide Rows may not restore records excluded by a filter.
An outline is collapsed. Grouped rows or columns can be collapsed with outline controls, often shown as plus and minus buttons or level numbers beside the worksheet. Expand the group with those controls, or use the outline commands on the Data tab.
The sheet is very hidden or workbook structure is protected. A very hidden sheet does not appear in Excel’s normal Unhide dialog. Workbook structure protection can also prevent changing sheet visibility. The workbook owner may need to change the visibility setting or remove protection.

Hidden worksheet versus hidden workbook window

There is another easily confused case: the entire workbook window may be hidden, rather than an individual worksheet. A workbook window contains the sheet tabs and grid; hiding that window can make the whole file seem to vanish while Excel remains open. In Windows Excel, check View > Window > Unhide and choose the workbook window if it is listed. This is not the same command as Unhide Sheet.

If the workbook window is visible but a particular tab is missing, use the sheet unhide steps instead. If the workbook is open but you cannot see the tab strip, check Excel’s display settings and the workbook window size before concluding that a sheet was hidden. Tabs can also be difficult to spot when the window is narrow or many sheets are present.

Hidden data, filters, and privacy

Hiding a row, column, or worksheet changes what is displayed; it does not securely remove the underlying data. Anyone with access to the workbook may be able to reveal ordinary hidden content. A hidden sheet is not a password-protected place for confidential information, and workbook protection should not be treated as encryption or a substitute for appropriate access controls.

For example, a budget workbook might hide a column containing intermediate calculations to make a report easier to read. The values and formulas remain in the file, and a recipient can unhide the column. If a workbook is being shared, remove sensitive content or use suitable file-level protections rather than relying on hidden rows or sheets to keep it secret.

Choosing the fastest method

Use a keyboard shortcut when you know the hidden area and work in Excel regularly. It is quick, but it depends on selecting the right headers first, and the column shortcut can be unavailable on some Windows setups. The ribbon or right-click method is easier to remember and makes the kind of object being restored more explicit.

One known hidden row or column: Select the headers around it and use the shortcut or right-click Unhide.
Several unknown hidden rows or columns: Select the whole worksheet, then use the relevant command under Home > Format > Hide & Unhide.
A missing worksheet tab: Open Unhide Sheet and choose its name.
Nothing changes: Check for filters, collapsed outlines, zero height or width, protection, or a hidden workbook window.

After restoring the display, review nearby rows and columns to make sure the result is what you intended. If the workbook has filters or grouped sections, preserve those settings unless your goal is to change them; clearing a filter or expanding an outline can alter the displayed data without changing whether cells are technically hidden.

Frequently Asked Questions

What is the shortcut to unhide rows in Excel?
On Windows, select the row headers around the hidden rows and press Ctrl+Shift+9. If the shortcut does not work, use Home > Format > Hide & Unhide > Unhide Rows.

How do I unhide columns if Ctrl+Shift+0 does not work?
Select the column headers on either side of the hidden columns, then use Home > Format > Hide & Unhide > Unhide Columns or right-click and choose Unhide. Windows or the keyboard layout may prevent the shortcut from being recognized.

What is the shortcut to unhide a sheet in Excel?
On Windows, press Alt, H, O, U, S one after another. Select the sheet in the Unhide dialog and confirm. You can also right-click a visible sheet tab and choose Unhide.

Why is Unhide greyed out in Excel?
There may be no hidden row, column, or sheet within the current selection, or workbook structure protection may block changes to sheet visibility. A filtered row or collapsed outline also needs its own filter or expand control rather than the ordinary Unhide command.

Can I unhide every sheet at once?
Excel’s standard Unhide dialog restores one worksheet at a time. Select a sheet, confirm, and repeat for other hidden sheets. Sheets set to VeryHidden do not appear in that dialog and require a change to their visibility setting by someone with appropriate workbook access.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.