Excel Won’t Let Me Group Rows? Causes and Fixes

Errors & fixes · Updated November 21, 2026

If Excel will not let you group rows, first make sure you are on an unprotected worksheet with only one sheet selected, then select the rows by their row numbers and choose Data > Outline > Group. If the command is disabled, protection, grouped worksheet tabs, or the current selection are common causes; the checks below help identify which one applies.

What grouping rows does in Excel

Grouping creates an outline: rows remain in the worksheet, but you can collapse a section to hide its detail temporarily and expand it again later. The numbered outline levels and plus or minus controls beside the row numbers let you show more or less detail. Grouping does not delete data, change formulas, or permanently hide rows.

This is different from filtering, which displays records that meet chosen criteria, and from hiding rows manually, which does not create a reusable outline structure. For example, a monthly report might show a total for each department while grouping the individual employee rows beneath it. A reader can collapse the details to scan totals and expand them to inspect the underlying entries.

Group rows using the ribbon

In Excel for Microsoft 365 on Windows, use these steps to create a basic row group:

  1. Click the row number at the left edge of the first row you want in the group. Drag down the row numbers to select the remaining detail rows. Selecting row headers makes it clear that you intend to group rows, not columns.
  2. Open the Data tab. In the Outline group, choose Group. If Excel asks whether to group Rows or Columns, select Rows and confirm.
  3. Look to the left of the row numbers for the outline bracket and collapse control. Click the minus sign to collapse the selected detail rows, or the plus sign to show them again.

For example, if rows 5 through 10 contain January transactions and row 11 contains a total, select rows 5 through 10—not the total row—and group them. The total can remain visible while the detail is collapsed. If the summary row is above the detail instead, select the detail rows in the same way; you can adjust the outline settings if Excel places the summary relationship differently than you want.

On Windows, Alt+Shift+Right Arrow groups the selected rows or columns, and Alt+Shift+Left Arrow ungroups them. On a Mac, use the Data tab’s Group and Ungroup commands if those Windows shortcuts do not apply to your keyboard setup. Excel for the web has a more limited set of desktop features; if the outline controls are unavailable there, open the workbook in the desktop app.

Why the Group command may be unavailable

Check the workbook state before changing the data. These issues commonly make Group unavailable or prevent the outline controls from working as expected:

  • The worksheet is protected. Protection can restrict outline changes. If you have permission, go to Review > Unprotect Sheet and enter the password if requested. If the sheet must stay protected, its owner may need to set protection options that allow outline symbols before protecting it again.
  • Several worksheet tabs are selected. Excel can group sheets for certain editing tasks, but row outlining should be done on one worksheet at a time. If multiple tabs are highlighted or the workbook title shows [Group], right-click a selected sheet tab and choose Ungroup Sheets, then try again.
  • You are editing a cell. If the insertion point is inside a cell or the formula bar, finish or cancel the edit with Enter or Esc. Then select the row headers and try Group again.
  • You selected columns rather than rows. A selection of column letters is treated as a request to group columns. Select the numbered row headers for a row outline.
  • The workbook is in a state that limits editing. A read-only file, a restricted shared location, or permissions that do not allow edits can prevent changes. Confirm that you can make and save an ordinary edit before troubleshooting the outline itself.

If the sheet is password-protected and you do not know the password, do not try to bypass it. Ask the workbook owner for access or for an unprotected copy. Protection is a permission boundary, not a problem that grouping commands can safely override.

Tables, filters, and other data layouts

Excel tables are useful for sortable, filterable lists, but they are not the same thing as worksheet outlines. The Data > Subtotal command, for instance, is not available while the data is formatted as an Excel table. That limitation can lead people to assume that subtotals, filters, and row grouping are interchangeable; they are separate features with different purposes.

If you are working inside a table and the outline command is unavailable or does not produce the layout you need, save a copy and consider converting the table to a normal range. Click inside the table, open Table Design, and choose Convert to Range. This removes table behavior, such as automatic expansion and structured references, so check dependent formulas and workflows before converting. It is not necessary to convert every table just to try grouping; first test the command on a copy if the workbook is important.

Filters can also make rows appear to be missing. A filter hides records that do not match its criteria, while a group collapses a defined section of rows. Clear or inspect the filter if you cannot see the expected detail, and check for manually hidden rows as well. A filtered list may not look like a simple uninterrupted block even though its source rows are still present.

Summary rows, nested groups, and Auto Outline

A useful outline usually groups detail rows and leaves a total or heading outside that group. If you want summary rows above the detail rather than below it, select a cell in the worksheet, go to Data, and open the Outline dialog using the small dialog-box launcher in the Outline group. In Settings, adjust Summary rows below detail. This changes how Excel positions summary relationships; it does not move worksheet rows or create totals for you.

You can make nested groups when a report has more than one level of detail. For instance, group individual transactions within each month, then group the monthly sections within a quarter. Collapse the inner groups first to check that each one contains the intended rows; then create the larger group around those sections. The outline level buttons can display a broader summary level, while individual plus and minus controls let you open a particular section.

Excel’s Auto Outline can build groups when the worksheet contains a recognizable summary structure, such as formulas in summary rows that refer to detail rows. On the Data tab, open Group in the Outline group and choose Auto Outline. Results depend on the layout and formulas, so inspect the generated brackets and collapsed view. Auto Outline is not a substitute for adding missing totals, and it may not infer the hierarchy you intended from a flat list of records.

Fix a group that exists but will not collapse

Sometimes Group is no longer the problem: the outline exists, but its controls are missing or a section will not collapse. First check whether the worksheet is protected. Excel can protect a sheet while allowing users to work with outline symbols, but the protection settings must permit that use. The sheet owner may need to unprotect it, enable the relevant outline permission, and protect it again.

Next, look for the outline controls beside the row numbers. If the controls are hidden, check Excel’s display options for outline symbols. In Excel for Windows, open File > Options > Advanced and, under Display options for this worksheet, check that Show outline symbols if an outline is applied is enabled for the correct sheet. The setting is worksheet-specific, so make sure the intended worksheet is selected.

If a plus or minus control seems to affect the wrong rows, expand the outline completely and inspect the bracket endpoints. A group may include a heading or total row by mistake, or two groups may overlap differently than intended. Use Data > Outline > Ungroup to remove the incorrect level, then select the correct detail rows and group them again. You can also choose Clear Outline to remove all outline levels on the worksheet, but that does not delete the data; use it only when you are ready to rebuild the outline.

When grouping is not the best solution

Choose the feature that matches the job. Use grouping when people need to expand and collapse fixed sections of a report. Use filters when they need to show records based on changing criteria, such as a particular region or date. Use Hide and Unhide when a few rows should be temporarily out of sight without adding outline levels.

For totals by category, a PivotTable may be a better fit than manually grouping a changing transaction list. A PivotTable can summarize and expand categories without requiring you to maintain row groups as the source list changes. For a stable printed report, manual grouping may be simpler. Whichever approach you choose, keep a clear summary row and label sections so readers can tell what a collapsed group represents.

Frequently Asked Questions

Why is Group greyed out in Excel?
Check whether the sheet is protected, multiple worksheet tabs are selected, or a cell is still being edited. Then select the row numbers on a single worksheet and try Data > Outline > Group.

Can I group rows in a filtered list?
Filtering and grouping are separate features. A filter hides records based on criteria, while an outline collapses a row section. Clear the filter to inspect the full list if the group appears incomplete.

Does grouping rows hide or delete data?
No. Collapsing an outline hides detail from view but leaves the rows and their contents in the worksheet. Expand the group with its plus control to display them again.

How do I remove row grouping without deleting rows?
Select the grouped rows and choose Data > Outline > Ungroup. To remove every outline level from the sheet, use Clear Outline; neither action deletes the row contents.

Why can I not see the plus and minus buttons?
The outline symbols may be hidden in the worksheet’s display options, or protection may prevent their use. Check File > Options > Advanced in Windows and confirm that outline symbols are shown for the selected worksheet.

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.