How to Unhide Rows in Excel: Quick Steps and Fixes

How-to basics · Updated November 21, 2026

To open hidden rows in Excel for Microsoft 365 on Windows, select the row headers immediately above and below the missing rows, right-click the selection, and choose Unhide. You can also use Home > Format > Hide & Unhide > Unhide Rows. These methods restore rows hidden manually; rows concealed by a filter or collapsed group need a different action.

Unhiding makes the rows visible again without changing their contents or formulas. Before you begin, check that you are on the right worksheet. If the workbook is shared or important, avoid changing other formatting while you work.

What You’ll Need

  • The Excel workbook with the worksheet containing the hidden rows.
  • Permission to edit the worksheet. A protected sheet may prevent you from changing row visibility.
  • The row numbers around the gap, if you can identify them. You do not need to know exactly how the rows were hidden to try the standard Unhide command.

Step-by-Step

  1. Find the gap in the row numbers. Look down the numbered row headers at the left edge of the worksheet. If the numbers jump from 12 to 16, rows 13 through 15 are not currently visible. A narrow horizontal line between row headers can also indicate hidden rows. Make sure you are looking at the correct sheet tab.
  2. Select the row headers around the gap. Click the number of the visible row immediately above the hidden section, then drag down to the visible row immediately below it. For example, if rows 13–15 are missing, select the headers for rows 12 through 16. Selecting the bordering visible rows is important: selecting only a visible cell inside the sheet may not include the hidden rows in the command.
  3. Use the row-header shortcut menu. Right-click any selected row number and choose Unhide. The missing rows should appear between the surrounding rows. If you do not see Unhide, check that you selected row headers rather than cells, and make sure the sheet is not protected.
  4. Use the ribbon if you prefer. With the relevant row headers selected, go to Home > Format > Hide & Unhide > Unhide Rows. Excel restores the selected hidden rows. The command is on the Home tab in the Cells group; in a narrow Excel window, some ribbon controls may be compressed into menus.
  5. Unhide every row on the current sheet if the missing rows are unclear. Click the small triangle at the upper-left corner of the worksheet, where the row numbers and column letters meet, to select the whole sheet. Then choose Home > Format > Hide & Unhide > Unhide Rows. This affects row visibility on the active worksheet, not every sheet in the workbook. Check the result before repeating it on another tab.
  6. Try the keyboard shortcut when appropriate. On Windows, select the row headers around the gap and press Ctrl+Shift+( to unhide rows; on many keyboards the same combination is written as Ctrl+Shift+9. On Mac, the corresponding shortcut is generally Command+Shift+9. Keyboard layouts and Excel settings can affect shortcuts, so use the ribbon path if the combination does not work. In Excel for the web, the ribbon command is the dependable option if a browser or system shortcut takes precedence.
  7. Check that the result is what you intended. Confirm that the row numbers now run consecutively and that the restored data is visible. If the gap remains, do not repeatedly click Unhide without checking the cause. Filtering, outline grouping, a zero row height, or worksheet protection can make rows appear missing and require a different fix.

For a single hidden row, select the visible row headers immediately above and below it. For several consecutive hidden rows, select the visible headers at both ends of the hidden block, including the rows that border it. If the first row of the sheet is hidden, there is no row above it to select; use the select-all triangle and then run Unhide Rows instead.

Common Mistakes

  • Selecting cells instead of row numbers. The command can be hard to apply to the intended rows when only worksheet cells are selected. Click or drag on the numbered headers at the left.
  • Selecting just one bordering row. If a hidden block is between two visible rows, select the headers on both sides of the gap. Selecting a broader range of row headers that spans the gap is also a practical option.
  • Assuming every missing row was manually hidden. A filter hides records that do not meet its criteria, and a collapsed outline hides grouped rows. The standard Unhide command does not clear a filter or expand a group.
  • Confusing hidden rows with frozen panes. Freeze Panes keeps selected rows or columns in place while you scroll; it does not remove them. Scroll to the top or left of the sheet, or review View > Freeze Panes if the layout is confusing.
  • Changing the wrong worksheet. Each sheet has its own rows and visibility settings. Check the active sheet tab before selecting all and unhiding rows.
  • Overlooking a protected sheet. If Excel will not let you change visibility or the command is unavailable, a protection setting may be blocking edits. Do not assume the workbook is broken.

Tips

  • Use the row-number jump as a quick clue. A sequence such as 20, 21, 25 usually means rows 22–24 are hidden or filtered. Inspect the ribbon and outline controls before deciding which explanation fits.
  • Unhide only the section you need. Selecting the headers around one gap keeps the change limited and makes it easier to see what you restored. Use select-all only when multiple hidden rows are scattered around the sheet or you cannot locate the affected range.
  • Check for multiple gaps. Unhiding one block does not guarantee all hidden rows are visible. Scan the row numbers above and below the restored area, or use the select-all method if the goal is to show every row on that sheet.
  • Remember that showing rows does not edit their contents. Unhide changes visibility, not formulas or values. However, once visible, previously concealed information may be seen by anyone who can access the workbook, so consider that before sharing it.
  • On Mac, use the same row-header or ribbon approach. The ribbon labels are similar in Excel for Mac, though window layout and shortcut behavior may differ. In Excel for the web, use the row-header context menu or Home ribbon; browser shortcuts can intercept key combinations.
  • Keep a copy if the workbook has a carefully formatted layout. Unhiding itself is a limited change, but the copy gives you a safe way to compare the original if you accidentally alter row height or other formatting while investigating.

Troubleshooting

The row numbers still skip after you choose Unhide. First make sure the selection included the row headers on both sides of the gap, then run the ribbon command again. If it still does not work, check whether the rows are filtered, grouped, or on a protected sheet. Try the select-all triangle followed by Unhide Rows to rule out a selection issue.

The rows are visible in the row numbers but their contents seem missing. They may have an extremely small or zero height rather than being hidden in the usual way. Select the affected row headers, then go to Home > Format > Row Height and enter a positive value, such as 15 points. The best height depends on the font and content, so increase it if text is still clipped. You can also use Home > Format > AutoFit Row Height to size rows to their contents.

Unhide has no effect, but filter arrows are visible. A filter may be excluding the records. Open the relevant filter drop-down and choose its clear-filter option, or go to Data > Sort & Filter > Clear to clear filters on the sheet. Clearing a filter can reveal many records at once, so check the displayed data before sharing or editing it. Do not confuse clearing a filter with removing the filter controls themselves.

There is an outline or plus sign beside the row numbers. The rows may belong to a collapsed group. Click the plus sign next to the group to expand it. If outline symbols are not obvious, look for level buttons or brackets beside the row headers. Use the outline controls to show the group; Unhide Rows is not the right way to expand a collapsed outline.

The Unhide command is disabled or Excel refuses the change. Look at the Review tab for sheet protection. If you have authorization and the password, choose Review > Unprotect Sheet, enter the password if prompted, and try again. If you do not have permission or the password, ask the workbook owner rather than trying to bypass protection. A file opened read-only may also need to be saved as an editable copy, if you are allowed to do so.

The shortcut types a character or does something else. Shortcut behavior varies by keyboard layout, Mac settings, and browser. Select the row headers and use Home > Format > Hide & Unhide > Unhide Rows instead. This also helps distinguish a shortcut problem from a selection or protection problem.

Frequently Asked Questions

How do I unhide the first row in Excel?
Click the select-all triangle above row 1 and left of column A, then choose Home > Format > Hide & Unhide > Unhide Rows. The first row has no visible row above it, so selecting the whole sheet is the simplest approach.

Can I unhide all rows at once?
Yes. Select the entire active worksheet with the upper-left triangle, then use Home > Format > Hide & Unhide > Unhide Rows. This shows manually hidden rows on that sheet, but it does not necessarily reveal filtered-out records or expand collapsed groups.

Why does Excel skip row numbers?
Rows may be manually hidden, excluded by a filter, or concealed inside a collapsed outline group. A jump in the row numbers is a clue, not a diagnosis. Try Unhide Rows first, then clear the relevant filter or expand the group if needed.

Will unhiding rows change formulas or data?
No. Unhide changes whether rows are displayed; it does not by itself change their cell contents or formulas. Other actions you take while investigating, such as editing cells or clearing a filter, can affect the workbook differently.

Can I unhide rows in Excel for the web or on Mac?
Yes. In both versions, select the relevant row headers and use the row-header context menu or the Home ribbon’s Format and Unhide Rows commands. Shortcut keys can differ, so the menu is a reliable fallback.

What if I cannot unhide a row because the sheet is protected?
Ask the workbook owner for permission or the password. If you are authorized, use Review > Unprotect Sheet and then unhide the rows. Protection is intended to restrict changes, so do not try to circumvent it.

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.