Excel Not Grouping Rows? Fix Outlines and Data Issues

Errors & fixes · Updated November 18, 2026

If Excel is not grouping rows, select the rows or cells you want to outline and choose Data > Outline > Group, then choose Rows if Excel asks. If Group is unavailable or the outline does not behave as expected, check whether the worksheet is protected, the selection is inside an Excel table, or you are trying to create an automatic outline from data that has no recognizable summary formulas.

What grouping rows does in Excel

Grouping creates an outline: a collapsible section of worksheet rows. Excel adds outline controls along the left edge of the row headings. Clicking a minus sign hides the grouped detail; clicking the plus sign shows it again. Number buttons at the top of the outline control how much detail is displayed. For example, a worksheet with monthly transactions can keep every transaction available while letting someone collapse a month and focus on its total.

Grouping is not the same as hiding rows one at a time. Hidden rows do not form a structured outline with levels, and they do not automatically appear as a collapsible section. Grouping also does not calculate totals. If you want a subtotal row, you must add a formula or use Excel’s Subtotal feature separately; the group controls only show and hide detail.

Excel has two related ways to make groups. Manual grouping lets you choose the exact rows. Auto Outline asks Excel to infer groups from the worksheet’s layout and formulas. Many apparent grouping failures happen because a person expects Auto Outline to work on a plain list, even though it needs a recognizable summary-and-detail structure.

Group rows manually in Excel for Microsoft 365

For a straightforward group, select the row numbers for the detail rows, then use the ribbon. Selecting row numbers helps ensure that the whole rows are included rather than only a few cells. You can also select cells in the rows you want; if Excel displays a Group dialog, confirm that Rows is selected.

  1. Click the first row number in the section you want to collapse.
  2. Hold Shift and click the last row number in that section to select the full range.
  3. Choose Data > Outline > Group.
  4. If a dialog asks what to group, select Rows and confirm.
  5. Use the minus control beside the selected rows to collapse the group, or the plus control to expand it.

For example, if rows 5 through 16 contain January transactions and row 17 contains the January total, select rows 5 through 16—not the total row—and group them. The total remains visible when the transaction detail is collapsed. If you select the total row as well, it will be hidden with the detail, which often makes the outline less useful.

You can make nested groups by grouping smaller sections first and then grouping a larger range that contains them. Use this for a hierarchy such as transactions within months and months within quarters. Keep summary rows outside the detail ranges when you want those summaries to remain visible as a group collapses.

Why the Group command may be unavailable

If Group is dimmed, first check the worksheet’s protection status. A protected sheet can restrict structural changes, including grouping, depending on how protection was configured. On the Review tab, look for Unprotect Sheet. If you have permission to edit the sheet, unprotect it, make the outline, and protect it again if needed. If a password is required, ask the workbook owner rather than trying to bypass the protection.

Next, check whether the selected rows are part of an Excel table. Table features such as filtering and structured references are useful, but outlines are not available for grouping rows inside a table in the same way as a normal worksheet range. If you need outline controls, you can convert the table to a range using Table Design > Tools > Convert to Range, where that command is available, and then group the rows. Converting removes the table’s automatic expansion and structured-table behavior, so consider whether those features matter before changing it. Another option is to place the outline groups outside the table.

Other reasons the command may be unavailable include selecting an unsuitable range, editing a cell, or working in a workbook state that restricts changes. Press Enter or Esc to finish cell editing, click a normal worksheet cell, and try again. If the workbook is shared or managed by an organization, its permissions or editing mode may also limit changes. Save a copy before making structural changes to an important workbook.

Manual grouping versus Auto Outline

Manual grouping is usually the better choice when you know exactly which rows belong together. It works with a simple list even if that list has no formulas, and it avoids relying on Excel to guess the intended hierarchy. Choose the rows, use Data > Outline > Group, and repeat for each section.

Auto Outline is useful when a worksheet already follows a consistent summary pattern. Excel looks for formulas that summarize detail rows or columns and uses their relationships to suggest an outline. To try it, choose Data > Outline > Group and select Auto Outline from the Group menu. The exact result depends on the worksheet’s arrangement and formulas; it is not a general command that groups rows based on labels such as month names or department names alone.

For example, a list that contains department names and individual expenses but no subtotal formulas may not produce the outline you expect with Auto Outline. Add clear subtotal rows or create groups manually instead. If Auto Outline creates levels that do not fit your layout, use Data > Outline > Ungroup to remove the unwanted outline and group the intended rows manually.

Check the row selection and summary layout

A group can be created successfully but still appear wrong because the selected range included a heading or excluded detail rows. Before grouping, identify the start and end of the detail section and decide whether its summary row should stay visible. It often helps to keep one blank or clearly labeled summary row between sections, but blank rows are not a requirement for manual grouping.

If the outline appears on the right side of the worksheet, or the summary controls are on the opposite side from what you expect, check the outline settings. Excel has settings for whether summary rows appear below detail and whether summary columns appear to the right. Use the small dialog-box launcher in the Data tab’s Outline group to open the outline settings, then review the summary placement options. These settings change where Excel places outline controls; they do not change which rows are grouped.

Also check whether the rows are actually hidden. A group may be collapsed already, or the row height may have been set to zero independently. Select the surrounding rows and use Home > Format > Hide & Unhide > Unhide Rows if ordinary hidden rows are the problem. If outline symbols are missing, see the next section rather than assuming the grouping did not happen.

When the plus and minus controls are missing

Excel can retain an outline while hiding its outline symbols. To restore them, open File > Options > Advanced. Under Display options for this worksheet, select the worksheet if necessary and enable Show outline symbols if an outline is applied. The wording and placement can vary slightly between Office builds, but the setting is in the advanced display options for the worksheet.

Check the worksheet edge too. Outline controls sit next to the row numbers, so a narrow or obscured row-heading area can make them easy to miss. If the group is collapsed, use the plus sign at the left of the hidden range; if it is expanded, use the minus sign. The numbered outline buttons above the row headings show different levels, so clicking a lower level can hide detail across multiple groups at once.

If the controls remain absent after enabling the setting, verify that the rows have a group at all. Choose Data > Outline > Ungroup carefully: the menu includes options that can remove groups. You can also select the suspected range and inspect the Group and Ungroup commands. Avoid using Clear Outline until you are sure you want to remove every outline level from the worksheet.

Filters, sorting, and other common misunderstandings

Filters and groups solve different problems. A filter temporarily displays records that meet criteria, such as transactions for one month. A group collapses a fixed range of rows regardless of their cell values. You can use both on a worksheet, but filtering can change which records are visible and can make it harder to tell what a manual group contains. If results look confusing, clear the filter and inspect the row numbers before changing the outline.

Sorting is another source of trouble. A manually created group is based on row positions, not on the meaning of values in a category column. If you sort the data after making groups, rows may move and the groups may no longer represent the intended categories. Sort the records into the intended order first, then group them. If the data changes frequently, consider whether a filter, PivotTable, or a separate summary view will be easier to maintain than manually updated outlines.

Grouping also does not freeze rows, protect data, or create a permanent report. It only changes which rows are displayed. A collapsed group’s values remain in the worksheet and can still affect formulas, depending on the formula used. For instance, SUM includes values in hidden rows, while some functions have options that can exclude filtered or manually hidden rows. Do not assume that collapsing a group removes its figures from calculations.

Remove or repair a group without losing worksheet data

Ungrouping removes the outline structure, not the cell contents. To remove one level, select the grouped rows and choose Data > Outline > Ungroup, then choose Rows if prompted. To remove all outline groups from a sheet, choose Data > Outline > Ungroup > Clear Outline. Clear Outline is broader: it removes the worksheet’s outline structure, so use it only when you want to discard all groups.

If a group is nested, removing one level may leave another level intact. Expand the worksheet and inspect the outline-level buttons before clearing anything. If a group was created over the wrong range, ungroup that range and create a new group using the correct row numbers. The data itself is not deleted by Group or Ungroup, but a backup is sensible if you are unsure how the current outline is organized.

Frequently Asked Questions

Why is Group greyed out in Excel?
Common causes include worksheet protection, selecting rows inside an Excel table, or being in the middle of editing a cell. Check Review > Unprotect Sheet if you are authorized, finish cell editing, and try selecting ordinary worksheet rows outside a table.

Can I group rows that contain blank cells?
Yes. Blank cells do not prevent manual grouping. Select the intended row range and choose Data > Outline > Group. Blank rows may affect how Auto Outline interprets a layout, but manual grouping does not require continuous values in every column.

Why does Auto Outline do nothing?
Auto Outline looks for a recognizable summary structure, especially formulas that summarize detail. A plain list with category labels but no subtotal formulas may not be enough. Add a suitable summary structure or create the groups manually.

How do I show hidden grouped rows again?
Click the plus sign beside the collapsed group, or click a higher outline-level number to show more detail. If the plus and minus controls are missing, enable Show outline symbols in File > Options > Advanced for that worksheet.

Does grouping rows delete them or change totals?
No. Grouping hides and shows rows; it does not delete their contents or automatically rewrite formulas. A regular SUM can still include values in collapsed rows, so check the formula if you need a calculation that excludes hidden data.

Choosing the right fix

Start with the simplest diagnosis: select the exact detail rows, confirm the sheet is editable, and use Data > Outline > Group. If that command is unavailable, check for protection and table membership. If the group exists but is invisible, restore outline symbols or expand the correct level. If Excel’s automatic outline does not match your expectations, use manual groups or improve the summary structure rather than repeatedly rerunning Auto Outline.

For occasional reports, manual grouping is direct and predictable. For frequently changing records, filters or a PivotTable may be a better way to explore categories without relying on fixed row positions. Choosing the feature that matches the task prevents a recurring problem: an outline that technically works but becomes misleading after the data is rearranged.

Related

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.