Excel Group Rows: How to Expand and Collapse Rows Easily

How-to basics · Updated November 19, 2026

In Excel for Microsoft 365 on Windows, select the rows you want to fold away, choose Data > Outline > Group, then click the minus (−) outline button to collapse them; click the plus (+) button to expand them again. Grouping hides rows temporarily without deleting their contents, so it is useful for switching between a concise summary and the supporting details.

How row grouping works

Excel’s grouping feature creates an outline around selected rows. A bracket appears beside the row numbers, with a minus or plus control at its edge. The minus control collapses the group, hiding its detail rows; the plus control restores them. The cells remain in the worksheet, and their values and formulas are still there. Grouping changes what is visible, not the underlying data.

Outline level buttons, usually numbered 1, 2, and so on, appear near the top-left of the worksheet when an outline exists. Clicking a level displays that level of summary. For example, level 1 might show only overall totals, level 2 might show each department’s total, and level 3 might show all transaction rows. The exact result depends on how the groups and summary rows are arranged.

Grouping is particularly handy when a worksheet has detail that is useful sometimes but distracting at other times: monthly transactions under quarterly totals, individual tasks beneath project headings, or daily figures beneath a yearly summary. A reader can open only the sections they need instead of scrolling through every row.

Group rows step by step

  1. Select the rows you want to group. For example, click row 5, hold Shift, and click row 12 to select rows 5 through 12. You can also drag across their row headers.
  2. On the ribbon, choose Data > Outline > Group. If Excel asks whether to group Rows or Columns, choose Rows.
  3. Look to the left of the row numbers for the outline bracket and its minus button. Click the minus to collapse the selected rows.
  4. Click the resulting plus button to show the rows again.

When selecting complete rows, click their numbered headers rather than cells inside the worksheet. Selecting the row headers makes your intention clear and reduces the chance of grouping columns by mistake. If you select cells instead, Excel may infer the direction from the selection or display a Rows/Columns choice.

On Windows, the shortcut Alt+Shift+Right Arrow groups the selected rows or columns. Alt+Shift+Left Arrow ungroups the selection. Shortcuts can depend on keyboard layout and Excel configuration, so the ribbon is a dependable alternative. On Mac, use the Data tab’s Group and Ungroup controls if the Windows shortcuts do not apply to your keyboard setup.

Expand, collapse, and show an outline level

To collapse one group, click its minus sign. Excel replaces it with a plus sign; click that plus to expand the group. If the outline controls are hard to spot, look along the left edge of the worksheet beside the row numbers and just above them. The outline bracket indicates which rows belong to a group.

Use the numbered outline buttons when you want to show several groups at once at a chosen level. In a worksheet with one group per month, clicking a higher summary level can hide the daily details across the sheet together. Clicking a more detailed level reveals more rows. These buttons affect the outline display, not the values or formulas in the rows.

  • Minus (−): collapse the group beside the button.
  • Plus (+): expand that collapsed group.
  • Outline level number: show the worksheet at that overall level of detail.

If several groups are nested, clicking a parent group’s minus sign can hide its subordinate groups as well. Expand the parent first, then expand a child group to reveal its individual rows. The controls work from the outer group toward the inner groups.

Plan summary rows and nested groups

A clear layout makes an outline easier to understand. Put each subtotal or summary row outside the block of detail rows it summarizes. For example, place a department total above or below its employees, and group only the employee rows. If the total is included inside the group, it will disappear when the group is collapsed, defeating the purpose of keeping a visible summary.

For a report with several layers, create the smallest groups first and then group the larger blocks around them. Imagine rows 4–8 contain transactions for January, rows 9–13 for February, and row 14 a quarterly total. Group each month’s transactions, then group the whole detail section if you also want a single control that hides both months. Test each plus and minus button before sharing the sheet; nested outlines can be confusing if the brackets and summary rows do not match the report’s structure.

Excel supports multiple outline levels, up to eight for rows or columns. You do not need to use all of them. A simple two-level outline is often easier to operate than a deeply nested one. Use a new level only when it corresponds to a real hierarchy readers recognize, such as year, quarter, month, and transaction.

Grouping versus hiding, filtering, and subtotals

Grouping is not the same as manually hiding rows. To hide rows, right-click selected row headers and choose Hide; to show them again, select the surrounding rows, right-click, and choose Unhide. Hidden rows do not have the outline brackets and plus/minus buttons that make groups easy to expand. Grouping is usually better when people need to switch between detail and summary repeatedly.

Filters serve a different purpose. A filter displays rows that meet chosen criteria, such as transactions for one region, and excludes other matching records from view. Grouping keeps a defined block of rows together and lets you fold that block away regardless of the values in it. A worksheet can use both, but apply each for its intended job: filters for selecting records and outlines for managing levels of detail.

Subtotals are calculations, not a way of hiding rows. You can create subtotal formulas yourself and group the associated details, or use Excel’s Subtotal command where it is available for the selected data. The Subtotal feature can add summary rows and create an outline for supported list-style data. If your data is formatted as an Excel table, some outline or Subtotal options may be unavailable until you convert the table to a normal range. Grouping by itself does not calculate totals.

Common problems and fixes

The plus and minus controls are missing. First check whether an outline was created: grouped rows should have a bracket beside their row numbers. If the group exists but symbols are hidden, open File > Options > Advanced, find the display options for the worksheet, and enable “Show outline symbols if an outline is applied.” The setting applies to the selected worksheet.

Clicking Group grouped columns instead. Undo immediately if appropriate, select the numbered row headers, and use Data > Outline > Group again. If Excel presents a Rows/Columns choice, choose Rows. Selecting cells across several columns can make the intended direction less obvious.

The summary disappears when the group collapses. The summary row is probably included within the grouped range. Ungroup the affected rows, select only the detail rows, and group them again, leaving the subtotal or heading outside the selection. Excel also has an outline setting for whether summary rows appear below detail; check Data > Outline’s dialog launcher and its Settings if your worksheet’s layout requires a different arrangement.

Some rows will not group as expected. Check whether the selection includes a hidden row, an existing outline, or a worksheet structure that does not match the intended hierarchy. Try ungrouping the affected range and rebuilding the groups in a simple, ordered way. If the sheet is protected, its protection settings may prevent structural changes; an authorized editor may need to unprotect it first.

Rows seem gone after collapsing. Click the plus sign or a more detailed outline-level button. If there are no outline symbols, the rows may have been hidden manually, filtered out, or removed rather than grouped. Check the filter indicators and the row numbers before assuming the data was deleted.

Ungroup rows or remove the outline

To remove one group while keeping its rows and data, select the grouped rows and choose Data > Outline > Ungroup. If a dialog appears, select Rows. This removes the grouping structure; it does not delete the selected rows. For nested outlines, you may need to ungroup more than once to remove the levels you no longer want.

To remove all outline groups from the worksheet, choose Data > Outline > Ungroup > Clear Outline. Clearing the outline removes the grouping controls throughout that sheet but leaves the worksheet contents in place. It is different from deleting rows. Before clearing a complicated outline, consider whether you may want to preserve its structure for another report view.

Excel for Mac and Excel for the web

The steps above describe Excel for Microsoft 365 on Windows. Excel for Mac also provides row grouping and expand/collapse controls on the Data tab, though ribbon placement and keyboard shortcuts can differ. If a Windows shortcut does not work on a Mac, use the visible Data-tab commands rather than assuming the same key combination applies.

Excel for the web may present the ribbon differently from the desktop app. Look for Group or Ungroup on the Data tab, and use the outline symbols if the workbook already contains groups. If a particular outline command is not available in your web interface, open the workbook in the desktop version of Excel to make the change. When collaborating, remember that collapsing a group changes the current view; it does not remove the hidden details from the workbook.

Frequently Asked Questions

What is the shortcut to group rows in Excel?
In Excel for Microsoft 365 on Windows, select the rows and press Alt+Shift+Right Arrow. Use Alt+Shift+Left Arrow to ungroup. If your keyboard layout or Mac setup handles those keys differently, use Data > Outline > Group or Ungroup.

How do I expand all grouped rows at once?
Click the highest-numbered outline level button shown above the row numbers to display that level of detail across the worksheet. To open just one group, click its plus sign. The available levels depend on how the worksheet was grouped.

Can I group rows without hiding their data permanently?
Yes. Collapse and expand controls only change visibility. Click the plus sign to restore a collapsed group; the cell contents remain in the workbook while hidden.

Why can’t I see the plus and minus signs in Excel?
Confirm that the rows are grouped and that outline symbols are enabled. In Windows, check File > Options > Advanced for the “Show outline symbols if an outline is applied” worksheet display option. Also check whether the rows are merely filtered or manually hidden.

How do I group rows while keeping a total visible?
Select and group only the detail rows, leaving the total row outside the group. When you collapse the details, the separate total remains visible. If the total disappears, ungroup the range and rebuild it without including that row.

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.