Group and ungroup columns

Support

Hello,

Select a different account.

You have multiple accounts

Choose the account you want to sign in with.

Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web More...Less

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

Select the columns to include the group.
Select the Data tab and then Group in the Outline area.
You can also press option+shift+right arrow.

Tip: To ungroup, go to Data and select Ungroup, or press option+shift+left arrow.

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

Select the columns to include the group.
Select the Data tab and then Group in the Outline area.
You can also press Ctrl+Shift+Right Arrow.

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