Office Settings & Configuration

How to Resize an Individual Level 2 Outline Group in Excel

Muhammad TalhaMuhammad Talha Nov 11, 2026 869 views

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.

How to Resize an Individual Level 2 Outline Group in Excel
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 you start

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.

Solution 1Recommended

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.

1
Select current grouped rows

Highlight the rows that are currently included in the specific Level 2 outline group you want to modify.

2
Ungroup the rows

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.

3
Select the new range

Highlight the new, correct range of rows you want to include in the resized Level 2 group.

4
Regroup the rows

Go back to the Data tab and click Group (or press Shift+Alt+Right Arrow) to establish the new boundary.

5
Verify surrounding groups

Check the left-hand outline pane to ensure that surrounding groups (like Level 1 parent groups or neighboring Level 2 groups) remain intact.

Row Height vs. Outline Boundaries: Adjusting the row height of grouped rows using standard formatting or a VBA macro will only change their visual height on the screen; it will not add or remove rows from the outline group itself.
Easily Manage Outlines in WPS Spreadsheet

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. 1. Open your file: Launch WPS Spreadsheet and open your existing Excel file containing the outlines.
  2. 2. Go to the Data tab: Navigate to the Data tab on the top ribbon menu where the outlining tools are located.
  3. 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.
Fully compatible with Microsoft Excel (.xlsx, .xls) formats without altering your existing groups.Intuitive Data tab for quick Group and Ungroup operations.Lightweight software that handles complex outlines and large datasets smoothly.Free to use with a familiar, easy-to-navigate interface.
microsoft office alternative - wps office

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.