Excel Rows Keep Collapsing? Find and Fix the Cause

If Excel rows keep collapsing or disappearing, first check for an active filter, a collapsed outline group, or rows that have been hidden manually. In Excel for Microsoft 365 on Windows, clear filters with Data > Sort & Filter > Clear, expand outline groups with the plus button beside the row numbers, or select the affected rows and choose Home > Format > Hide & Unhide > Unhide Rows.

What “collapsing” can mean in Excel

Excel does not normally collapse ordinary rows on its own. The word can describe several different behaviors, and identifying which one you see is the quickest route to a fix. If the row numbers jump—for example, from 12 to 18—some rows are hidden from view. If a plus or minus button appears beside the row numbers, the rows are probably controlled by an outline group. If rows reappear after clearing a dropdown selection, a filter was hiding them rather than collapsing them.

These distinctions matter because the remedies are different. Unhiding rows will not remove a filter, and clearing a filter will not expand a grouped section. A row that is merely out of view has not necessarily been deleted: its cell contents and formulas can still be present in the worksheet.

Row numbers skip: check filters and manually hidden rows.
Plus and minus controls appear: expand or change an outline group.
Rows vanish after sorting or refreshing: inspect filter criteria and any process that reapplies them.

Expand a grouped or outlined section

Excel’s outline feature lets you group rows so detail can be hidden while a summary remains visible. It is common in reports with monthly, departmental, or transaction-level detail. When a group is collapsed, Excel displays a plus control next to the row numbers; clicking it expands the detail. A minus control collapses the group again. Outline level buttons, usually numbered 1, 2, and so on above the row numbers, show progressively more detail when selected.

To expand one section, click its plus control. To show all detail, click the highest outline-level number displayed. If the controls are missing, the sheet may have outline symbols turned off, or the rows may not be grouped. In Windows, open File > Options > Advanced, find Display options for this worksheet, and enable Show outline symbols if the setting is available for the selected sheet.

To remove a group rather than simply open it, select the grouped rows and choose Data > Outline > Ungroup. Use the Ungroup dropdown if you need to choose Rows or Columns. Ungrouping removes the outline structure; it is not the same as deleting the rows or their contents. If you only want the details visible temporarily, use the plus button instead.

Check whether a filter is hiding rows

A filter displays only records that meet selected criteria. It can make rows seem to collapse, especially when a table is long and the excluded records are scattered throughout it. Look for filter arrows in the header row. A funnel symbol or a changed dropdown icon can indicate that a filter is active. Open the relevant dropdown and choose Clear Filter From [column name], or use Data > Sort & Filter > Clear to clear filter criteria across the range.

Clearing a filter does not remove the filter arrows or convert a table to a normal range; it simply shows records hidden by the current criteria. If the data is an Excel table, use the header dropdowns to inspect each filtered column. More than one column can have a filter, so clearing just one may leave other rows hidden. Also check for a search term in a dropdown, since a search can limit the visible entries.

Filters are useful rather than destructive: a hidden record generally remains in the data and becomes visible again when the criteria are cleared. However, a workbook may reopen with a saved filter still active, and a refresh or a macro may apply filtering again. If the same rows disappear repeatedly, note which action happens immediately beforehand.

Unhide rows and restore their height

Rows can be hidden manually, or their height can be set to zero. Either condition makes the row numbers skip, and the same basic recovery works for both. Select the row headers on either side of the missing range, right-click, and choose Unhide. For example, if row numbers go from 8 to 12, select row headers 8 and 12, right-click, and choose Unhide. If you do not know how many rows are hidden, select the whole worksheet using the triangle at the top-left corner where the row and column headings meet, then choose Home > Format > Hide & Unhide > Unhide Rows.

You can also set a visible height directly. With the relevant row headers selected, choose Home > Format > Row Height and enter a positive value, or use Home > Format > AutoFit Row Height to fit displayed content. AutoFit is helpful when text wraps, but a manually chosen height can be preferable for a consistent report layout.

On Windows, Ctrl+Shift+9 unhides selected rows, while Ctrl+9 hides them. Keyboard shortcuts can vary with keyboard layout and Excel settings. On Mac, use the Home menu’s Format options if the shortcut is unavailable or conflicts with a system shortcut. In Excel for the web, use the row-header context menu or the Home ribbon; the desktop ribbon layout and some keyboard shortcuts may differ.

Why the rows collapse again

If rows return to a collapsed or hidden state after you fix them, look for something that is restoring the state rather than repeatedly unhiding the same range. A saved outline can reopen in its last saved state. A filter can remain active, or a table refresh can bring back filter criteria. A workbook macro may hide rows or collapse groups when the file opens, when a button is clicked, or when data changes. Do not assume a macro is responsible just because the behavior is repeated; first check the filter arrows, outline controls, and workbook instructions.

Try a controlled check: expand the group or clear the filter, save a copy of the workbook, close it, and reopen that copy. If the rows are hidden again, check whether the workbook opens with macros enabled and whether an automated refresh runs. If the rows stay visible until you use a particular button, refresh command, or data-entry action, that action is a useful clue. A workbook author or administrator may need to review its macro or refresh settings.

Worksheet protection can also prevent changes to row formatting. If Unhide is unavailable or Excel refuses to change row height, check Review > Unprotect Sheet. A password may be required. Protection is not itself proof that rows are hidden, and it should not be bypassed; ask the workbook owner for access if you do not have permission.

Distinguish hidden rows from deleted data

Skipped row numbers usually indicate hidden rows, not deleted ones. To check, use the Name Box to the left of the formula bar: enter a cell address in the suspected range, such as A10, and press Enter. If the selection moves to that cell even though its row is not visible, the row still exists in the sheet. You can then unhide it or inspect its contents in the formula bar. If the cell is blank, that does not establish that the row was deleted; it may simply have no value in that column.

Filters also leave records in place, though filtered-out cells can be easy to overlook when copying or summarizing visible data. If you need to copy only visible cells, check the selection carefully before pasting, since hidden and filtered rows affect what you see and how a selection behaves. Avoid deleting or recreating rows as a first response: doing so can disturb formulas, references, formatting, or table structure when the original issue was only visibility.

Prevent accidental hiding and make reports easier to use

When multiple people use a workbook, make the intended interaction obvious. Label grouped sections, keep summary rows near their detail, and explain whether readers should use the outline buttons or table filters. If rows should remain visible for routine work, avoid leaving a report saved with an unexpected filter or collapsed group. Before sharing, expand the relevant outline levels, clear unintended filters, and save the workbook in the state you want readers to see.

Use outline groups for optional detail, and keep totals outside the detail rows when practical.
Use table filters when readers need to find records by category, date, or other field.
After refreshing data, check that the expected records and filter criteria are visible.
If a sheet is protected, confirm that permitted users can format rows when that is part of the workflow.
Keep a backup before changing an unfamiliar workbook, especially one that contains macros or complex reports.

These practices reduce confusion, but they do not prevent every cause. A saved view, an updated workbook, or an automation step can change what is displayed. When the problem is recurring, record the exact action and the row numbers involved; that information is more useful than repeatedly applying Unhide without finding the trigger.

Frequently Asked Questions

Why do row numbers skip in Excel?
One or more rows are usually hidden, have zero height, or are excluded by a filter. Check for active filter criteria first, then select the surrounding row headers and choose Unhide. If outline buttons are visible, expand the group as well.

How do I expand all collapsed rows in Excel?
If the rows are grouped, click the highest outline-level number shown above the row numbers to display the most detail. To open one group, click its plus button. If there are no outline controls, the rows may be filtered or manually hidden instead.

Why does Excel hide rows again after I unhide them?
A filter, saved group state, refresh, or workbook macro may be restoring the hidden appearance. Check what action happens just before the rows disappear, and inspect filter dropdowns and outline controls. If the change occurs on opening or refreshing, ask the workbook owner to review any automation.

Can I unhide the first row when row 1 is missing?
Yes. Select the whole worksheet with the corner button above row 1 and left of column A, then choose Home > Format > Hide & Unhide > Unhide Rows. You can also enter A1 in the Name Box, select the row, and use the row-format menu.

Does clearing a filter delete the hidden records?
No. Clearing the filter criteria shows records that were excluded from view; it does not delete them. Check each filtered column if some records remain missing, because several filters can be active at once.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.