Office for Mac Issues

Group Rows and Create Nested Outlines in Excel for Mac

Maira MehtabMaira Mehtab Nov 22, 2026 868 views

Question details

Learn how to group rows and create nested outlines in Excel 2019 for Mac.

How to Group Rows and Create Nested Outlines in Excel 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.
Before you start

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.

Solution 1Recommended

Manually group rows and build nested outlines

Use manual grouping when you want to choose the rows yourself, with or without subtotal rows.

1
Select the inner rows

Click and drag the row headers for the first set of detail rows you want to collapse.

2
Create a group

On the Data tab, choose Group. If prompted, select Rows and confirm.

3
Add the outer group

Select the larger range of row headers containing the first group, then choose Data > Group again. Repeat for other groups or levels.

4
Test the outline

Use the minus and plus controls beside the rows to collapse and expand groups, or select an outline level number to show that level.

Manually group rows and build nested outlines
Grouping and filters are separate: Grouping controls which rows are displayed in an outline. It does not determine which fields appear in filter menus.
Organize rows in WPS Spreadsheets

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. 1. Open the workbook: In WPS Spreadsheets, choose Open and select your Excel workbook.
  2. 2. Select detail rows: Drag across the row headers for the smaller section you want to group.
  3. 3. Group the rows: On the Data tab, choose Group, or open Group and Outline and choose Group. Select Rows if prompted.
  4. 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.
Collapse and expand grouped rows to navigate detailed sheetsOpen and save Microsoft Excel XLSX filesUse a familiar spreadsheet interfaceGet started with WPS Office for free
microsoft office alternative - wps office

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.