To unhide every hidden row on one Excel worksheet in one go, click the Select All corner at the top-left of the grid, then choose Home > Format > Hide & Unhide > Unhide Rows. This applies to the active worksheet, not automatically to every sheet in the workbook. You do not need to know which rows are hidden or select them individually.
The steps below are for Excel for Microsoft 365 on Windows. The same general approach works on Mac and Excel for the web, though ribbon labels or shortcut behavior can vary slightly. If rows are hidden by a filter, grouping, or protection rather than by the Hide command, use the relevant fix in Troubleshooting instead.
What You’ll Need
- An Excel workbook open in the desktop app or Excel for the web.
- Permission to change the worksheet. If the sheet is protected, you may need its password or permission from the workbook owner.
- A moment to check that the rows should be visible. Unhiding changes how the sheet displays; it does not delete or alter the data in those rows.
Step-by-Step
- Open the worksheet you want to fix. Select its sheet tab at the bottom of the Excel window. The unhide command works on the active sheet. If your workbook has multiple worksheets, make a note of which ones need attention; you will normally repeat the process on each one.
- Select the entire worksheet. Click the small Select All button at the intersection of the row numbers and column letters, in the upper-left corner of the grid. It looks like a small triangle or square depending on your Excel version and window size. The whole grid should become highlighted. This is more dependable than dragging across row numbers because it includes hidden rows and rows far below or to the right of the visible data.
- Open the row visibility command. On Windows, go to Home on the ribbon, choose Format in the Cells group, point to Hide & Unhide, and choose Unhide Rows. The exact path is Home > Format > Hide & Unhide > Unhide Rows. Excel restores hidden rows within the selection, so selecting the whole sheet first is what makes this a one-go action.
- Check the row-number sequence. Look down the row headers along the left side of the worksheet. If the sequence now runs normally, such as 12, 13, 14, 15, the hidden rows are visible again. Before unhiding, a jump such as 12, 15 could indicate that rows 13 and 14 were hidden. Scroll to the areas where you noticed gaps to confirm the result.
- Use the row-header menu if you prefer. With the entire worksheet still selected, right-click any row number and choose Unhide. On a Mac, use a two-finger click or Control-click if you do not have a right mouse button. The ribbon route is often easier to find, but the context-menu command is a useful alternative when the ribbon is collapsed.
- Try the keyboard shortcut on Windows if needed. After selecting the whole sheet, press Ctrl+Shift+9 to unhide rows in the selection. On some keyboard layouts, the shortcut is described as Ctrl+Shift+( because the parenthesis is on the same key as 9. If the shortcut is intercepted by your keyboard, operating system, or Excel setup, use the ribbon command instead. On Mac, use the menu route if you are unsure which shortcut your keyboard layout supports.
- Repeat on other worksheets separately. Select the next sheet tab and repeat the selection and Unhide Rows command. The normal procedure affects one active worksheet at a time. Do not assume that fixing the first sheet changes every sheet in the workbook; check each tab where hidden rows may exist.
After unhiding, save the workbook if you want to keep the updated display when it is reopened. The operation changes row visibility, not cell values, formulas, or formatting elsewhere in the sheet. If the command seems to do nothing, first check whether a filter or outline is controlling which rows appear.
Common Mistakes
- Selecting only the visible rows. Dragging through row headers can skip hidden rows, or stop before hidden rows outside the selected area. Click the Select All corner instead, then choose Unhide Rows.
- Using Unhide Columns by mistake. The two commands are close together under Hide & Unhide. Choose Unhide Rows to restore horizontal rows identified by numbers on the left, not columns identified by letters across the top.
- Expecting one worksheet command to fix the entire workbook. Excel has separate row visibility for each worksheet. Repeat the action on each applicable sheet.
- Confusing filtered-out rows with hidden rows. A filter temporarily excludes records from view. Unhide Rows does not clear that filter; use the filter controls or the Data tab instead.
- Assuming the data has been removed. Hidden rows still contain their original values and formulas. Unhiding them reveals the content; it does not restore deleted data because the content was not deleted.
- Using Ctrl+A without checking the selection. Depending on where the active cell is, Ctrl+A may select a data region or table rather than the whole worksheet. The Select All corner is the clearest choice for this task.
Tips
- Use the row numbers to spot gaps. A jump in the numbered row headers is a quick clue that rows are hidden. It can also help you confirm which area to inspect after the command runs.
- Keep the full-sheet selection for the command. Do not click into a cell between selecting the sheet and choosing Unhide Rows, because that can change what is selected. If you do, click the Select All corner again.
- Know the difference between hidden and very short rows. A row may look absent because its height was set extremely small, even if it was not hidden with the Hide command. If Unhide Rows has no effect, select the sheet and check Home > Format > Row Height. Enter a sensible positive height, such as 15, if appropriate for that worksheet. This sets a common height, so use it only if changing the row heights across the sheet is acceptable.
- Use the same method for a limited range when appropriate. If you only want to reveal rows in one section, select the row headers immediately above and below that section, then use Home > Format > Hide & Unhide > Unhide Rows. Selecting the whole sheet is simpler when the goal is to unhide everything on that worksheet.
- Check workbook structure before changing it. A sheet may intentionally hide rows containing helper calculations or archived information. If you are editing someone else’s workbook, ask before changing a carefully prepared layout.
Troubleshooting
Unhide Rows is unavailable or does not change anything. First confirm that the correct worksheet is active and that the Select All corner selected the grid. Then check whether the sheet is protected: look for an Unprotect Sheet option on the Review tab. If protection is enabled, you may need the password or help from the workbook owner. Do not try to bypass protection; ask for authorized access.
Rows are still missing and filter arrows are visible. The rows may be filtered out, not manually hidden. Open the filter drop-down for the relevant column and select Clear Filter, or go to Data > Sort & Filter > Clear to clear filters on the sheet. Clearing a filter changes which records are displayed, so check the filter criteria first if you need to preserve a particular view. In Excel for the web, use the filter controls in the column headers or the Data tab.
There are outline levels or plus and minus buttons beside the row numbers. Those controls indicate grouped rows. Click the plus sign beside the collapsed group to expand it, or use the outline level buttons above the row headers to show a broader level. The Unhide Rows command does not expand a collapsed outline group because grouping is a separate display feature.
The row numbers are consecutive, but an area still seems blank. Check whether the rows have an unusually small height. Select the affected row headers and use Home > Format > Row Height to assign a visible height. If you are not sure which rows are affected, selecting the whole sheet and setting a height can reveal them, but it also changes the height of every row, including rows with custom formatting. Consider checking a small area first.
The command is missing or the interface looks different. In Excel for Mac, the Home ribbon contains a Format menu with row visibility options; if your ribbon layout differs, use the row-header context menu and choose Unhide. In Excel for the web, select the whole sheet and look under Home > Format for Hide & Unhide, or right-click a row number. If you are using an older Excel version, menu placement may differ, but the row-header context menu is a practical route.
Only some rows appear after you unhide them. Check for a combination of causes. A row can be hidden manually while other rows are filtered or grouped. Unhide Rows handles the first case; clear the filter and expand the outline for the others. Also check whether the worksheet has separate sections with small row heights.
Frequently Asked Questions
Can I unhide all rows in Excel with one click?
Yes, on one worksheet: click the Select All corner, then choose Home > Format > Hide & Unhide > Unhide Rows. It is two actions after selecting the sheet, but you do not need to identify or select each hidden row.
Does this unhide rows on every sheet in my workbook?
No. The command applies to the active worksheet. Select each other sheet and repeat the steps where needed.
Will unhiding rows change or delete my data?
No. It changes whether the rows are displayed. Values, formulas, and other cell contents remain in place.
Why does Unhide Rows not reveal rows hidden by a filter?
Filtering temporarily hides records according to criteria; it is different from manually hiding rows. Clear the relevant filter using its column drop-down or the Data tab to show those records again.
Can I unhide only a few rows instead of the whole sheet?
Yes. Select the row headers around the hidden section, including the visible rows immediately above and below it, then choose Unhide Rows. If you are unsure where hidden rows are, selecting the entire worksheet is more reliable.
What if the top row is hidden?
Click the Select All corner and use Unhide Rows. This includes the first row even though it can be difficult to select by dragging. If it remains missing, check for a filter, sheet protection, or a very small row height.
Related
- Clean Excel Data: Practical Steps, Tools, and Common Fixes
- Lower Excel Data Load: Speed Up Large Workbooks
- Lower Excel Calculation Time: How to Speed Up Workbooks
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Add Checkbox in Excel: Steps to Insert and Link OneTo add a checkbox in Excel for Microsoft 365 on Windows, select the cell or range where you…
- Flash Fill vs AutoFill in Excel: What’s Different?Flash Fill recognizes a pattern in example data and fills in similar text, while AutoFill copies cells or…
- Excel Find and Replace Entire Cell ContentsTo replace a cell only when its entire contents match, press Ctrl+H in Excel for Microsoft 365 on…
- Excel Insert Page Break Shortcut: Windows and MacIn Excel for Microsoft 365 on Windows, press Alt, P, B, I in sequence to insert a page…
- Google Docs Monthly Budget Template: Free Ways to StartYes, you can make a monthly budget for free with Google’s tools, but a budget with totals and…
- How to Indent and Double Space in WordTo indent and double-space text in Microsoft Word, select the paragraphs, open Home > Line and Paragraph Spacing…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.