How to Unhide Rows in Excel All at Once on Windows

How-to basics · Updated November 18, 2026

To unhide every hidden row on an Excel worksheet at once, click the Select All button at the top-left corner of the grid, then choose Home > Format > Hide & Unhide > Unhide Rows. This reveals rows hidden manually, including rows above or below the visible area. If rows are missing because of a filter, an outline, or zero row height, use the matching fix below instead.

What You’ll Need

  • A workbook open in Excel for Microsoft 365 on Windows, with the worksheet you want to fix active.
  • Permission to make changes to the sheet. If it is protected, you may need the password or help from the workbook owner.
  • A moment to check whether the missing rows are hidden manually or removed from view by a filter or grouped outline. Those situations require different actions.

Step-by-Step

  1. Open the correct worksheet. Select the sheet tab at the bottom of the Excel window. If you want to unhide rows in several worksheets, handle each sheet separately; the steps below affect the active worksheet. If the workbook has multiple similarly named tabs, confirm the tab before making changes.
  2. Select the entire worksheet. Click the small Select All button at the intersection of the row numbers and column letters, in the top-left corner of the grid. The whole sheet should appear selected. This is more reliable than clicking a visible row number because it includes hidden rows at the top, bottom, or between visible rows. If you prefer the keyboard, press Ctrl+A when the active cell is outside a formatted table; inside a table, Ctrl+A may select the table first, so check that the entire worksheet is selected before continuing.
  3. Open the row-unhide command. On the ribbon, choose Home > Format > Hide & Unhide > Unhide Rows. Format is in the Cells group on the Home tab. Excel should restore the hidden rows on the active worksheet. The command is available even if you cannot see the hidden row numbers, provided the worksheet is selected and is not protected against formatting changes.
  4. Check the row headings. Look down the row-number column for a continuous sequence. For example, if the visible numbers previously jumped from 8 to 14, rows 9 through 13 should now appear. Scroll through the sheet, including the area around the first and last used rows, to confirm that the content you expected is visible. You can also use the Name Box to go to a known cell in a restored row.
  5. Use the context menu if you prefer. With the worksheet selected, right-click a row number in the row-heading area and choose Unhide. Avoid right-clicking a cell in the grid if Unhide is not shown there. If you only need to restore a few adjacent rows, select the row numbers on both sides of the hidden range, right-click the selection, and choose Unhide. For instance, to reveal rows 9–13, select row headings 8 and 14, then use Unhide.
  6. Try the keyboard shortcut for a selected range. Select the row headings that border the hidden rows, then press Ctrl+Shift+9 on Windows. On a Mac, the equivalent is Command+Shift+9. Keyboard layouts and system shortcuts can affect whether the combination works, so use the ribbon command if it does nothing. For a whole-sheet reveal, the Select All button followed by the ribbon command is the clearest method.

Excel’s Unhide Rows command restores rows that have been hidden using Excel’s hide-row feature. It does not turn off filters, expand collapsed outline groups, or correct rows whose height is set to zero. If a row still seems absent after the command, use Troubleshooting to identify what is controlling its visibility.

Common Mistakes

  • Selecting only visible rows. Clicking and dragging across row numbers can miss hidden rows or select only a portion of the sheet. The Select All button avoids this problem when the goal is to reveal every manually hidden row on the active worksheet.
  • Expecting Unhide to clear a filter. A filtered-out record is not manually hidden. Unhide Rows will not bring filtered records back; clear or adjust the filter instead.
  • Using the command on the wrong sheet. Unhide Rows applies to the active worksheet, not automatically to every tab in the workbook. Check the sheet name, then repeat the procedure on other sheets as needed.
  • Assuming a collapsed group is an ordinary hidden range. Outline controls can hide rows by collapsing a group. The outline’s plus button or level controls are the right way to expand those rows.
  • Changing every row’s height unnecessarily. Setting a height for the entire sheet may reveal zero-height rows, but it can also overwrite carefully adjusted heights. Try Unhide Rows first, and change row height only when that is the actual cause.

Tips

  • Use the Select All button when the scope is the whole sheet. It works even when row 1 or the last visible row is hidden, and it avoids guessing where hidden ranges begin or end.
  • Work on one worksheet at a time. After unhide, inspect the active sheet before moving to another. This helps you catch a protected tab or a different visibility issue without making unnecessary changes elsewhere.
  • Keep filters in mind when checking results. If a filter is active, the row numbers may still skip after you unhide manually hidden rows. A filter indicator in a column heading is a clue that some records may be filtered out.
  • Save after confirming the result. If the workbook is shared or contains important formatting, save a copy first or use Save As before making broad changes. Unhiding does not delete data, but it can expose content that was intentionally kept out of view.
  • Use the ribbon path when shortcuts differ. The ribbon command is easier to locate across different keyboards and is also useful if a laptop key setting or another application intercepts the shortcut.

Troubleshooting

Unhide Rows is unavailable or does not change anything. First check whether the sheet is protected. On the Review tab, choose Unprotect Sheet if that command is available; Excel may ask for a password. If you do not know it, ask the workbook owner rather than trying to bypass protection. Once permitted, repeat the Select All and Unhide Rows steps.

Rows remain missing after you unhide. Look at the column headings for filter buttons or funnel icons. To remove active filters, choose Data > Sort & Filter > Clear, or open the relevant column’s filter menu and select the appropriate values. Clearing a filter changes which records are displayed; it does not remove the records from the sheet. If you want to keep filtering, adjust the selected values instead of clearing all criteria.

You see outline symbols or a plus sign beside the row numbers. The rows may belong to a collapsed group. Click the plus sign beside the group to expand it, or use the outline level buttons near the top-left of the sheet to show a broader level. If the group is expanded but some rows are still hidden manually, use Unhide Rows as a separate step.

Row numbers still jump, but no filter or outline is active. The rows may have a height of zero or an extremely small height. Select the whole sheet, then choose Home > Format > Row Height and enter a reasonable value. A value such as 15 is a common starting point, but choose a height that suits the workbook’s font and content. Be aware that applying one height to the whole sheet replaces custom row heights, so use this only when needed.

You cannot find the rows even though their numbers are visible. They may be outside the current scroll position, or the sheet may be zoomed in. Use the Name Box to jump to a cell address you expect to contain the data, and check the row heading there. Also verify that you opened the correct worksheet and that the content has not been deleted or moved.

You are using Excel for the web or Mac. In Excel for the web, select the worksheet and look for Unhide Rows under Home > Format; if the command is unavailable, check for filters, groups, or protection. Excel for Mac has the same general Home > Format > Hide & Unhide route, though ribbon labels can vary slightly by release. Use the Mac shortcut Command+Shift+9 when the relevant row range is selected.

Frequently Asked Questions

Can I unhide all rows in every worksheet at once?
There is no standard Unhide Rows command that automatically applies to every worksheet tab in a workbook. Select each worksheet and repeat the steps. If several sheets are grouped, be cautious: grouped sheets can share edits, and selecting all rows does not make hidden rows in every tab appear independently in one action.

Does selecting the whole sheet reveal the first row?
Yes. Click the Select All button, then choose Home > Format > Hide & Unhide > Unhide Rows. If row 1 remains inaccessible, use the Name Box to enter A1 and inspect the row height; a zero-height row may need a height adjustment.

Will unhiding rows change or delete my data?
No. Unhiding changes whether existing rows are displayed; it does not delete their cell contents. However, making rows visible may expose information that was intentionally hidden, so check the worksheet before sharing or printing it.

Why does Unhide Rows do nothing when data is filtered?
Filtering hides records from the current view without using the manual hidden-row setting. Clear the filter with Data > Sort & Filter > Clear, or change the filter criteria to include the missing records. The rows should then appear if they match the revised criteria.

Can I unhide rows in Excel for the web?
Yes, when the worksheet is editable. Select the sheet, then use the Unhide Rows option under Home > Format if it is available. If rows stay missing, check for filters, collapsed outlines, zero-height rows, or sheet protection.

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.