Yes, Excel can group rows, but the command may be unavailable or appear not to work if the sheet is protected, the selection is unsuitable, or the rows are inside an Excel table. In Excel for Microsoft 365 on Windows, select the row headers, choose Data > Group, and then use the outline controls to collapse or expand the group.
How row grouping works in Excel
Grouping adds an outline to a worksheet. It does not delete rows or combine their contents: it gives you controls to hide a set of detail rows temporarily and show them again when needed. This is useful for reports where readers may want to see a summary first and expand the underlying transactions or task details later.
After grouping, Excel displays outline symbols beside the row numbers. Depending on the worksheet and outline settings, you may see a plus or minus button and numbered outline levels. Clicking the minus collapses the selected detail rows; clicking the plus expands them. The numbered controls show broader or more detailed levels of the outline. Grouping rows is separate from filtering, hiding rows manually, or grouping items in a PivotTable.
Group rows the standard way
For a straightforward group, select consecutive row headers rather than just cells in the worksheet. For example, to group rows 4 through 8, select the row numbers 4 to 8, then choose Data > Group. Excel creates an outline around those rows. If you select cells instead of row headers, Excel may show a dialog asking whether to group rows or columns; choose Rows.
- Save the workbook if the changes are important, especially if you are working with a complex report.
- Select the row numbers for the consecutive detail rows you want to control.
- Choose Data > Group in the Outline section of the ribbon.
- Use the minus control to collapse the group and the plus control to show the rows again.
On Windows, Alt+Shift+Right Arrow groups the selected rows or columns, and Alt+Shift+Left Arrow ungroups them. On Mac, the equivalent shortcuts are Option+Shift+Right Arrow and Option+Shift+Left Arrow. Shortcuts act on the current selection, so check that the intended row headers are selected before using them. Ribbon labels and available controls can vary slightly with window size, but the Group command is on the Data tab.
Check the selection and worksheet layout
A selection is one of the simplest explanations when Group is greyed out or the result is unexpected. Make sure you selected a continuous block of row numbers, not disjointed ranges or a mixture of row and column headers. If you want a detail section between summary rows, select only the detail rows. Selecting an entire worksheet is not a useful way to create a small group and can make the outline difficult to interpret.
Also check which worksheet is active and whether the relevant rows are already hidden. A group can exist while its detail rows are collapsed, so a user may mistake a collapsed group for rows that have disappeared. Look for outline buttons or the numbered level controls near the row headings. Clicking the plus symbol or choosing a more detailed outline level should reveal the rows. If ordinary hidden rows are involved, select the rows surrounding the gap, right-click a row header, and choose Unhide; manual hiding and outlining are different features.
Grouping is intended for adjacent rows. If the rows you want to control are scattered throughout the sheet, create separate groups for the separate blocks or reorganize the report so each detail section is contiguous. A blank row does not automatically make grouping impossible, but including unrelated headings, totals, or blank separators in the selected block may produce an awkward outline. Decide which rows should disappear together before selecting them.
Protection can disable grouping or its controls
A protected worksheet restricts changes according to the permissions chosen when protection was applied. If you cannot create, change, or remove a group, go to Review > Unprotect Sheet. Excel may ask for the password set by the workbook’s owner. If you do not have permission or the password, ask the owner to make the change rather than trying to work around the protection.
Protection can also explain why existing groups will not expand or collapse. When the owner protects the sheet, the Protect Sheet options include Use outline symbols. That permission allows users to work with outline controls on a protected sheet, while other editing restrictions remain in place. If the box was not enabled, the owner may need to unprotect the sheet, adjust the protection settings, and protect it again. The exact options available depend on how the sheet was protected.
Excel tables and other kinds of grouping
An Excel table is a frequent source of confusion. Tables have their own structured features, such as filter arrows, calculated columns, and automatic expansion as data is added; they are not the same as worksheet outlines. Excel does not support applying a standard row outline within a formatted table in the same way it does to an ordinary range. If the Group command is unavailable for the table data, convert the table to a range using Table Design > Convert to Range, then try grouping the rows. The Table Design tab appears when a table cell is selected.
Converting a table removes table behavior, including its automatic expansion and structured table features, so consider the consequences first. If you need the table for filtering, formulas, or new rows, keep it as a table and use filters or a PivotTable to control what information is displayed instead. You can also place summary information outside the table and group ordinary worksheet rows in a separate report area.
Grouping dates or labels inside a PivotTable is different again. In a PivotTable, grouping applies to field items—for instance, dates grouped into months—not to the physical worksheet rows in the source list. Use the PivotTable’s own field and grouping controls when that is your goal. A PivotTable group will not create the same row-outline controls as Data > Group on a regular worksheet range.
Nested groups, subtotals, and outline levels
You can create nested outlines when a report has several levels of detail. For example, a sales report might have transaction rows grouped under each store, with store sections grouped under a region. Create the smaller groups first, then select the larger blocks around them. The numbered outline controls let readers move between levels of detail. Keep the structure consistent so that collapsing a region does not hide an important heading or summary row.
For lists that contain repeated categories and calculated totals, Data > Subtotal may be more suitable than manually grouping every section. Subtotal inserts summary rows and creates an outline based on a chosen column and calculation. The list generally needs to be sorted by the category first so each category’s records are together. Subtotal is a different operation from simply adding an outline, and it is not available while the list is formatted as an Excel table; convert the table to a range before using it if appropriate.
For a hand-built report, manual grouping leaves the summary calculations and labels under your control. For a regularly refreshed PivotTable, use PivotTable features. For a flat data list that people need to search or narrow down, filters may be clearer than collapsing rows. Choose based on whether readers need to hide detail, calculate summaries, or find matching records.
When the outline buttons are missing
If the rows group but you cannot see the plus and minus controls, check whether outline symbols are hidden. In Excel for Windows, open File > Options > Advanced, find Display options for this worksheet, and enable Show outline symbols if an outline is applied. The setting applies to the selected worksheet, so verify the sheet name shown in that section. If the controls still do not appear, check protection and confirm that an outline was actually created rather than rows simply being hidden.
Another possibility is that the worksheet is showing a different view or that the row headings are difficult to see because of the window layout. Scroll to the grouped rows and inspect the margin beside their row numbers. You can also select a row in the affected area and check whether the Data tab’s Ungroup command is available. If it is, an outline may already exist; expand it or remove it and create the intended group again.
Remove or repair a row group
To remove an outline, select the grouped row headers and choose Data > Ungroup. If groups are nested, repeating the command may remove one level at a time. To clear the worksheet’s entire outline, use Data > Ungroup > Clear Outline, taking care because this removes all outline groupings from that sheet, not just the section currently selected. Clearing an outline does not delete the worksheet data.
If the rows remain hidden after removing a group, they may have been hidden manually or by a filter. Select the affected row headers and use Home > Format > Hide & Unhide > Unhide Rows, or clear the relevant filter. This distinction matters: Ungroup removes outline structure, while Unhide Rows changes row visibility. Neither action restores records excluded by a filter until the filter is cleared.
Frequently Asked Questions
Why is the Group button greyed out in Excel?
Check whether the worksheet is protected, whether the selected rows are inside an Excel table, and whether you selected a suitable continuous range. Try selecting the row headers on an ordinary worksheet range. If the sheet is protected, its owner may need to unprotect it or allow outline symbols.
How do I group rows in Excel without hiding them permanently?
Use Data > Group on the selected row headers. The outline’s minus button temporarily collapses the detail, and the plus button restores it. Grouping does not delete the rows, and you can also expand the outline to show every level.
Can I group rows that are not next to each other?
A single outline group is for a contiguous block. Make separate groups for separate blocks, or rearrange the report so the rows that should collapse together are adjacent. Selecting disconnected rows will not create one clean group around all of them.
Why can’t I see the plus and minus signs?
The outline may not have been created, the controls may be hidden in the worksheet’s display settings, or protection may prevent their use. In Windows, check File > Options > Advanced > Display options for this worksheet and turn on Show outline symbols if an outline is applied.
Does grouping rows delete or change formulas?
No. Standard worksheet grouping changes whether rows are displayed, not the data or formulas stored in them. However, formulas can return different visible results if they use functions that respond to hidden rows, and filters or manual hiding can affect what is shown. Expand the group to inspect the original detail.
Can Excel for the web group rows?
Excel for the web supports working with some worksheet outline features, but available commands and behavior can differ from desktop Excel and may depend on the workbook. If the Group command or outline controls are unavailable in the browser, open the workbook in Excel for Microsoft 365 on Windows or Mac and make the change there.
Related
- Excel Import CSV as Text: Keep Every Value Unchanged
- Excel Import CSV Data: Steps, Settings, and Fixes
- Excel Flash Fill: How to Use It and Choose Options
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Excel Freeze Panes Not Available? Fix ItWhen Freeze Panes is unavailable or grayed out in Excel for Microsoft 365 on Windows, first exit cell-editing…
- XLOOKUP Spill Error: Why It Happens and How to Fix ItAn XLOOKUP spill error usually means Excel cannot place all the results returned by the formula into the…
- Excel Data Validation Not Showing? Fix the DropdownIf Excel’s data-validation dropdown is not showing, select the cell and check Data > Data Tools > Data…
- Excel Error 0x80070194: OneDrive Fixes and CausesExcel error 0x80070194 usually means Windows could not reach the cloud-file provider for a workbook stored in OneDrive;…
- Excel Cell Movement Locked? Fix Arrow Keys and SelectionIf Excel’s arrow keys scroll the worksheet instead of moving the selected cell, turn off Scroll Lock; on…
- Excel MATCH Function Not Working? Common FixesIf Excel’s MATCH function is not returning the result you expect, first use an exact-match formula such as…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.