Excel Won’t Group Rows? Fix the Common Causes

Errors & fixes · Updated November 21, 2026

If Excel won’t group rows, select the consecutive rows you want to fold, then choose Data > Outline > Group and select Rows if Excel asks. If the command is unavailable or the outline controls do not appear, check whether the sheet is protected, the selection is unsuitable, or outline symbols are hidden.

What grouping rows does in Excel

Grouping creates an outline: a set of worksheet rows that can be collapsed to hide detail and expanded when you need to see it again. Excel adds level numbers and plus or minus controls beside the row headings. It does not delete, filter, or permanently hide the grouped data. This makes grouping useful for reports where readers may want to switch between a summary and its supporting detail.

For example, a monthly report might show a subtotal row after each department’s transactions. Grouping the transaction rows lets someone collapse each department to its subtotal, then expand one department to inspect individual entries. The rows must be next to one another in the worksheet for a single group. If the detail rows are scattered across the sheet, organize or sort the data first, or create separate groups for separate contiguous sections.

Grouping is different from filtering. A filter hides records that do not meet selected criteria; an outline lets you collapse a chosen block of rows regardless of the values in those rows. Grouping also differs from hiding rows manually: outline controls make it easier to reveal a block and can represent several levels of detail.

Group rows manually in Microsoft 365

For a straightforward outline, group the rows directly. On Windows, use the Data tab’s Outline group. If you select worksheet cells rather than whole row headings, Excel may ask whether you want to group rows or columns.

  1. Select the row numbers for the detail you want to collapse. Drag across the row headings, or select a cell range that covers the same rows. Choose one continuous block; do not include the summary row if you want it to remain visible when the group is collapsed.
  2. Choose Data > Outline > Group. If a dialog appears, choose Rows and confirm.
  3. Look to the left of the row headings for an outline bracket and a minus sign. Select the minus sign to collapse the detail. Select the plus sign to expand it again.
  4. Use the outline level buttons, usually numbered 1, 2, and so on, to show a broader or more detailed view of the sheet. The exact levels depend on how many nested groups exist.

Suppose rows 5 through 9 contain individual orders and row 10 contains their total. Select rows 5 through 9 and group them. Row 10 stays visible after collapsing, so the total still makes sense. If row 10 is also selected, it may disappear with the detail, defeating the purpose of keeping a summary visible.

To remove a group without deleting any data, select its rows and choose Data > Outline > Ungroup. To remove every outline level on the worksheet, use the Ungroup menu and choose Clear Outline. Clearing an outline removes the grouping structure, not the worksheet contents.

Manual grouping versus automatic outlines

Manual grouping is the most predictable choice when you know which rows belong together. It does not require formulas, subtotal calculations, or a specially arranged data list. You decide the exact row boundaries, which is helpful for presentation sheets, project plans, and reports with irregular sections.

Excel can also build outlines from structured data. One option is Data > Outline > Subtotal, which inserts subtotal rows at changes in a chosen field and creates outline levels around the detail. Before using it, sort the list by the field that defines each group. For instance, sort an order list by Department before asking Excel to insert a subtotal at each department change. Otherwise, repeated department names separated by other names can produce separate subtotal sections.

The Subtotal command is intended for a regular range of data, not an Excel table. If the command is unavailable because the data is formatted as a table, convert the table to a range or use manual grouping instead. Converting removes table-specific behavior such as automatic expansion and structured references, so consider whether those features matter before changing the data layout. Automatic outlines can also be based on formulas that refer to detail rows, but Excel needs a recognizable summary-and-detail structure; it cannot infer every custom reporting design.

Common reasons the Group command is unavailable

When Group is greyed out, start with the worksheet and selection rather than rebuilding the data. These checks address many of the common causes:

  • The worksheet is protected. Protection can prevent changes to the sheet’s structure. If you have permission, choose Review > Unprotect Sheet, then try grouping again. If a password is required, ask the workbook owner; do not try to bypass the protection.
  • The selection is not a simple block. Select consecutive row headings or cells in the rows you intend to group. A selection spanning unrelated areas, or selecting only a summary row by mistake, may not create the intended outline.
  • The data is in a table and you are using a table-dependent command. In particular, Subtotal does not work on an Excel table. For a manual outline, if Group is still unavailable, try converting the table to a range using Table Design > Convert to Range, then check the command again. Preserve a copy first if the table’s filtering, formatting, or formulas are important.
  • You selected columns instead of rows. Excel may open a dialog offering Rows or Columns. Choose Rows. If it groups columns, undo the operation and repeat with the row headings selected.
  • You are editing in a different Excel environment. These steps describe Excel for Microsoft 365 on Windows. Excel for Mac has a similar Group command on the Data tab, though ribbon layout and dialogs can differ. Excel for the web has fewer worksheet-management capabilities in some cases; if a command is missing, open the workbook in the desktop app and try there.

Workbook structure protection and worksheet protection are not the same. Structure protection affects actions such as adding, deleting, hiding, or moving sheets; worksheet protection controls changes within a particular sheet. If grouping fails, check the sheet’s protection first, since grouping changes how rows on that sheet are organized.

When rows group but the controls are missing

Sometimes Excel has created the outline, but the plus and minus signs are not visible. On Windows, check File > Options > Advanced. Under Display options for this worksheet, select the correct worksheet and enable Show outline symbols if an outline is applied. The setting applies to the selected worksheet, so changing it for one sheet may not fix another.

Also check the far-left edge of the grid. Outline symbols sit beside row numbers and can be easy to miss if the row heading area is narrow or the sheet is scrolled horizontally. If there are level buttons such as 1 and 2, select a level to change how much detail is displayed. If no outline bracket or level buttons appear after grouping, undo and create the group again with a clear, continuous selection.

Hidden rows can make the result confusing. Expand the outline, inspect the row numbers, and confirm that the intended detail rows are still present. A collapsed group should hide its members temporarily, not remove them. If the worksheet is shared or protected, another user’s changes or permissions may also affect what you can expand or edit.

Build useful groups and nested levels

Groups can be nested when a report has more than one layer of detail. For example, an annual report could have transactions grouped within each month, then months grouped within each quarter. Create the smaller groups first, then group the larger blocks that contain them. Excel displays separate outline levels so a reader can choose a broad summary or expand to a more detailed view.

Keep summary rows outside the detail group when they need to remain visible after collapse. A useful layout is detail rows followed by a subtotal row, repeated consistently. If the summary row appears above the detail instead, Excel’s outline settings can affect where summary rows are expected. Review the worksheet’s outline arrangement before creating many groups, and test a small section first.

Use a clear pattern rather than grouping every possible block. Excessively nested outlines can make a worksheet harder to navigate, especially when several levels have similar-looking totals. Add labels such as Department total or Quarter total, and check the sheet at each outline level before sharing it. Grouping is a view and organization tool; it does not validate that a subtotal includes the correct records.

Alternatives when grouping is not the right tool

If the goal is to show only records matching a condition, use a filter rather than an outline. For a formatted Excel table, use the filter arrows in its header row. A filter is better for questions such as showing only one department or dates in a selected period. Grouping is better when the same fixed sections should be collapsible regardless of their contents.

If you want to summarize values by categories, a PivotTable may be more appropriate than inserting manual groups and subtotals. A PivotTable can organize fields into rows, calculate summaries, and let users expand or collapse categories. It is especially useful when the underlying records change often. By contrast, a manually grouped report may be simpler when its layout is fixed and readers need to see the original worksheet rows.

For temporary concealment of one or two rows, use Home > Format > Hide & Unhide > Hide Rows, then use the corresponding Unhide Rows command to show them again. Hidden rows do not provide outline levels or a visible group bracket, so they are less convenient for a report that readers need to expand repeatedly.

Frequently Asked Questions

Why is Group greyed out in Excel?
Check whether the worksheet is protected, whether you selected a continuous block of rows, and whether you are trying to use Subtotal on an Excel table. If those checks do not explain it, try the same operation in the desktop version of Excel and confirm that you are on the intended worksheet.

How do I group rows without hiding the subtotal?
Select only the detail rows and leave the subtotal row outside the selection. When you collapse the group, the subtotal remains visible. Expand the group if you need to check which detail rows contribute to it.

How do I ungroup rows without deleting them?
Select the grouped rows and choose Data > Outline > Ungroup. This removes the outline grouping, not the cell contents. Choose Clear Outline if you intend to remove all outline levels from the worksheet.

Why can’t I see the plus and minus buttons?
The outline symbols may be turned off for that worksheet. In Excel for Microsoft 365 on Windows, go to File > Options > Advanced, find Display options for this worksheet, and enable Show outline symbols if an outline is applied.

Can Excel automatically group rows by a repeated label?
Excel’s Subtotal feature can insert subtotal rows and outline sections when a sorted list changes value in a selected field. Sort the data by that field first. Subtotal does not work directly on an Excel table; use a regular range or consider a PivotTable for a changing dataset.

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.