Others

How to Create Separate Expandable Row Groups in Excel

Rana Garcia Oct 9, 2026 868 views

Question details

The user needs to create multiple, independent expandable row groups in Excel without them automatically merging into a single large outline group.

How to Create Separate Expandable Row Groups in Excel

Product: Microsoft Excel
Device & OS: not provided
Scenario: Organizing spreadsheet data with multiple collapsible sections based on different labels or categories.
Observed behavior: When selecting consecutive sets of rows to group, Excel combines them into one continuous outline group instead of maintaining separate, independent groups for each category.

Before you start

Ensure your data is formatted as a normal range rather than a structured Excel Table, as grouping and subtotal features are limited or unavailable within structured tables. Also, verify that there is at least one ungrouped row between your intended groups to prevent them from merging.

Solution 1Recommended

Manually Group Separate Row Ranges

The most direct way to create separate groups is to select and group each range individually, making sure to leave an ungrouped row between each section.

Excel's outline feature relies on adjacent rows to determine group boundaries. If you group rows 2-5 and then immediately group rows 6-9, Excel assumes they belong to the same outline and merges them. To keep them separate, you must leave the header or footer row of each section ungrouped.

Select the first data range

Highlight the rows for your first group (e.g., rows 4 through 8). Ensure you do not select the header row (e.g., row 3), as this will serve as the visible label when the group is collapsed.

Apply the Group function

Navigate to the Data tab on the Excel ribbon, look for the Outline group on the far right, and click on Group. An outline control (a minus sign) will appear to the left of the row numbers.

Skip a row and select the next range

Skip at least one row (such as the header for the next section on row 9), select the next set of rows (e.g., rows 10 through 14), and repeat the Group action.

Collapse and expand to test

Click the minus (-) buttons on the left margin to collapse your newly created groups. You should now see multiple, independent expandable sections.

Structured Tables Workaround: If your data is currently in an official Excel Table, click anywhere inside it, go to the Table Design tab, and click 'Convert to Range' before grouping.

Solution 2

Use the Subtotal Feature for Automated Grouping

If your data is categorized by column labels, the Subtotal tool can automatically calculate summaries and create separate expandable groups for you.

WPS Spreadsheet Alternative

Easily Manage Data Outlines and Groups with WPS Spreadsheet

WPS Spreadsheet provides a highly intuitive and robust environment for data management. You can effortlessly group rows, create structured outlines, and handle complex data sets exactly as you would in Microsoft Excel, but with a lighter footprint.

1. Open your workbook: Launch WPS Spreadsheet and open your existing Excel file.
2. Select the rows to group: Highlight the rows for your first section, carefully excluding the header row so the groups remain separated.
3. Group the data: Navigate to the Data tab and click the Group button. The outline margins will appear on the left.
4. Repeat for remaining sections: Skip the next header row and group the subsequent rows. You will immediately see separate, independent expandable groups.

100% compatible with Microsoft Excel (.xlsx) formatsFamiliar interface for seamless data grouping and outliningLightweight application with blazing fast performanceCompletely free to use for everyday spreadsheet tasks

microsoft office alternative - wps office

Frequently Asked Questions

Why do my grouped rows in Excel keep merging into one large group?

Excel automatically merges consecutive grouped rows into a single outline group to form a continuous block. To prevent this from happening, you must leave at least one ungrouped row (usually the header, subtotal row, or a blank row) between the ranges you want to group.

Can I group rows inside a structured Excel Table?

Standard outline grouping can sometimes behave unpredictably inside structured tables, and automated tools like Subtotal are completely disabled. It is highly recommended to convert the table back to a normal range (Table Design > Convert to Range) before creating row groups.

How do I remove a row group I created by mistake?

To remove a group, select the grouped rows, go to the Data tab, and click Ungroup in the Outline section. If you want to remove all row groups from the worksheet at once, click the dropdown arrow below Ungroup and select 'Clear Outline'.

Office Quick Solutions