Unable to Unhide Rows in Excel? Try These Fixes

How-to basics · Updated November 18, 2026

If you are unable to unhide rows in Excel, first select the row headers immediately above and below the gap, then choose Home > Format > Hide & Unhide > Unhide Rows. If that does not work, the rows may be filtered, set to zero height, grouped, or protected; each cause needs a different fix.

Start with the row headers

Excel’s Unhide Rows command works when you select the rows on both sides of the hidden area. For example, if the row labels jump from 8 to 13, rows 9 through 12 may be hidden. Select row headers 8 and 13 together, right-click either selected header, and choose Unhide. You can also use the ribbon command: Home > Format > Hide & Unhide > Unhide Rows.

To select adjacent row headers, click the first header and drag through the second, or click one and Shift-click the other. For hidden rows at the top of a sheet, click the row 1 header and drag across the header area where the missing rows would be; alternatively, select the entire worksheet using the Select All button at the upper-left corner where the row and column headings meet, then run Unhide Rows. Selecting the whole sheet is a useful diagnostic, but it may also change formatting if you choose a different command by mistake.

On Windows, Ctrl+Shift+9 is the shortcut for unhiding rows. It may not work on every keyboard layout, and it will not reveal rows hidden by a filter. The ribbon or right-click method is easier to verify. On Mac, use the row-header context menu or the Home ribbon; keyboard shortcuts can differ by keyboard layout and Excel version.

Check whether a filter is hiding the records

A filtered-out row is not the same as a manually hidden row. When a filter is active, Excel displays only records that meet the selected conditions. The row numbers may skip, which can look exactly like hidden rows, but the Unhide command will not restore them. This often happens in tables when someone filters a Status column to show only Open items, or filters a date column to show one month.

Look for filter arrows in the column headings and for a filter icon on a column whose values are restricted. Open that column’s dropdown and choose Clear Filter From… followed by the column name, if available. To clear filters across the sheet, use Data > Sort & Filter > Clear. The exact group placement can vary with ribbon size. Clearing a filter shows matching records again; it does not delete the filter arrows or change the underlying data.

For a table, use the dropdown in the table header to clear the relevant filter. If you turn filtering off with Data > Filter, Excel removes the filter controls and ordinarily displays the full set of records. Before doing that in a shared workbook, note any filtering your colleagues rely on. If a filter is still active, clearing it is the right fix—not repeatedly trying Unhide Rows.

Restore rows with zero or very small height

A row can be technically present but appear missing because its height was set to zero or reduced until its contents are barely visible. In that case, Unhide may not produce the expected result. Select the row headers on either side of the affected area, or select the entire sheet, then choose Home > Format > Row Height. Enter a visible value, such as 15 points, and select OK. The appropriate height depends on the font and content; use AutoFit Row Height when you want Excel to size rows to their contents.

To use AutoFit, select the relevant row headers and choose Home > Format > AutoFit Row Height. You can also double-click the boundary between two row numbers after selecting the affected rows. If you are unsure which rows have unusual heights, selecting all rows and using AutoFit can make the sheet readable, but it may change carefully customized heights. For a formatted report, try the affected range first.

When row numbers jump, inspect both the visible boundary and the actual row-height setting. A narrow row may show as a thin line rather than disappearing entirely, while a zero-height row is usually not visible at all. If setting a positive height does not reveal the expected records, check filters and outline grouping as well; more than one hiding mechanism can be active at once.

Expand a collapsed group or outline

Excel’s outline feature lets users collapse sections of rows, commonly to hide detail beneath a summary. When a group is collapsed, look along the left margin near the row numbers for outline level buttons such as 1, 2, or 3, and for plus or minus symbols. Click a plus sign to expand that group, or select a higher outline level to show more detail. A minus sign beside a group indicates that its detail is currently expanded.

Groups are created from the Data tab’s Outline tools, so they can be easy to mistake for ordinary hidden rows. If the plus and minus controls are missing, the outline symbols may be turned off. In Excel for Microsoft 365 on Windows, open File > Options > Advanced and, under Display options for this worksheet, check Show outline symbols if an outline is applied. The setting applies to the selected worksheet. Once the controls appear, expand the relevant section rather than using Unhide.

For example, a budget worksheet may show a department total while hiding individual expense lines. Expanding the group reveals those detail rows without changing the data or removing the outline. If expanding the group does not reveal the expected range, inspect the filter state and row heights too.

Check worksheet protection and permissions

Protection can prevent changes to rows and columns. If Unhide is unavailable, disabled, or has no effect, open the Review tab and check whether the sheet is protected. If you are authorized and know the password, choose Review > Unprotect Sheet and enter it when prompted. Then select the affected row headers and use Unhide Rows or set a row height.

A protected worksheet can be configured to allow some actions but not others. The person who protected it may have allowed selecting cells while disallowing formatting rows, which can block unhiding or resizing. If you own the workbook, unprotect it with the proper password, make the change, and apply protection again with the intended permissions. If you do not know the password, ask the workbook owner or administrator; do not assume that a disabled command means the rows were deleted.

Worksheet protection is different from protecting the workbook structure. Workbook structure protection can restrict actions such as adding, deleting, moving, hiding, or unhiding sheets, but it does not by itself explain every restriction on row visibility inside a sheet. Check which object is protected and what action is blocked before changing settings.

Rule out deleted rows and other look-alikes

Not every missing sequence of row numbers is hidden. If row labels go from 8 to 9 and then to 14, rows 10 through 13 could be hidden, filtered, or deleted. If rows were deleted, there is nothing for Unhide to restore. If the deletion just happened, use Undo (Ctrl+Z on Windows; Command+Z on Mac). For an older change, check whether the workbook has a suitable saved version, such as through version history in OneDrive or SharePoint, or restore from your organization’s backup process.

Also make sure you are looking at the intended worksheet and area. A frozen pane can keep headings or columns in view while the worksheet scrolls, but freezing panes does not hide rows. Use the vertical scrollbar or the Name Box to move to a known cell, and check the worksheet tabs if the expected records may be on another sheet. If the row labels are continuous but the cells look blank, inspect the cells for white font, custom number formats, or formulas returning an empty string; those affect what you see but are not hidden rows.

A quick diagnosis is to note the row labels around the gap, check for filter arrows and outline controls, then try selecting the surrounding row headers and setting a positive height. If the command is disabled, check protection. This sequence separates the most common causes without altering the data.

Excel for the web and Mac differences

In Excel for Microsoft 365 on Windows, the ribbon path Home > Format > Hide & Unhide > Unhide Rows is the standard route. In Excel for the web, select the row headers around the gap, right-click, and choose Unhide; ribbon options can vary with the available window space. If the sheet is protected or the rows are filtered, the same underlying limitation applies in the browser.

In Excel for Mac, select the bordering row headers and use the context menu’s Unhide command, or look under the Home tab’s Format controls. Menu placement and keyboard shortcuts can vary between Mac releases, so the row-header menu is a reliable way to identify the action. Excel for the web and Mac may not show every Windows dialog or option in the same place, but filtering, grouping, row height, and protection remain the key things to check.

Prevent the problem from recurring

If you share a workbook, make the reason for hidden rows clear. Filters are usually preferable when readers need to focus temporarily on selected records, because they can be cleared without altering row formatting. Outline groups work well for repeatable summary-and-detail views. Manual hiding is useful for a small number of rows, but it can be confusing when a later user does not know that content is present.

  • Before sending a workbook, check for active filters and collapsed outline groups.
  • Use descriptive headings and avoid hiding rows that contain important instructions or totals.
  • If you protect a sheet, decide whether users should be allowed to format rows, and set permissions accordingly.
  • Keep a backup or use version history for important shared workbooks, especially before bulk formatting or deleting data.

These practices also help distinguish a deliberate view from missing information. A filter icon, outline control, or protected-sheet notice gives the next person a clue about how to restore the records.

Frequently Asked Questions

Why does Unhide Rows do nothing in Excel?
Most often, the rows are filtered rather than manually hidden, or they have zero height. Clear the relevant filter first, then select the bordering row headers and use Unhide. If that fails, set a positive row height and check for a collapsed outline or sheet protection.

How do I unhide every row in a worksheet?
Click the Select All button at the corner above row 1 and left of column A, then choose Home > Format > Hide & Unhide > Unhide Rows. This does not clear filters, expand outline groups, or change protected-sheet permissions, so those may need separate attention.

Can I unhide row 1 if it is hidden?
Yes. Select the entire worksheet with the Select All button, then choose Unhide Rows. You can also use the Name Box to select A1 and then use the row-header or ribbon options. If row 1 remains absent, check filters, protection, and whether the worksheet is displaying the expected area.

Why are row numbers skipping even after I unhide rows?
A filter or collapsed outline can still be hiding records, or the rows may have been deleted. Clear filters and expand any outline groups. If rows were deleted, use Undo or recover an earlier workbook version; Unhide cannot restore deleted data.

Does hiding a row delete its data?
No. Hiding changes whether the row is displayed, not the cell contents. Filtering also leaves the records in the worksheet. Deleting a row is different and removes its cells from the sheet, so use Undo or a recoverable version if a deletion was accidental.

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.