Explanation

You can group related rows together.

Steps

1. Select the rows you want to group.
2. Go to Data → Group.
3. Select Rows if prompted.
4. Excel creates an outline.

A − button appears beside the grouped rows.

Clicking − collapses the group.

Clicking + expands it again.

Example

Q1 Sales

Group these three rows.

The detailed rows can then be collapsed to show a more compact report.

Practice

Group January–March as Quarter 1.