Group Rows and Create Nested Outlines in Excel for Mac
Question details
Learn how to group rows and create nested outlines in Excel 2019 for Mac.

- Product
- Microsoft Excel 2019 for Mac
- Device & OS
- Mac
- Scenario
- Organize detailed rows into collapsible sections, either manually or using subtotal rows to detect an outline.
- Observed behavior
- The desired result is a worksheet with expandable and collapsible row groups, including multiple outline levels.
Open the worksheet in Excel and identify the detail rows and any subtotal rows. For an automatic outline, check that subtotal formulas refer to the detail rows they summarize.
Manually group rows and build nested outlines
Use manual grouping when you want to choose the rows yourself, with or without subtotal rows.
Click and drag the row headers for the first set of detail rows you want to collapse.
On the Data tab, choose Group. If prompted, select Rows and confirm.
Select the larger range of row headers containing the first group, then choose Data > Group again. Repeat for other groups or levels.
Use the minus and plus controls beside the rows to collapse and expand groups, or select an outline level number to show that level.

Create an automatic outline from subtotal rows
Use Auto Outline when the worksheet has summary formulas that Excel can use to detect row groups.
Create collapsible row groups in WPS Spreadsheets
Use WPS Spreadsheets to group detail rows and organize larger sections into nested outline levels. Menu labels may vary by version.
- 1. Open the workbook: In WPS Spreadsheets, choose Open and select your Excel workbook.
- 2. Select detail rows: Drag across the row headers for the smaller section you want to group.
- 3. Group the rows: On the Data tab, choose Group, or open Group and Outline and choose Group. Select Rows if prompted.
- 4. Add a larger group: Select the larger range containing the first group and use the Group command again. Use the outline controls beside the rows to test the result.

Frequently Asked Questions
Do I need subtotal rows to group rows manually?
No. Select the row headers and choose Data > Group; subtotal rows are not required.
How do I make one row group sit inside another?
First select and group the smaller range. Then select the larger range that contains it and choose Data > Group again.
Why might Auto Outline not create the groups I expect?
Auto Outline relies on the worksheet's summary formulas to detect structure. Check that subtotal formulas refer to the intended detail rows, or use Data > Group to select the ranges manually.
Does grouping rows change the fields in Excel filters?
No. Row grouping controls the outline and visibility of rows; it does not determine which fields appear in filter menus.




