How To Group Rows In Excel?

Select the rows you want to group

Go to the Data tab

Click Group in the Outline section

Choose Rows if prompted

Use the plus and minus buttons to expand or collapse the group

To ungroup, select the grouped rows

Go to the Data tab

Click Ungroup in the Outline section

Suggested for You

Trending Today