Excel Rows Keep Hiding? How to Find and Unhide Them

Excel rows that seem to keep hiding are usually filtered, grouped, set to zero height, or hidden manually. First, select the affected row numbers—or click the Select All triangle at the worksheet’s top-left—and choose Home > Format > Hide & Unhide > Unhide Rows; if the rows remain missing, check the filter, outline, and row-height settings below.

Why Excel rows seem to disappear

Excel has several ways to make worksheet rows invisible, and they do not all behave the same way. A row hidden manually stays hidden until someone unhides it. A filter hides records that do not match the current criteria, while a collapsed outline hides a grouped section. A row can also have a height of zero, which makes it look hidden even if its hidden property is not the cause.

Start by looking at the row labels along the left edge. If the numbers jump—for example, from 12 to 18—rows 13 through 17 are not currently displayed. A double line between row labels often marks manually hidden rows, though the exact appearance can vary with the worksheet and display. If the row numbers are consecutive but the expected records are missing, a filter or a different sheet view may be responsible.

Excel does not ordinarily hide rows just because their cells contain formulas, blanks, or errors. A filter, an outline, a macro, or a user action can change what is visible. Conditional formatting can change a cell’s appearance, but it does not hide its entire row by itself.

Check whether the rows are manually hidden

To unhide a known range in Excel for Microsoft 365 on Windows, select the row headers immediately above and below the missing section. For example, if rows 13 through 17 are missing, select row headers 12 and 18, right-click the selection, and choose Unhide. You can also use the ribbon command: Home > Format > Hide & Unhide > Unhide Rows.

If you do not know how many rows are hidden, select the whole worksheet by clicking the small triangle above row 1 and to the left of column A, then choose Home > Format > Hide & Unhide > Unhide Rows. This applies the command across the sheet. It will not clear a filter, expand a collapsed group, or repair a zero-height row, so check those causes if nothing changes.

Windows shortcut: Ctrl+Shift+9 unhides selected rows. Select the bordering rows first, or select the whole sheet if the hidden range is unknown.
Mac: Keyboard shortcuts can differ with the keyboard layout and macOS settings. Use the ribbon command or the row-header context menu if the shortcut does not work.
Excel for the web: Select the relevant row headers, right-click, and choose Unhide, or use the available Home formatting commands. The browser interface may differ slightly from desktop Excel.

To see whether a row is hidden rather than filtered, select its neighboring row headers and use Unhide. If the row returns, it was hidden manually or had a visibility setting that the command corrected. If it does not, move on to filters, groups, and height.

Look for a filter hiding records

Filters are a common reason rows appear and disappear repeatedly. A filter shows only records matching selected values or conditions; the other rows remain in the worksheet but are temporarily not displayed. This is useful for analyzing a list, but it can make data look missing when a filter is left in place.

Look for filter arrows in the header row. A funnel or other changed filter indicator can signal that a column has an active condition. Open the relevant dropdown and look for selected values or a command such as Clear Filter From [column name]. On Windows, you can clear filters on the active sheet with Data > Sort & Filter > Clear. Clearing a filter restores the excluded records to view; it does not delete them.

For example, a sales table may show only the East region because that value is selected in the Region filter. Rows for West and Central will return when the filter is cleared. If the data is an Excel table, its filter arrows are part of the table headers; clearing the filter preserves the table and its contents. If filters are toggled off or removed, that changes the filtering controls, not the underlying records.

When rows go missing again after you clear a filter, check whether someone reapplied a filter, whether a table or worksheet is being refreshed, or whether a macro is changing the view. If the workbook is shared, ask whether another user saved a filtered state. Filters can be saved with a workbook, so reopening it does not necessarily mean the sheet starts with every record visible.

Expand collapsed groups and outlines

Grouped rows use Excel’s outline feature. When a group is collapsed, Excel hides its detail rows and displays a plus sign beside the row numbers; clicking the plus expands the group. A minus sign generally indicates an expanded group that can be collapsed. Outline level buttons, often numbered 1, 2, and so on above the row labels, show broader or more detailed levels of the worksheet.

Click the plus sign beside the affected section or choose a higher outline level to reveal more detail. A summary row can remain visible while its grouped detail rows are concealed, which may look like unexplained gaps in a report. This is different from a filter: an outline is a deliberate way to fold and unfold sections, not a rule that selects records by cell values.

If the outline symbols are not visible, the worksheet may have its outline symbols turned off, or the group may not be obvious from the current view. You can inspect the Data tab’s Outline commands, but avoid choosing Ungroup or Clear Outline unless you intend to remove the grouping structure. Expanding a group is the safer first step when you only want to view its rows.

Fix rows with zero or unusual height

A row with a height of zero is effectively invisible, and a very small height can make its contents hard to notice. In this case, the Unhide Rows command may not solve the problem because the row’s height—not only its hidden status—is preventing it from appearing normally.

Select the affected row headers, or select the whole sheet if you cannot identify the range. Then choose Home > Format > Row Height, enter a positive value, and select OK. A height such as 15 points is a practical example, not a universal ideal; the best value depends on the font and content. You can also choose Home > Format > AutoFit Row Height to let Excel size selected rows to fit their contents.

For a visible row that seems blank, AutoFit may make its contents readable if wrapped text or other content needs more room. However, AutoFit is not a substitute for checking filters and hidden rows, and it may not produce the layout you want when cells are merged. If a particular row keeps returning to zero height, a macro, workbook process, or another user may be changing it again.

Check protection, hidden sheets, and the active view

Worksheet protection can prevent changes to row formatting, including unhiding rows, depending on the protection settings. On the Review tab, look for Unprotect Sheet. If the sheet is protected, you may need permission or the password set by its owner. Protection is not the same as encryption: it controls permitted edits, and it should not be treated as a way to secure confidential data.

Also make sure you are looking at the right worksheet. A hidden worksheet is different from hidden rows: its sheet tab is absent. If you have permission, right-click a visible sheet tab and choose Unhide to see whether another worksheet is concealed. In Excel for the web, sheet visibility options can be more limited depending on the workbook and your access.

Freeze Panes can make a worksheet’s top rows or left columns stay in place while you scroll, which can create the impression that the view has not moved as expected. It does not hide rows. Check the row numbers and scroll position before changing the freeze settings. Similarly, switching worksheets or workbook views can change what you see without removing data.

Use a reliable troubleshooting order

If the cause is unclear, work through the checks in order rather than repeatedly selecting Unhide. This helps distinguish a visibility setting from a filter or a layout issue and reduces the chance of changing a carefully arranged report.

Check the row numbers. A jump in numbering means rows are not displayed; consecutive numbering suggests you may be on a different sheet, scrolled elsewhere, or viewing records removed by a filter.
Select the whole sheet and use Home > Format > Hide & Unhide > Unhide Rows. If the rows return, the cause was manual hiding.
Clear active filters using the header dropdowns or Data > Sort & Filter > Clear. Confirm that the data records return.
Expand any collapsed outline using its plus sign or an outline level button.
Set a positive row height or use AutoFit Row Height if the row still cannot be seen.
Check worksheet protection and confirm that the correct worksheet tab is active.

For a workbook used by other people, note which step fixes the issue before changing additional settings. That makes it easier to explain whether the problem was a filter, an outline, or row formatting. If the rows re-hide immediately, look for a repeated action such as a saved filter, a refresh, a macro, or edits from another workbook user instead of assuming Excel is hiding them spontaneously.

Frequently Asked Questions

Why do my Excel row numbers skip?
Skipped row numbers mean one or more rows between the displayed numbers are not currently visible. They may be manually hidden, filtered out, or concealed inside a collapsed outline. Try Unhide Rows, clear filters, and expand any grouped section.

Why does Unhide Rows not work?
The rows may be excluded by a filter, hidden within a collapsed group, or set to zero height. The worksheet may also be protected. Check those conditions after selecting the affected row headers; each has a different fix.

How do I unhide every row in a worksheet?
Click the Select All triangle at the top-left of the grid, then choose Home > Format > Hide & Unhide > Unhide Rows. This reveals manually hidden rows, but it does not clear filters or expand outline groups.

Can a filter hide rows without deleting them?
Yes. A filter temporarily displays only records that match its criteria. Clear the filter to show the other records again; clearing it does not delete those records.

Why do rows hide again after I reopen the file?
A filter or collapsed group may have been saved in that state, or a macro or workbook refresh may restore it. Check which visibility setting is active and, in a shared workbook, ask whether another person or process is applying it.

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.