How to Unhide Rows in Excel With a Shortcut

How-to basics · Updated November 20, 2026

To unhide rows in Excel for Microsoft 365 on Windows, select the row headers immediately above and below the hidden rows, then press Ctrl+Shift+9. The hidden rows should reappear. If you need to reveal every hidden row, select the whole worksheet first and use the same shortcut. This works for rows hidden manually; filtered-out rows and collapsed outline groups need different steps.

What You’ll Need

  • A workbook open in desktop Excel, with the hidden rows in the worksheet you want to change.
  • Access to the row headers along the left edge of the sheet, so you can select the relevant rows.
  • A Windows keyboard for Ctrl+Shift+9. On a Mac, try Command+Shift+9; if the shortcut is unavailable or behaves differently with your keyboard layout, use the ribbon method below.

You do not need to enable a setting or install anything. If the sheet is protected, however, you may need permission to make formatting changes before Excel will let you unhide rows.

Step-by-Step

  1. Find the hidden-row marker. Look at the row numbers on the left side of the worksheet. A jump in the numbering, such as row 12 followed by row 16, indicates that rows 13 through 15 are not currently visible. The small double line between row headers can also mark a hidden section. If you cannot tell where the missing rows are, select the whole sheet as described in step 6.
  2. Select the row above the hidden section. Click the number in the row header, not a cell in the grid. For example, if rows 13 through 15 are hidden, click the header for row 12. Selecting row headers makes it clear to Excel that you want to change row visibility rather than edit cell contents.
  3. Include the row below the hidden section. Hold down the mouse button and drag over the row headers on both sides of the gap. In the example, select row 12 and row 16, including the visible rows in between only if there are any. You can also click row 12, hold Shift, and click row 16. For a block of several hidden rows, selecting the visible boundary rows on either side is usually enough.
  4. Use the Windows shortcut. With the relevant row headers selected, press Ctrl+Shift+9. Hold Ctrl and Shift, then press the 9 key on the main keyboard. On many keyboard layouts, this is described as Ctrl+Shift+( because Shift+9 produces an opening parenthesis. Avoid using the numeric keypad if the shortcut does not respond; it may send a different key.
  5. Check the result. Look at the row numbers again. The numbering should now run continuously through the section, and the rows should be visible. If the rows are still absent, do not repeatedly press the shortcut without checking the cause. A filter, outline group, zero row height, or sheet protection may be responsible instead.
  6. Unhide all rows in the worksheet, if needed. Click the Select All button at the top-left corner of the grid, where the row and column headers meet. Then press Ctrl+Shift+9. Selecting the entire worksheet tells Excel to reveal all manually hidden rows, including ones whose location you did not know. This does not clear filters or expand grouped rows, and it does not delete or alter cell values.
  7. Use the ribbon if you prefer menus or the shortcut fails. Select the row headers covering the hidden section, then choose Home > Format > Hide & Unhide > Unhide Rows. To reveal all manually hidden rows, select the entire sheet first and choose the same command. The ribbon route is also a reliable alternative when a keyboard layout or another program intercepts the shortcut.
  8. On a Mac or in Excel for the web, choose the best available route. In Excel for Mac, select the row headers and try Command+Shift+9; if your version or keyboard does not respond, use Home > Format > Hide & Unhide > Unhide Rows. In Excel for the web, keyboard shortcuts can vary by browser and may conflict with browser commands, so the ribbon command is a dependable choice. The exact toolbar layout can vary with the window size.

Common Mistakes

  • Selecting cells instead of row headers. A cell selection may not clearly identify the rows you mean to reveal. Click the numbered headers on the left, or select the whole sheet using the top-left Select All button.
  • Selecting only a cell inside a hidden row. You cannot click a row that is not visible. Select the visible row headers immediately before and after the gap, or select the whole worksheet.
  • Assuming every invisible row is manually hidden. A filter hides records that do not match its criteria, and an outline can collapse grouped rows. Ctrl+Shift+9 does not remove a filter or expand an outline. Check the column filter buttons and the outline controls beside the row numbers.
  • Pressing the wrong key combination. On Windows, the 9 key usually needs Shift to produce the shortcut. Use the number row rather than relying on the numeric keypad, and try the ribbon command if your keyboard layout maps the key differently.
  • Unhiding a column by mistake. Excel has a separate shortcut for columns. Check that you have selected row numbers at the left, not column letters across the top, before using the command.
  • Expecting the shortcut to override protection. A protected sheet can restrict formatting actions such as changing row height or visibility. If the command is unavailable or makes no change, check the Review tab and ask the workbook owner for permission rather than trying to bypass protection.

Tips

  • Use the row-number gap to choose the selection. For a small hidden block, selecting the visible row above and the visible row below makes your intended range easy to verify. For example, if row 28 is followed by row 34, select row headers 28 and 34 before using the shortcut.
  • Choose Select All when you do not know where rows are hidden. The button is the small corner square above row 1 and left of column A. This can save time in a large sheet with several scattered hidden sections. It also selects all columns, but the unhide-rows command only changes row visibility.
  • Keep the ribbon path in mind. Home > Format > Hide & Unhide > Unhide Rows is useful when demonstrating the action, using a touch device, or working with an unfamiliar keyboard. The same command can also help confirm that you are looking for the correct feature.
  • Distinguish hidden rows from zero-height rows. Setting a row height to zero makes a row disappear much like hiding it. Unhide Rows often restores it; if not, select the affected row range and choose Home > Format > Row Height, enter a positive value such as 15, and select OK. Row height is measured in points, and the appropriate value depends on the worksheet’s font and content.
  • Check before unhiding a very large sheet. Revealing all rows may make a worksheet longer and expose information that was hidden for presentation. It does not erase content, but consider whether you are sharing or printing the workbook before changing its layout.

Troubleshooting

The shortcut has no effect: First verify that you selected row headers on both sides of the hidden block. Press the keys together, using the number-row 9 key, and try the ribbon command. If the ribbon command is disabled, check whether the worksheet is protected. A workbook shared with restricted editing may also prevent layout changes.

The row numbers skip, but Unhide Rows does nothing: Look for filter arrows in the header row. Open the relevant column’s filter menu and choose Clear Filter From that column, or use the filter controls on the Data tab to clear the active filters. The exact command can depend on how the table or range was filtered. Clearing a filter changes which records are displayed; it does not alter the underlying data.

There are outline symbols or plus and minus buttons beside the row numbers: The rows may be grouped and collapsed, rather than hidden individually. Click the plus button beside the group to expand it. You can also use the outline level buttons above the row numbers to show a broader level of detail. Expanding a group is different from unhide, so Ctrl+Shift+9 may not change it.

A row still looks missing after unhiding: Check whether its height is extremely small. Select the surrounding row headers and use Home > Format > Row Height to assign a visible height. Also check for a filter or collapsed group; more than one of these conditions can apply in the same sheet.

You cannot identify the hidden section: Select the whole worksheet with the Select All button and run the unhide command. If that does not reveal the expected records, inspect filters and outline controls next. If the sheet is protected, contact its owner or use an authorized password to unprotect it through Review > Unprotect Sheet.

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. In shortcut descriptions, this may appear as Ctrl+Shift+( because Shift+9 types an opening parenthesis on many keyboards.

How do I unhide every row at once?

Click the Select All button at the top-left corner of the worksheet, then press Ctrl+Shift+9. You can also use Home > Format > Hide & Unhide > Unhide Rows. This reveals rows hidden manually, not records excluded by a filter or rows in a collapsed group.

What is the unhide-rows shortcut on a Mac?

In Excel for Mac, try Command+Shift+9 after selecting the relevant row headers. If that combination is unavailable on your keyboard or does not work in your version, use the Home tab’s Format menu and choose Hide & Unhide > Unhide Rows.

Can I unhide a row without knowing its number?

Yes. Click Select All at the top-left of the grid and use the unhide shortcut or ribbon command. Excel will reveal all manually hidden rows on that worksheet, so you do not need to locate each gap first.

Why does Ctrl+Shift+9 not reveal filtered rows?

Filters temporarily show only records that meet selected criteria; they do not mark the other rows as manually hidden. Clear the relevant filter using its dropdown or the Data tab. If rows are grouped, expand the outline instead.

Will unhiding rows change or delete their contents?

No. Unhide Rows changes visibility, not cell values or formulas. The rows become visible in the worksheet again, though filters or grouping can still limit what you see.

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.