Excel Unhide Shortcut: Reveal Hidden Rows and Columns

How-to basics · Updated November 20, 2026

In Excel for Microsoft 365 on Windows, select the row or column headers on both sides of the hidden area, then press Ctrl+Shift+( to unhide rows or Ctrl+Shift+) to unhide columns. You can also use the ribbon key sequences Alt, H, O, U, then R for rows or C for columns. These commands reveal hidden worksheet content; they do not delete or change its values.

What You’ll Need

  • An Excel workbook with the relevant worksheet open. If it is protected, you may need permission or the password to change row or column visibility.
  • A way to identify where the hidden rows or columns are. Their row numbers or column letters will be missing from the headings, such as row 5 followed by row 8.
  • A keyboard with the Control, Shift, and Alt keys for the Windows shortcuts. On a Mac, use the Mac notes below or the Home ribbon menu.

Step-by-Step

  1. Find the hidden area. Look at the row numbers along the left edge or the column letters across the top. If the sequence jumps from row 5 to row 8, rows 6 and 7 may be hidden. If the letters jump from B to E, columns C and D may be hidden. A narrow boundary or small double line between headings can also indicate hidden content. Make sure you are on the worksheet where the missing information should appear.
  2. Select the headings around the hidden rows. To reveal rows 6 and 7 in the example, drag over row numbers 5 and 8, or click row 5, hold Shift, and click row 8. The selection needs to include the visible row immediately before and after the hidden block. You can select a larger range if you are unsure which rows are hidden. Select row headings, not just cells in the worksheet, so the command applies to whole rows.
  3. Press the row-unhide shortcut. With the surrounding row headings selected, press Ctrl+Shift+(. On a typical US keyboard, the opening parenthesis is made with Shift+9, so press and hold Ctrl and Shift, then press 9. Excel should display the selected hidden rows. If the shortcut does nothing, use the ribbon steps below; keyboard layouts or other software can affect shortcut recognition.
  4. Use the ribbon if you prefer menu commands. Select the row headings around the hidden area. Press and release Alt, then press H, O, U, and R in sequence. This opens Excel’s Home tab key tips and runs Home > Format > Hide & Unhide > Unhide Rows. Press the keys one at a time rather than holding all of them together. If the letters shown on your screen differ, follow the displayed key tips.
  5. Unhide columns when needed. Select the column letters on either side of the hidden columns. For example, to reveal C and D when they are hidden, select B and E, or select a wider range that includes both. Press Ctrl+Shift+). On a US keyboard, the closing parenthesis is Shift+0. Alternatively, press and release Alt, then press H, O, U, and C in sequence. The ribbon path is Home > Format > Hide & Unhide > Unhide Columns.
  6. Reveal all rows or columns on a worksheet. To unhide all rows, click the Select All button at the top-left corner of the worksheet grid, where the row and column headings meet. Then press Ctrl+Shift+(, or use Home > Format > Hide & Unhide > Unhide Rows. To reveal all columns, keep the whole sheet selected and use Ctrl+Shift+) or the Unhide Columns command. This affects the current worksheet, not every sheet in the workbook. If a selection made with Ctrl+A only covers a data region, click the Select All button instead.
  7. Check that the content is visible. Look at the row numbers or column letters again and confirm the sequence is continuous. If the headings are back but some content still seems missing, check for filters, collapsed groups, or other hidden rows farther down or across the sheet. Save the workbook after confirming that the restored view is what you want.

Mac and web note: Windows Alt key-tip sequences do not work the same way in Excel for Mac. On a Mac, select the surrounding row or column headings and use Home > Format > Hide & Unhide > Unhide Rows or Unhide Columns. The Control+Shift parenthesis shortcuts may also be available, but the exact key combination can depend on the keyboard layout and Excel version. Excel for the web can have browser-specific shortcut behavior; use the Home ribbon’s Format menu if a shortcut is intercepted.

Common Mistakes

  • Selecting cells instead of headings. Clicking cells in the grid can leave you with a selection that does not clearly include the rows or columns surrounding the hidden section. Click the row numbers or column letters to select entire worksheet rows or columns before using the shortcut.
  • Selecting only one side of the hidden area. If rows 6 and 7 are hidden, selecting only row 5 may not give Excel the adjacent range needed to reveal them. Include the visible heading before and after the missing section, or select the whole sheet if the location is unclear.
  • Using the wrong parenthesis key. The row shortcut uses an opening parenthesis, while the column shortcut uses a closing parenthesis. On many US keyboards these are Shift+9 and Shift+0, respectively. On a different keyboard layout, the symbols may be on other keys, so the ribbon command can be easier.
  • Assuming filtered records are hidden rows. A filter temporarily removes nonmatching records from view. The Unhide Rows command does not restore filtered-out records. Use the filter arrow in the relevant column and choose Clear Filter, or use Data > Clear to remove filters from the sheet.
  • Confusing a collapsed outline with hidden rows. Grouped rows or columns can be collapsed using outline controls, often shown as plus or minus buttons or numbered levels near the sheet headings. Click the plus sign or expand the outline level to show the grouped content; the unhide command may not be the right fix.
  • Trying to change a protected sheet. Worksheet protection can prevent changes to row and column formatting, including unhiding. If you are authorized, use Review > Unprotect Sheet and enter the password if prompted. Do not assume the workbook is broken if Excel refuses the command.

Tips

  • Use the selection as a safeguard. If you know approximately where the hidden content is, select a slightly wider range of headings than you think you need. Unhide applies to hidden rows or columns within that selected span, while visible rows and columns stay visible.
  • Make the worksheet easier to inspect. To check for hidden rows, click the Select All button and use Home > Format > Row Height. A normal positive height can restore rows whose height was set to zero. For columns, use Home > Format > Column Width. This is useful when the heading sequence looks intact but a row or column is effectively too small to see.
  • Use the ribbon command when shortcuts conflict. Shortcut symbols can be awkward on non-US keyboards, and browser or operating-system shortcuts may take precedence. Home > Format > Hide & Unhide provides a clear menu route without relying on the parenthesis keys.
  • Check hidden sheets separately. The row and column shortcuts only affect the active worksheet’s grid. To reveal a hidden worksheet tab in Windows, right-click any visible sheet tab, choose Unhide, select the sheet, and click OK. You can also use Alt, H, O, U, S in sequence. A workbook may have more than one hidden sheet, so repeat the command as needed.
  • Consider how you want the file to open. Unhiding changes the workbook’s display state. If you are sharing the file, save it after making the desired rows, columns, or sheets visible so another person does not open the older hidden view.

Troubleshooting

  • The shortcut appears to do nothing: First select the row or column headings around the hidden area and try the corresponding Home > Format > Hide & Unhide command. If the ribbon works, the issue is likely the keyboard layout, shortcut interception, or an incomplete selection. Use the key tips visible after pressing Alt rather than assuming every Excel installation displays identical letters.
  • The hidden area is at the top or left edge: If row 1 is hidden, there is no visible row heading above it to select. Click the Name Box to the left of the formula bar, enter A1, and press Enter. Then use Home > Format > Hide & Unhide > Unhide Rows. For a hidden first column, select the whole worksheet with the Select All button and use Unhide Columns. Selecting the entire sheet is also a practical way to handle a hidden first row or column when boundary selection is difficult.
  • The rows remain absent after unhiding: Check whether a filter is active by looking for filter arrows and filtered-row indicators. Clear the filter, or inspect the outline controls for collapsed groups. Also verify that the row height is not set to zero: select the relevant row range and choose Home > Format > Row Height, then enter a positive value.
  • Excel says the command cannot be used: Check whether the worksheet is protected. If you can edit the file, choose Review > Unprotect Sheet; a password may be required. If the workbook is shared or managed by someone else, ask its owner for access rather than trying to bypass protection.
  • A worksheet tab is still missing: Unhide Sheet is separate from unhiding rows and columns. Right-click a visible sheet tab and choose Unhide. If the missing sheet is not listed, it may be set to a special VeryHidden state by a macro or may not be in this workbook. Ask the workbook owner or administrator to check it; the ordinary Unhide dialog cannot display a VeryHidden sheet.
  • The command works on one sheet but not another: Each worksheet has its own row, column, filter, and protection settings. Activate the correct tab and repeat the steps there. If the workbook is protected at the workbook-structure level, sheet-tab changes may also be restricted.

Frequently Asked Questions

What is the shortcut to unhide rows in Excel?
On Windows, select the row headings around the hidden rows and press Ctrl+Shift+(. The ribbon alternative is Home > Format > Hide & Unhide > Unhide Rows.

What is the shortcut to unhide columns in Excel?
Select the column headings on both sides of the hidden columns and press Ctrl+Shift+). You can also use Home > Format > Hide & Unhide > Unhide Columns.

How do I unhide every row in a worksheet?
Click the Select All button at the top-left of the grid, then use Ctrl+Shift+( or choose Home > Format > Hide & Unhide > Unhide Rows. This applies to the active worksheet only.

Can I unhide a row if the first row is hidden?
Yes. Select the whole worksheet with the Select All button and run Unhide Rows, or enter A1 in the Name Box and use the ribbon command. Selecting the whole sheet avoids needing to click a missing row heading.

Why does Excel not restore rows after I use Unhide?
The rows may be excluded by a filter, inside a collapsed outline group, or set to zero height. Clear the filter, expand the group, or select the rows and choose Home > Format > Row Height to enter a positive height.

Does the same shortcut work in Excel for Mac?
Shortcut behavior can vary with the Mac keyboard layout and Excel version. The dependable menu route is Home > Format > Hide & Unhide, followed by the relevant Unhide command. Windows Alt key tips are not the Mac equivalent.

Related

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.