How to Group and Outline Rows in Excel

Grouping turns blocks of rows into collapsible outlines, so a reader can hide supporting detail and see only the summary lines, then expand again when they want the workings. It is the clean way to manage a long schedule without hiding rows manually. A well outlined model opens at a readable summary level and lets the reviewer drill in only where they need to.

What grouping does and when to use it

Grouping adds an outline to the left of the grid with collapse and expand buttons. Each group can be folded so its detail rows disappear behind a single summary row, and the small numbered buttons at the top left jump the whole sheet to a chosen outline level.

Use it for long supporting schedules: a build up of revenue by product, a detailed cost roll up, or a debt schedule with many tranches. Unlike hiding rows by hand, grouping is visible, reversible, and obvious to the next person, who can see the outline controls and expand anything they want.

Step by step

To group the detail rows that sit under a subtotal:

1. Select the detail rows you want to fold, for example rows 5:12, not the subtotal row.
2. Press Shift+Alt+Right Arrow, or go to Data > Group > Group.
3. Click the minus button in the outline bar to collapse the group, or the plus to expand it.
4. Use the level buttons (1, 2, 3) at the top left to collapse or expand the whole sheet at once.
5. To remove a group, select it and press Shift+Alt+Left Arrow, or use Data > Ungroup.

By default Excel expects summary rows below the detail; change this in outline settings if your subtotals sit above.

A model use case

In a three statement model, group the detail behind each section so the file opens at a clean summary: collapse the line item build ups under revenue and cost, leaving the totals visible, and let a reviewer expand a single section to inspect it. Nest groups to create multiple levels, for example product detail inside a segment, inside total revenue.

If your subtotals sit above their detail rather than below, open the dialog launcher in the Data > Outline group and clear Summary rows below detail so the outline buttons land in the right place.

• Nest groups for multi level outlines, such as line items inside a segment.
• Set summary rows above or below detail to match your layout.
• Group rows rather than hiding them so the structure stays visible.

Pitfalls and a clean handoff

Grouping does not protect rows; a collapsed group is still printed and still part of any selection, so a copy of the visible range can still pull in folded rows unless you use Go To Special and select visible cells only. Outlines also do not work on a sheet where Excel cannot tell summary from detail, so keep a consistent layout.

Before you send a grouped model, set every section to the outline level you want the reader to see first, so the file opens summarized rather than fully expanded. ModelMint's Prepare to Share helps finish that handoff by cleaning the file, so the recipient opens to a tidy, intentional view instead of a sprawling sheet.