How to Group and Ungroup Data in a List in Microsoft Excel

It's easy to group and ungroup data in any list in Excel. Just follow these simple steps.

This feature works the same in all modern versions of Microsoft Excel: 2010, 2013, and 2016.

To group data in a list in Excel:

1. Select the rows or columns you wish to group.
2. On the Data tab, in the Outline group, click the Group command.
3. In the Group dialog box, select Rows or Columns and click OK.

To ungroup data in a list in Excel:

1. Select the rows or columns you wish to ungroup.
2. On the Data tab, in the Outline group, click the Ungroup command.
3. In the Group dialog box, select Rows or Columns and click OK.