How to Resize an Individual Level 2 Outline Group in Excel
Question details
The user wants to change the boundary or size (number of rows included) of a single level 2 outline group without disrupting adjacent outline groups.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Modifying an existing complex spreadsheet outline where a specific sub-group (Level 2) needs to be expanded or shrunk to include a different set of rows.
- Observed behavior
- Excel does not have a direct command or drag-and-drop feature to resize the boundary of a specific outline group. Changing row height only alters visual appearance, not the group's logical grouping boundaries.
Before modifying your outline groups, ensure that your data is properly sorted and that modifying the outline will not disrupt nested level 3 groups or formulas dependent on visible ranges. Expand all outline levels first so you can clearly see the rows you are working with.
Manually Ungroup and Regroup the Specific Rows
Since Excel does not allow dragging outline boundaries, the most reliable method is to clear the specific group and create a new one with the correct rows.
Highlight the rows that are currently included in the specific Level 2 outline group you want to modify.
Go to the Data tab on the ribbon and click Ungroup in the Outline group (or press Shift+Alt+Left Arrow) to remove the existing grouping boundary.
Highlight the new, correct range of rows you want to include in the resized Level 2 group.
Go back to the Data tab and click Group (or press Shift+Alt+Right Arrow) to establish the new boundary.
Check the left-hand outline pane to ensure that surrounding groups (like Level 1 parent groups or neighboring Level 2 groups) remain intact.
Use a VBA Macro to Rebuild the Target Group
If you frequently need to resize outline groups in a standard recurring template, you can use VBA to programmatically clear and recreate the grouping.
Use WPS Spreadsheet to Organize Data Flawlessly
WPS Spreadsheet offers a highly compatible and intuitive interface for managing complex data outlines. You can easily group, ungroup, and manage nested sub-totals just like in Microsoft Excel, completely for free.
- 1. Open your file: Launch WPS Spreadsheet and open your existing Excel file containing the outlines.
- 2. Go to the Data tab: Navigate to the Data tab on the top ribbon menu where the outlining tools are located.
- 3. Adjust your groups: Select the rows you want to adjust and seamlessly use the Group or Ungroup buttons to resize your outline levels accurately.

Frequently Asked Questions
Why doesn't changing the row height change my outline group size?
Row height only affects the visual display of the cells. Outline groups are logical boundaries defined by the rows' grouped properties, which must be modified using the Group or Ungroup commands rather than formatting options.
Can I drag the outline bar on the left to resize a group?
No, Excel and similar spreadsheet programs do not support dragging the outline bracket or bar to resize a group. You must ungroup the existing range and group the new range to redefine the boundary.
Will ungrouping a Level 2 group affect my Level 1 group?
As long as you only select the rows specific to the Level 2 group and click 'Ungroup' once, it will only remove the inner (Level 2) grouping, leaving the outer (Level 1) parent group intact.
Is there a shortcut for grouping and ungrouping rows?
Yes, you can select your rows and press Shift + Alt + Right Arrow to Group them, and Shift + Alt + Left Arrow to Ungroup them.




