Grouped rows, hidden rows, rows too short to show their text and filtered rows all look collapsed in Excel, and each one opens a different way. Look at the row numbers and the column headers first: skipped numbers, outline symbols, cut-off text or a filter icon each point to a different fix.
Steps follow Microsoft’s pages for Excel for Microsoft 365 on Windows, with Mac and web notes.
What collapsed rows look like (and which fix each needs)
Before you change anything, look at the left edge of the sheet and at the column headers. One sheet can have more than one cause at the same time, so work through every row of this table that matches what you see.
| What you see | Likely cause | Where to fix it |
|---|---|---|
| Row numbers jump (for example 4, then 9) with a double line between them, and no buttons to the left | Hidden rows | Right-click the row headings, then Unhide |
| Text stops at the bottom edge of the cell, or a row is a thin sliver | Row height too small | AutoFit Row Height |
| Row numbers jump and a column header shows a filter icon instead of a plain arrow | A filter is applied | Data > Clear |
| Small plus or minus signs beside items in a PivotTable | Collapsed PivotTable items | Expand Entire Field |
| Plus or minus symbols in a margin to the left of the row numbers | Grouped (outlined) rows | The outline symbols, or Shift plus the mouse wheel |
The reason this matters: Unhide does nothing to a filtered row, and clearing a filter does nothing to a hidden one.
A hidden row is still in the sheet with its data and formulas; Excel just stops drawing it. Microsoft documents two ways to bring hidden rows back.
- Select the rows above and below the hidden ones by dragging across their row numbers. To reach every hidden row in the sheet, click the Select All button (the corner box where the row numbers and column letters meet).
- Right-click (or select and hold) the selected row numbers.
- Choose Unhide. The missing row numbers return to the sequence.
The ribbon route does the same job: on the Home tab, in the Cells group, select Format, then under Visibility select Hide & Unhide > Unhide Rows. For a single block of hidden rows, Microsoft also notes that you can double-click the double line between the row numbers where the rows are hidden. Microsoft’s hide or show rows or columns page covers both, and the same steps work on columns. If it is columns you need back, see unhiding columns in Excel; to put rows away again on purpose, hiding rows and columns walks through the reverse.
A note on Ctrl + A: Microsoft says the first press selects the current region when the sheet has data, a second press adds its summary rows, and a third press selects the entire worksheet. If you press it once inside a block of data and Unhide seems to skip some rows, press it again or use the Select All button instead.
Rows too short to read: fit the height to the text
A row with a very small height looks hidden, and a row with a normal height can still cut off a long entry. AutoFit sets each row to the height its contents need.
- Select the rows you want to fix, or click Select All for the whole sheet.
- Go to Home > Cells > Format.
- Under Cell Size, select AutoFit Row Height.
A faster version from Microsoft’s row height page: click Select All, then double-click the boundary below any row heading. To set an exact number instead, use Home > Cells > Format > Row Height, type a value in the Row height box and select OK. Microsoft gives the default row height as 15.00 points and the allowed range as 0 (hidden) to 409 points, so a row set to 0 behaves exactly like a hidden row.
If a long entry still runs along a single line, turn on Wrap Text for those cells (Home tab, Alignment group), then run AutoFit Row Height again, as Microsoft’s wrap text page describes. For more ways to give an entry room, see making a cell longer in Excel.
Bring back rows a filter is holding back
A filter hides every row that does not match its condition. Unlike hidden rows, these come back the moment the filter is cleared, and you do not need to select anything first. Look for the Applied filter icon in a column header: it replaces the plain drop-down arrow on any column that has a filter set.
- Clear every filter on the sheet: select the Data tab, then Clear. The drop-down arrows stay in the headers, but every row shows.
- Clear one column: select the filter button on that column’s header, then Clear Filter from “Column Name”.
- Remove filtering completely: on the Data tab, select Filter, or press Alt+D+F+F, as listed on Microsoft’s clear or remove a filter page.
Clearing a filter does not change or delete any data. If the same filter is needed later, you can set it again from the column’s drop-down arrow.
Expand every item in a PivotTable field
PivotTables have their own collapse and expand controls, separate from worksheet rows. To open every item in a field at once, Microsoft’s PivotTable expand and collapse page gives this route:
- Right-click any item in the field you want to open, such as a region or a month label.
- Select Expand/Collapse.
- Select Expand Entire Field to show the details for all items in that field.
The same menu offers Expand To “Field name” for opening down to a deeper level, and you can double-click a single item to open just that one. If the plus and minus buttons are missing, Microsoft says to go to the PivotTable Analyze tab and select +/- Buttons in the Show group (older versions name this tab Options or Analyze). For building a PivotTable from a list in the first place, see summarizing a transaction list with a PivotTable.
Open every grouped row at once
Grouped rows come from Excel’s outline feature: someone selected a block of rows and grouped them, or the Subtotal command built an outline automatically. Microsoft’s subtotals page describes the outline symbols next to the row numbers, where the plus and minus symbols display or hide the detail rows for each group.
- Look in the margin to the left of the row numbers. A plus symbol marks a closed group; a minus symbol marks an open one.
- Select a plus symbol to open that one group.
- To open every group, look for the small numbered outline level buttons above that margin and select the highest number. In most outlines, the highest level shows every detail row, and level 1 shows only the summary rows.

Two more routes come straight from Microsoft’s Excel keyboard shortcuts list. Hover the pointer over the collapsed items, hold Shift and scroll the mouse wheel down to expand grouped rows (Shift and scroll up collapses them). And if you can’t see any outline symbols at all, press Ctrl+8, which Microsoft lists as the shortcut to display or hide the outline symbols. Both are on the keyboard shortcuts in Excel page.
Some versions also offer a Show Detail command in the Outline group of the Data tab that opens the selected group. Microsoft’s own outline article no longer opens at its old address, so check the label on your own ribbon. Creating and removing groups is a separate job, covered in grouping rows in Excel.
Rows that stay closed after these steps
- Grouped and hidden at once. If row numbers still skip after every group is open, some rows inside a group were also hidden. Run the Unhide steps on that range.
- A group was removed while it was closed. Removing the outline can leave its detail rows hidden. Treat them as hidden rows and use Unhide.
- The row headings themselves are gone. If there are no row numbers to right-click, turn them back on first; see showing row numbers and column letters.
- The sheet is protected. When the Format and Unhide commands are not available, the sheet may be protected against row changes. Check the Review tab for a protection command, and ask the workbook’s owner if a password is required.
Once the rows are back, selecting a whole row or column by its header is also the fastest way to change its formatting in one go, as shown in switching the format for a whole column.
Excel on a Mac and in a browser: what Microsoft documents
Microsoft’s hide and show page lists Excel for Mac among the versions it applies to, so the right-click Unhide route is the one to try there. For row height on a Mac, Microsoft’s Mac row height page says to double-click the separator to fit the contents.
In Excel for the web, Microsoft’s tip is the same idea: double-click the boundary between row headers to fit the height. For PivotTables in a browser, the right-click menu offers Expand Entire Field, and the plus and minus buttons sit under the PivotTable tab, in the Show group, as +/- Buttons. Microsoft’s current pages don’t spell out outline or Unhide steps for the web version, so expect the menus to differ from the desktop app.
Collapsed Excel row questions
Why are there no plus or minus symbols even though the rows are grouped?
The outline symbols may be switched off; press Ctrl+8 to show them again.
If rows are still missing after every fix, check the protected-sheet note above or ask whoever shared the workbook.

Kermit Matthews runs Live2Tech from just outside Philadelphia. He is an IT specialist with over 20 years of experience, from a university help desk to small-business IT, IT management and his own consulting practice, and has written tech guides full time since 2020. Steps are checked against the current software on a real device or the maker’s official documentation. More about Kermit.