Excel Row Groups: Grouping, Labels, and Naming Limits

How-to basics · Updated November 18, 2026

Yes—you can group rows in Excel with Data > Group, then expand or collapse the group using the outline controls. However, Excel does not provide a custom-name field for an outline group itself. You can label the rows with worksheet text or give their cell range a defined name, but those are separate from the grouping feature.

What a row group means in Excel

An Excel row group is a set of adjacent worksheet rows placed into an outline. The outline adds controls that let you hide the group’s detail rows temporarily and show them again later. This is useful when a worksheet contains sections such as monthly transactions, project tasks, or supporting calculations that are helpful but not always needed on screen.

Grouping changes what is displayed; it does not delete the rows or turn them into a separate data object. When a group is collapsed, its rows are hidden, and the worksheet may show a small plus sign where you can expand them. Excel also displays outline levels, usually numbered buttons such as 1 and 2, so you can show a broader or more detailed view of the worksheet.

The group has no built-in title such as Sales Details or January. That is why people asking whether they can name a group may mean one of two things: they may want a visible label for readers, or they may want a name they can refer to in formulas. Excel handles those needs with different features.

How to group rows

In Excel for Microsoft 365 on Windows, select the rows you want to group by clicking their row numbers, then choose Data > Group in the Outline area of the ribbon. If Excel opens a Group dialog, choose Rows and confirm. The selected rows should become an outline group, with a bracket and a collapse control alongside the row headings.

  1. Click the first row number in the section.
  2. Hold Shift and click the last row number to select a continuous block of rows.
  3. Choose Data > Group, select Rows if prompted, and confirm.
  4. Use the minus control to collapse the group, or the plus control to expand it.

You can also select cells spanning the rows instead of clicking the row headings. Selecting entire rows makes your intention clearer and helps avoid grouping only part of a section. If you select a range of cells, check the dialog’s Rows or Columns choice before confirming. Excel for Mac has the same basic outline feature; use the Data tab’s Group command. Ribbon layout can vary by version and window size, so the command may appear in a differently arranged section. Excel for the web may also present ribbon controls differently from the Windows desktop app.

How to expand, collapse, and remove a group

Click the minus sign beside a group to collapse it; click the resulting plus sign to show its detail rows again. The outline level buttons let you change the display for multiple groups at once. For example, if level 1 shows only summary rows and level 2 shows the summaries plus their detail, clicking 1 can give you a compact overview. The exact visible levels depend on how the worksheet is outlined.

To remove a group without deleting its contents, select the grouped rows and choose Data > Ungroup. If the selection contains nested groups, Excel generally removes the innermost grouping first. The Clear Outline command removes the worksheet’s outline structure, so use it only when you intend to clear all the groupings rather than one section. Ungrouping or clearing an outline changes the display structure, not the values in the cells.

Collapsing is not the same as filtering. A collapsed group hides rows as part of the outline, while a filter shows or hides records according to criteria such as a date or category. Choose grouping when readers need to expand a known section; choose filtering when they need to find records that match changing conditions.

Can you give the group a custom name?

No—not as a property of the outline group. Excel’s row-group controls have no field where you can enter a label, and there is no group-name list comparable to a list of worksheet tabs. The outline is based on row positions and nesting, not on a named group object.

You can, however, assign a defined name to the cells in those rows. Select the relevant cell range and use Formulas > Define Name, or use the Name Box to the left of the formula bar. For instance, you might define a range name such as Quarter1Details for a block of supporting data. A defined name can make formulas and navigation easier, but it does not label the outline bracket, and collapsing the group does not rename or remove the defined name.

Defined names refer to cell references or formulas, not to the visual group as an independent object. If rows are inserted, deleted, or moved, check that the defined name still refers to the cells you intend. You can review and edit names through Formulas > Name Manager. Do not confuse a named range with an outline level: they solve different problems.

Practical ways to label a section

If the goal is to help people understand what a collapsed section contains, put a clear summary label in a visible row outside the group. For example, a report might have a row reading January detail, followed by the transaction rows that can be collapsed. Keep the label outside the rows being hidden if readers need to see it after collapse.

A common layout puts a subtotal or section heading just above or below the detailed rows. Excel’s outline settings include an option controlling whether summary rows appear below detail; the placement should suit the worksheet’s layout. If you create groups manually, decide where the summary row belongs before grouping so that collapsing the detail does not hide the information readers need.

  • Visible heading: Add a descriptive row such as Project A tasks or Q2 expenses, and keep it outside the group.
  • Defined range name: Name the cells when you need to refer to them in formulas or jump to them.
  • Worksheet organization: Use separate worksheets when sections are substantial and need distinct layouts or audiences.
  • Cell formatting: Use a consistent fill, border, or font style to make section boundaries easier to scan.

For a shared workbook, a visible heading is often more useful than a defined name because it explains the section to someone looking at the sheet. A range name is more helpful to someone maintaining formulas. You can use both when the worksheet needs both human-readable organization and formula-friendly references.

Nested groups and outline levels

Groups can be nested to show increasingly detailed levels. For example, a worksheet may have rows for individual transactions grouped under monthly sections, while the months are grouped under quarters. Collapsing the quarter can hide several month-level sections; expanding it can reveal the months, which can then be expanded to show transactions. Excel supports up to eight outline levels for rows or columns.

Nested groups are useful only when the hierarchy is clear. If you group unrelated blocks or create several levels without summary labels, readers may find it difficult to tell what a plus or minus sign will reveal. Use a consistent pattern: put detail beneath its summary, group the detail rows, and check the result at each outline level.

To create a hierarchy, make the smaller detail groups first, then group the larger blocks around them. When collapsing, start with the level that gives the desired overview. If the controls do not behave as expected, inspect the brackets and level buttons before adding more groups; overlapping selections can create nesting that is not obvious from the cell contents alone.

How row groups differ from other Excel features

Excel uses the word group in several contexts, which can make the terminology confusing. The Data tab’s outline grouping is specifically for collapsing and expanding worksheet rows or columns. It is not the same as grouping selected shapes, grouping categories in a PivotTable, or grouping data by date in a report.

An Excel Table is designed to organize a set of related records with headers, filtering, and structured references. It does not automatically create collapsible sections for arbitrary blocks of rows. A filter hides records that do not match criteria, whereas an outline group hides a defined block regardless of the values in those rows. A PivotTable can group or summarize its own fields, but that grouping belongs to the PivotTable layout rather than to ordinary worksheet rows.

Choose the feature based on the task: use an outline group for manually organized sections, a filter for selecting matching records, a Table for managing a structured list, or a PivotTable for summarizing and exploring data. These features can coexist, but one does not automatically name or control the others.

Common problems and fixes

If the Group command is unavailable or the outline controls do not appear, first confirm that the intended rows are selected and that the worksheet is not protected in a way that prevents outlining changes. Also check whether the sheet already has an outline; nested groups can make new controls appear at a different level than expected. If you selected cells rather than full rows, verify that Excel is grouping rows, not columns.

If a group collapses but its heading disappears too, the heading was probably included in the grouped rows. Ungroup the section if necessary, then select only the detail rows and group them again, leaving the summary row visible. If an outline seems cluttered, use Data > Ungroup on the relevant selection, or clear the outline only if you mean to remove all grouping from the sheet.

Hidden rows can also make a worksheet look as though grouping has failed. Check the row numbers and outline symbols, and expand the group before assuming data is missing. Collapsing a group does not erase data, but it can hide information from readers; label sections clearly and avoid using hidden detail as the only place where an important instruction appears.

Frequently Asked Questions

Can I name an Excel row group?
No. An outline group has no custom-name property. You can add a visible heading or create a defined name for the cells, but neither names the outline control itself.

How do I group rows in Excel?
Select the row headings for the detail rows, then choose Data > Group and choose Rows if Excel asks. Use the plus and minus controls to expand or collapse the section.

Can I group nonadjacent rows together?
Excel outline groups are made from contiguous row blocks. For separate sections, create separate groups rather than expecting one outline control to collapse scattered, nonadjacent rows.

Does collapsing a group delete its data?
No. It hides the grouped rows from view. Expand the outline to display them again; ungrouping removes the outline structure but leaves the cell contents in place.

What is the difference between grouping and hiding rows?
Both can make rows temporarily disappear, but a group adds outline brackets and controls for expanding or collapsing a section. Hiding rows manually does not create that structured outline control.

Can I use a group name in a formula?
Not as an outline-group name, because Excel does not assign one. You can define a name for the cell range and use that defined name where Excel accepts range references, but it remains separate from the row group.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.