How to Group Rows in Excel: Step-by-Step Guide

To group rows in Excel, select the rows you want to group, then go to the Data tab and click Group in the Outline section. This creates a collapsible group that you can expand or collapse to hide or show the selected rows.

Syntax

Grouping rows in Excel does not use a formula but a menu command with this pattern:

• Select rows: Highlight the rows you want to group.
• Go to Data tab: Click on the Data tab in the ribbon.
• Click Group: In the Outline group, click Group.
• Choose Rows: If prompted, select Rows to group the selected rows.

This creates a collapsible outline for the selected rows.

excel

Select rows → Data tab → Group → Rows

Example

This example shows how to group rows 2 to 5 in an Excel sheet:

1. Select rows 2 to 5 by clicking and dragging on the row numbers.
2. Click the Data tab on the ribbon.
3. Click the Group button in the Outline section.
4. Choose Rows if asked.
5. You will see a minus (-) button appear next to the row numbers to collapse the group.

Clicking the minus button hides rows 2 to 5, and clicking the plus (+) button shows them again.

excel

1. Select rows 2 to 5
2. Data tab → Group → Rows
3. Use the minus (-) button to collapse
4. Use the plus (+) button to expand

Output

Rows 2 to 5 are grouped and can be collapsed or expanded using the outline buttons.

Common Pitfalls

Some common mistakes when grouping rows in Excel include:

• Not selecting entire rows: Grouping works best when you select full rows, not just some cells.
• Grouping columns instead of rows: Make sure to choose Rows when prompted, or you might group columns by mistake.
• Trying to group protected sheets: Grouping won't work if the sheet is protected without allowing outline changes.
• Overlapping groups: Avoid grouping rows that overlap with existing groups, as it can cause confusion.

excel

Wrong: Select cells only → Data → Group → (No effect or groups columns)
Right: Select entire rows → Data → Group → Rows

Quick Reference

Action	Steps
Select rows to group	Click and drag row numbers on the left
Open Data tab	Click the Data tab in the ribbon
Group rows	Click Group in the Outline section, choose Rows
Collapse group	Click the minus (-) button next to grouped rows
Expand group	Click the plus (+) button to show rows again
Ungroup rows	Select grouped rows → Data tab → Ungroup

Key Takeaways

Select entire rows before using the Group command in the Data tab.

Use the minus (-) and plus (+) buttons to collapse and expand grouped rows.

Choose 'Rows' when prompted to ensure correct grouping.

Grouping won't work on protected sheets without outline permissions.

Avoid overlapping groups to keep your data organized clearly.