Grouping and outlining in Excel - Step-by-Step Guide

Introduction

Grouping and outlining in Excel helps you organize your data by collapsing and expanding rows or columns. This makes it easier to focus on specific parts of your data without deleting anything.

When you have a large sales report and want to hide monthly details to see only quarterly totals.

When you want to organize a budget sheet by grouping expense categories and subcategories.

When you need to create a summary view of a detailed project timeline by collapsing task details.

When you want to hide detailed data temporarily to print a cleaner report.

When you want to quickly expand or collapse sections of a financial statement for presentations.

Steps

Step 1: Select the rows or columns you want to group

- Worksheet grid

The selected rows or columns are highlighted

💡 Select adjacent rows or columns that belong together

Step 2: Click the Data tab

- Ribbon at the top of Excel

Data tab options appear

Step 3: Click Group in the Outline group

- Data tab on the Ribbon

A minus (-) button appears next to the grouped rows or columns allowing you to collapse them

Step 4: Click the minus (-) button next to the grouped rows or columns

- Left side for rows or top for columns

The grouped rows or columns collapse and hide from view, showing a plus (+) button instead

Step 5: Click the plus (+) button to expand the group again

- Next to the collapsed group

The grouped rows or columns become visible again

Step 6: To remove grouping, select the grouped rows or columns again

- Worksheet grid

The selection is highlighted

Step 7: Click Ungroup in the Outline group on the Data tab

- Data tab on the Ribbon

The grouping is removed and the minus/plus buttons disappear

Before vs After

Before

Rows 5 to 10 show detailed monthly sales data visible all at once

After

Rows 5 to 10 are grouped and collapsed, showing only a summary row with a plus (+) button to expand details

Settings Reference

Group

📍 Data tab > Outline group > Group button

Creates a collapsible group for selected rows or columns

Default: None

Ungroup

📍 Data tab > Outline group > Ungroup button

Removes grouping from selected rows or columns

Default: None

Show Detail

📍 Data tab > Outline group > Show Detail button

Expands or collapses grouped data

Default: Show

Subtotal

📍 Data tab > Outline group > Subtotal button

Automatically groups data and inserts subtotals

Default: None

Common Mistakes

Selecting non-adjacent rows or columns before grouping

Excel only groups adjacent rows or columns, so non-adjacent selections will not group properly

Select only adjacent rows or columns that belong together before clicking Group

Trying to group without selecting any rows or columns

Excel needs a selection to know what to group; no selection means no grouping

Always select the rows or columns you want to group first

Confusing grouping with hiding rows or columns manually

Manual hiding does not create collapsible groups and is harder to manage

Use the Group feature to create collapsible sections that are easy to expand or collapse

Summary

Grouping and outlining lets you collapse and expand rows or columns to organize data.

Use the Data tab's Group and Ungroup buttons to create or remove groups.

Groups must be made from adjacent rows or columns to work correctly.