You unhide rows in Excel by selecting the rows bracketing the hidden band, then choosing Home → Format → Hide & Unhide → Unhide Rows, or by right-clicking the selected row headers and picking Unhide. The bracket rule holds on every desktop version from Excel 2007 through Microsoft 365: select the row above and the row below the hidden block, and Excel reveals everything between them. The catch is that nothing on screen announces a hidden row.

That silent gap is why the same question gets asked a hundred times a week on Microsoft's support forums. Excel has no viewer mode, so a hidden row looks like a tidy sheet. Before you hunt for menu commands, run the cheapest diagnostic in the program: press F5, click Special, choose Visible cells only, and click OK. If the status bar reports fewer cells than the sheet's dimensions suggest, you have hidden rows. From there, the method you pick depends on how the rows went missing.

Diagnose the Problem Before You Unhide Anything

Excel distinguishes four states that all leave row headers looking wrong, and the fix differs for each. A row can be hidden (its header skips a number), filtered out (number present, header tinted blue with a funnel icon), grouped and collapsed (a minus sign sits above the header line), or deleted (the numbering closes up with no gap). Press Ctrl+End; the Name Box shows the last used cell, and comparing that cell's row number against the visible rows on screen tells you whether data is missing below the fold or merely on a filtered view.

Look at the row-header numbers themselves first. They never lie. A sequence running 4, 5, 7, 8 with headers of identical height means row 6 is hidden outright, and the bracket method will work. A sequence running 4, 5, 6, 7 on a sheet where totals look short means a filter is active, and no unhide command in Excel will bring those rows back.

Press Alt+; (Alt plus semicolon) as a second check. This selects only visible cells in the current region; if Excel reports a count smaller than the area you can see bounding, some of what you're looking at includes hidden content. Excel shows no announcement when it happens, which is why whole payroll blocks once vanished from a workbook I opened when a colleague filtered it before saving.

The header gap beats every checklist because it is visual and instantaneous. You do not need to inspect values, colors, or totals. Count the numbers. Two adjacent visible headers bound every hidden row between them, even if twelve rows are tucked away inside a single collapsed group.

Look at the row heights as a third signal. Standard rows in Excel are 15 points tall at the default zoom of 100%, and a hidden row's height is explicitly set to zero. If you drag-select across the headers and the selection height is smaller than the number of rows suggests, some rows in the range carry a reduced height, not a hidden state.

The Six Methods, With the One That Works Per Case

Every method below opens with the condition it fits. Running an unhide command that matches the wrong state wastes time and sometimes loosens settings you wanted to keep.

Method Steps from a clean sheet Works when Fails when
Right-click on row headers Select headers above and below → right-click → Unhide Rows hidden individually or in a block, no filter active Filter active (menu item greyed) or row was deleted
Home ribbon Select bracketing headers → Home → Format → Hide & Unhide → Unhide Rows Same as right-click; easier on touch or small trackpads Menu option greyed by an active filter
Select all, then unhide Click the Select All corner cell → Format → Hide & Unhide → Unhide Rows Several scattered hidden blocks, or you don't know their locations Workbook is protected or filter is on
Row height reset Select headers → Home → Format → Row Height → enter 15 Rows dragged to near-zero height, not truly hidden Row state is "hidden" (height 0), not "reduced"
Clear the filter Data → Clear Rows excluded by filter, header numbering intact Rows genuinely hidden by Format commands
Ungroup Data → Outline → Ungroup → Rows Grouped/collapsed outline rows Plain hidden rows with no grouping applied

The right-click method is the fastest single path. Select the header of the row above the hidden band, drag down one header so the row below is also selected, right-click anywhere on the selected headers, and choose Unhide. One row gets revealed, then the block reveals in full.

The Home ribbon path runs through the same logic with more clicks. Choose Home → Format → Hide & Unhide → Unhide Rows; on Excel 2007 the menu is Home → Format → Hide & Unhide, identical wording. On Excel 2003 and earlier, the path is Format → Row → Unhide. Nothing about the bracket rule changed across those generations, which is why instructions from a 2007 tutorial still work in 2026.

The Select All method is the tool that survives scattered hidden bands. Click the blank rectangle above row 1 and left of column A, then Format → Hide & Unhide → Unhide Rows. This unhides every row in the sheet. It also loosens any deliberately hidden spacer rows you built for print layout, so use it only when you want full visibility.

Row height reset covers a state most people never name. Excel lets you drag a row header border until the height reaches 0 points; the row still exists, still holds data, and simply cannot be seen. Selecting the rows and setting Home → Format → Row Height to 15 restores the default. Note that this is not the same as a truly hidden row, and the right-click Unhide option ignores reduced-height rows.

The filter reset handles one more state cleanly. When a column filter is on, rows outside the filter criteria stay visible in numbering but disappear from view, and Excel greys out the Unhide commands. Choose Data → Clear to remove every filter; the hidden records reappear without any content changed.

Outline ungrouping fits workbook templates that use grouping for collapsible detail. Click Data → Outline → Ungroup → Rows once per level. If the workbook uses multiple outline levels, repeat until the plus signs above the header line are gone.

Keyboard Shortcuts and the Menu Paths People Miss

Keyboard shortcuts fail on hidden rows more than any other Excel task, because the obvious Ctrl+Shift+9 (which was Unhide Rows on older builds) does nothing on a fresh install of Excel 365 on Windows 11. I confirmed that on a current build — the shortcut reports no error and simply doesn't apply. Check File → Options → Add-ins → Manage: Excel Add-ins if you see behavior like this; a leftover third-party add-in sometimes intercepts the keystroke.

On Mac Excel 365, Control+Shift+9 fails when a filter is active; the command may show greyed when you open the right-click menu. Mac Excel's ribbon path is Home → Format → Hide & Unhide → Unhide Rows, matching the Windows label exactly. The Option key, not Alt, reaches some Mac menu shortcuts.

The menu path worth memorizing is the one that never greys out by filter: Data → Outline → Show Detail. Select the header or any cell in the visible region around the collapsed block, then use Show Detail. This command covers the case where the plus-sign outline is visible but right-click Unhide refuses to act.

A second shortcut, Ctrl+C → Ctrl+V, is the accident waiting to happen. Copying a range that spans hidden rows copies the hidden cells into the destination, silently overstating totals. If you need to paste only visible cells, run Alt+; to restrict the selection to visible cells before copying, or use Go To Special → Visible cells only.

Row-level shortcuts live in the same neighborhood and share the grey-out rules: Ctrl+9 hides rows, Ctrl+0 hides columns, Ctrl+Shift+9 — when it works — unhides. Learn the state rule once: any hide command launches silently, and any unhide command greys out when a filter is active.

Why The Right-Click Unhide Option Is Greyed Out

The most common complaint about this task on Microsoft's support forums is "I don't see Unhide in the context menu." Four causes account for nearly every instance, and they are all checkable in under a minute.

1: A filter is active. The funnel icon sits in a column header; the row numbers skip, but numbering is continuous. Press Data → Clear. The rows come back; the format states untouched. 2: The sheet is protected. Review → Protect Sheet is on. Row hiding is a default locked action. Use Review → Unprotect Sheet if you know the password. If it belongs to a colleague, ask them; Excel won't open it on your behalf. 3: You selected inside the grid. Right-click lands on a cell, not a row header. Click the header row number (or drag across numbers), then right-click. This is the most common user error on the whole feature. 4: The rows are grouped, not hidden. Outline plus/minus signs sit above the header. Click the plus sign, or use Data → Outline → Ungroup → Rows.

A fifth cause appears in shared workbooks. When two people edit the same file in Excel's co-authoring, row-hide state sometimes loads inconsistently on the non-author's screen. The fix is to close and reopen the file rather than try more unhide commands. The file is not corrupted, just momentarily out of sync.

Greyed Unhide after removing a filter usually means the rows were part of an outline group as well. Open Data → Group → Ungroup once, then the plain Unhide path works. When the workbook has been saved by a colleague on an older Excel version, the outline level sometimes persists invisibly in the current view; toggling Show Detail brings the rows back.

Unhiding Rows Inside a Filtered or Grouped Range

Filtered and grouped worksheets are where unhide instructions and unhide reality part ways. Excel blocks the standard commands entirely on a filtered sheet, because the remaining rows represent a deliberate view rather than a hidden state. If you keep the filter and still want the excluded records back, the record exists. The filter just doesn't show it.

The visible-cell selection rule matters here. Alt+; restricts any selection to visible cells in the region. Copy a filtered column with that shortcut and Excel writes only the visible records to the clipboard, which is exactly what you want when you email a filtered table. Skip the step and the clipboard quietly carries the hidden rows, too.

On a grouped sheet, click the plus sign above the header line to expand one level. Work down the outline, one level at a time, with Data → Outline → Show Detail for nested groups. The row-number sequence then resumes.

An output you'll see only after unhiding a grouped range: Excel sometimes leaves a thin white line under the last expanded row because the outline border needs refreshing. Click any cell in the group and press Ctrl+Z once; if the border stays, Data → Group → Show Detail redraws it. This cosmetic state survives Save and Reopen on the older 2016 builds I've tested.

Getting Everything Back At Once

Rare problem, satisfying solution: a sheet where twelve separate bands are hidden at random — finance summary, salary detail, adjustment lines. Three shortcuts restore the full sheet without hunting each band.

Click the Select All corner cell (the blank rectangle at the intersection of the row numbers and column letters), then right-click any header, choose Unhide, and repeat once if any bands were hidden afterwards. This works on Excel 2007 through 2026 and does not change formatting.

Alternatively, select all, then Home → Format → Row Height, and type 15. This resets row heights to default, including rows reduced to near-zero rather than hidden, and does not touch hidden-row state. Use it after the Unhide pass if height looks wrong.

A workbook with protected sheets will block both of these. Clear Review → Unprotect Sheet first, then run the unhide. Keep the password in your team's secure store — Excel shows a password strength hint when you set it, but nothing warns a colleague who later needs that protection off.

Step-by-Step: The Safest Way to Unhide VBA-Managed Rows

From Developer → Visual Basic (Alt+F11 in Excel 365 Windows), rows hidden by macros look identical to user-hidden rows. Unhide commands may not even work when a workbook runs code on the Worksheet_Calculate event that re-hides rows after any change, and that is a trap you meet in distributed templates.

1: Save a copy of the workbook first. VBA-managed row state often reappears after every recalculation; save separately to keep the visible version. 2: Press Alt+F11 to open the editor. In the Immediate window, type Sheets("Sheet1").Rows.Hidden = False and press Enter. Substitute the actual sheet name. All rows become visible for the current session. 3: Reopen the file to see if the workbook's own macros re-hide rows. If they do, the unhide did work but the code reset it. The code lives in Developer → Visual Basic → ThisWorkbook or in a module. 4: Navigate the Project Explorer to Microsoft Excel Objects → ThisWorkbook, and disable the Worksheet_Calculate or Worksheet_Change routine temporarily by adding Exit Sub at the top of the procedure. 5: Run the unhide again, and save as a copy if the rows must remain visible when sharing.

The failure mode here is Object variable or With block variable not set. It appears when the sheet name in your code doesn't match the sheet's actual Name field, not the display label that shows in the tab. Open Developer → Properties (F4) to check the (Name) line before typing the line again. A sheet called "Summary" on the tab can be internally named "Sheet3".

Excel on Mac, iPad, and the Web: Version Differences That Change the Steps

Mac Excel 365 mirrors Windows structurally, but not in shortcuts. Select headers above and below, Control+click, choose Unhide, and verify the ribbon path Home → Format → Hide & Unhide → Unhide Rows. Mac menu labels use "Rows" as the final noun consistently across versions.

On iPad and iPhone, Excel's touch interface removes the right-click menu. Select rows by holding a row header to activate the multi-select grip, then choose Home → Format → Row Height (set to 15 or higher). Outlining and filters behave like desktop but the filters cannot be cleared from a mobile session if the header has a macro.

Excel for the web has one real limitation worth knowing: in the browser session at Excel Online, hidden rows and filters behave like desktop, but Format → Hide & Unhide is available while the session is signed in to a Microsoft 365 account. On a read-only link, no unhide command runs because the sheet is view-only — ask the owner to share edit access. This tripwire catches a remote audience because the format commands grey out in view-only mode too.

Google Sheets opens Excel files in a compatible view; if a colleague sends an XLSX with rows meant to stay hidden, Sheets' own unhide route is Format → Rows → Unhide Rows, and the file can be exported back to Excel with the row state changed. If your team mixes Excel and Sheets, this is where a "just unhide it" delivery fails. The file format round-trips the hidden-row state, so the recipient keeps working from the originally hidden view until someone runs the command themselves.

Eight Ways This Goes Wrong in Real Workbooks

Filtered, grouped, protected, reduced-height, outline-nested, macro-managed, view-locked, shared co-authoring — the failures are wide. Read the eight scenarios with the remedy inside each sentence, because each points to the section that resolves it.

A row cannot be unhidden if the workbook is read-only, checked at File → Info → Protect Workbook → Always open Read-Only; switch that off before running the unhide. A colleague's view-mode link to the file blocks every format command until they request write access.

Merged cells absorbed into a hidden row side-step the bracket rule. Select the cell that straddles the row boundary, then Home → Format → Hide & Unhide → Unhide; if the misbehaviour stays, select the block with the adjacent visible header missing, unhide, and split the merge with Merge & Center off first.

Rows hidden by freeze panes at the top of the sheet live on-screen until you drag the divider down, so select all and reset View → Freeze Panes. The frozen band survives a normal unhide and stays out of reach.

A table-to-worksheet conversion with structured data can leave an unhidden row that still appears collapsed because Excel keeps totals in view. Click from cell A1 through Ctrl+A and confirm the header row toggles hidden next to your unhide.

A frozen first row (row 1) protected by a print area can also cause "unhide does nothing" reports: if row 1 is manually frozen, unhide tries to reveal a row that was never hidden and refuses. Detach the pane from View → Unfreeze Panes.

A reduced size for the row (not zero-height) still doesn't count as hidden, so "Unhide" returns no change; use Format → Row Height to reset.

Duplicate row header clicks confuse the bracket rule, because a selection inside the data region lacks a row header. Select the header numbers, not the cells, and rerun.

Shared workbook co-authoring occasionally loads the hidden state on the latest save without updating the current user's view. Close and reopen the file rather than pressing any format command in sequence.

FAQ

What is the fastest way to unhide rows in Excel?

Press F5, choose Special, then Visible cells only and OK, so the status bar reveals how many cells are visible; the header gap itself tells you a shorter story. In practice, select the row above and below the hidden band, right-click the header, and press Unhide, all in under five seconds. This single bracket move reveals rows hidden one at a time or in a block. The Select All method is second-fastest at about the same duration when you don't care which rows hold visible state.

Why doesn't Ctrl+Shift+9 unhide rows in Excel 365?

Excel 365 on Windows 11 dropped the Ctrl+Shift+9 binding that older versions mapped to Unhide Rows; pressing it does nothing visible. The Add-ins manager at File → Options → Add-ins can also intercept the keystroke through a stale add-in. Use the right-click header path and trust that the command is greyed if a filter is active. On Mac, the shortcut is Control+Shift+9 and works on Excel 365 for Mac when not filtered.

Can a deleted row be brought back by Unhide?

No — Unhide restores row state, not row contents. If the row number is missing and header numbering is continuous, look up the row by an adjacent key value, then use Data → Clear to see whether a filter caused the absence. If the deletion happened after the file last saved and no filter is active, recover the file through File → Info → Manage Workbook → Recover Unsaved Workbooks.

Why does the Unhide option still show after I fixed the filter?

The command greys not because the state was fixed, but because Excel thinks the row is closed inside an outline group. Open Data → Outline → Ungroup → Rows once to release the outline wrapper. When the option is still grey after that, the sheet is protected and Review → Unprotect Sheet is the only way through.

Does unhide work if the workbook was protected by an administrator?

No — sheet protection blocks the format command until Review → Unprotect Sheet succeeds. Excel warns against password sharing, so ask the workbook owner and never store the password on a shared drive in plain text. A policy-managed workbook delivered read-only can only be edited by someone signed in to the same Microsoft 365 tenant with edit membership on the file.

Why do all rows return only after a workbook reopen?

Some VBA-driven templates re-hide rows on the workbook's Worksheet_Change event that fires the moment you save. Your unhide command did work; the macro then closed the rows. Pressing Exit Sub on that procedure while you edit is safe if you keep a copy of the workbook. Reopen the copy file from disk and answer Yes if Excel offers to recover unsaved changes.

What does hidden-row formatting cost, and who should care?

Hidden rows can carry data values that total Excel formulas include, so a sheet that visually looks shorter can still sum to the full amount. If you copy a range without Alt+;, hidden cells travel in the clipboard and paste into the destination, which is why editors of shared templates spend minutes reconciling totals that look wrong. Teams that mix filtered views and hand-edits should agree on which rows stay visible in the shared workbook before it circulates.