Excel Group Rows Not Working? Fix the Common Causes

To group rows in Excel for Microsoft 365 on Windows, select the row numbers, then choose Data > Outline > Group. If Group is unavailable or the outline controls do not appear, check whether the rows are inside an Excel table, the sheet is protected, or outline symbols are hidden.

What grouping rows does in Excel

Grouping adds an outline to worksheet rows so you can collapse detail and expand it again without deleting or moving data. For example, a monthly report might show a subtotal row for each department, with the individual transactions grouped beneath it. Collapse a department’s detail to make the report easier to scan; expand it when you need to inspect the records.

Grouping is different from hiding rows. Hidden rows are simply omitted from view, while a grouped section has outline controls—usually a minus or plus sign beside the row numbers—and level buttons such as 1 and 2. Those controls communicate that detail is available and provide a quick way to show or conceal it. Grouping also does not combine cell values or create a PivotTable.

Group rows the reliable way

For a straightforward outline, select complete rows using their numbered headers. Selecting row headers makes it clear to Excel that you intend to group rows rather than columns or a set of cells.

Click the number of the first row to group, then drag down the row headers to select the last row. For example, select rows 5 through 9 by dragging from row 5 to row 9.
Choose Data > Outline > Group. If Excel asks whether to group Rows or Columns, choose Rows.
Look to the left of the row numbers for the outline bracket and minus sign. Click the minus sign to collapse the group; click the resulting plus sign to expand it.
Use the outline level buttons, such as 1 and 2, above the row numbers to show a broader or more detailed view of the sheet.

On Windows, Alt+Shift+Right Arrow is the shortcut to group selected rows; Alt+Shift+Left Arrow ungroups them. If a shortcut does not work on your keyboard or in your Excel configuration, use the Data tab instead. On Mac, use the ribbon command because shortcut behavior can differ by keyboard and Excel version.

Why the Group command may be unavailable

A greyed-out Group command usually points to a restriction or an incompatible selection, rather than a damaged workbook. Check these causes first:

The worksheet is protected. Protection can prevent structural changes such as creating or removing groups. If you are authorized, go to Review > Unprotect Sheet and enter the password if requested. If you do not know the password, ask the workbook owner rather than trying to bypass the protection.
The selected cells are in an Excel table. Excel’s outline grouping is not available for rows within a structured table. The table’s filters and formatting are separate features and do not create outline groups.
The selection is ambiguous or includes the wrong area. Select the numbered row headers, not just a cell in each row. For the first test, choose one simple, adjacent block of rows.
You are editing a cell. Press Enter or Esc to finish editing, then try the command again.
The workbook is being edited in a limited interface. Excel for the web may not expose the same outline controls as desktop Excel. If the command is missing, open the workbook in the desktop app and try Data > Outline > Group there.

After resolving a restriction, try grouping a small test range before changing a large report. This helps distinguish a workbook-wide limitation from a problem with one selection.

Check whether the rows are inside an Excel table

Tables are useful for sorting, filtering, applying consistent formatting, and extending formulas as data grows. They are not the same thing as worksheet outlines. If the rows you want to group belong to a table, Excel may disable Group for that selection even though grouping ordinary worksheet rows works elsewhere.

One option is to keep the data as a table and use its filters to display selected records. This is often preferable when users need to sort or filter the data. If a collapsible outline is essential, you can convert the table to a normal range: click inside the table, open the Table Design tab, and choose Convert to Range. Confirm the prompt, then select the worksheet row headers and group the rows.

Conversion removes the table’s structured behavior. The data remains on the sheet, but automatic table expansion and some table-specific features no longer apply. Consider the consequences before converting a shared or operational workbook, and keep a copy if you are unsure. A filter is a reasonable alternative when the real goal is to show only certain records rather than fold sections into an outline.

Make missing outline buttons visible

Sometimes grouping succeeds, but the plus and minus controls seem to be missing. Excel has a setting that hides outline symbols, so first check whether the outline is simply invisible. On Windows, choose File > Options > Advanced. Under Display options for this worksheet, select the relevant worksheet and enable Show outline symbols if an outline is applied. Choose OK and inspect the row headers again.

Also check the left edge of the worksheet. The outline bracket and its controls sit beside the row numbers, and the level buttons sit above them. A narrow window or a horizontally scrolled view can make controls easy to overlook. If you can see level buttons but not the expected group, click a lower level to reveal more detail, then inspect the bracket beside the affected rows.

A plus sign means that detail is currently collapsed; a minus sign means the detail is open. Clicking the control changes the display, not the underlying values. If no outline symbols appear after enabling the display setting, return to the row selection and confirm that a group was actually created.

Selection, nesting, and summary rows

Group only the detail rows, not the heading or subtotal that should remain visible when the detail is collapsed. For example, if row 10 contains a department total and rows 11 through 15 contain its transactions, group rows 11 through 15. Collapsing the group then leaves the total outside the hidden detail. If the subtotal is included in the group, it may disappear along with the records, which can make the summary seem to have vanished.

You can create nested outlines by grouping smaller sections and then grouping a larger block that contains them. A sales report might have separate groups for each month and a larger group for the whole quarter. Use the outline level buttons to move between levels of detail. Build a small group first and collapse it to check that the intended headings and totals remain visible before adding more levels.

Excel can also create an outline automatically when data is arranged consistently and contains formulas that summarize detail. However, automatic outlining depends on the layout and is less predictable than selecting the exact rows yourself. For troubleshooting, manual grouping is the clearer test. If the sheet has blank rows, irregular subtotal placement, or unrelated records between sections, group each intended block separately rather than assuming Excel can infer the structure.

Ungroup rows or remove an outline

If the wrong rows were grouped, select the affected row headers and choose Data > Outline > Ungroup. If Excel asks whether to ungroup Rows or Columns, choose Rows. Ungroup removes the selected outline level; it does not delete the worksheet rows or their contents. For nested groups, you may need to repeat the command at the appropriate level.

To remove all outline groups from the active worksheet, choose Data > Outline > Ungroup > Clear Outline. This clears the outline structure, so use it only when you intend to remove every group on that sheet. It does not clear data. If rows remain hidden after removing a group, select the relevant row headers, right-click, and choose Unhide; manual hiding and outline grouping are separate actions.

Alternatives when grouping is not the right tool

Use a filter when readers need to choose which records appear based on values such as department, date, or status. Use a PivotTable when they need to summarize and rearrange categories interactively. Use Hide and Unhide when a small number of rows should be temporarily concealed without an outline structure. Each option solves a different problem, so replacing grouping with a filter is not a fix if users specifically need plus and minus controls.

For a report that must be viewed in Excel for the web or by people using different spreadsheet programs, consider whether a filter or a separate summary sheet will be easier to access consistently. Outlines are most useful when the workbook is organized into clear, stable blocks of detail with visible headings or totals. They are less helpful when users need to sort individual records across the entire dataset.

Frequently Asked Questions

Why is Group greyed out in Excel?
Common causes include worksheet protection, selecting rows inside an Excel table, or making an unsuitable selection. Try selecting adjacent row headers on an unprotected part of the worksheet. If the rows are in a table, use its filters or convert it to a range if an outline is required.

How do I show the plus and minus signs for grouped rows?
On Windows, go to File > Options > Advanced and enable Show outline symbols if an outline is applied for the correct worksheet. Then check beside the row numbers for the group controls.

Can I group rows in an Excel table?
Excel outline grouping is not available for rows within a structured table. Keep the table and filter it, or convert it to a range using Table Design > Convert to Range before creating worksheet row groups.

How do I expand all grouped rows at once?
Click the highest outline level button displayed above the row numbers. A higher level shows more detail; the lowest level shows the most condensed outline. The exact level numbers depend on how many outline levels the sheet contains.

Does Ungroup delete my data?
No. Ungroup removes the selected outline structure, not the rows or cell contents. Clear Outline removes all outline groups on the worksheet. If rows are still hidden afterward, use Unhide separately.

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.