Applies To
Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web

Grouping, also known as Outlining, is used to organize data and let you expand or collapse areas more easily.

  1. Select the columns to include the group.

  2. Select the Data tab and then  Group button Group in the Outline area. You can also press Ctrl+Shift+Right Arrow. 

Tip: To ungroup, go to Data and select  Ungroup button Ungroup, or press Ctrl+Shift+Left Arrow. 

For more info on grouping, see Outline (group) data in a worksheet.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.