Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

[SOLVED] Switch the Grouping Column to the Left Column

Copper Contributor

Hello Community !

EXCEL MAC

 

I can't find any answer to my problem among the topics... I am sure there is a setting to manipulate because I've already seen what I am looking for in a spreadsheet one day...

 

I want to change the position of the folding column from right to left when using the grouping function.

Attached below is a screenshot of my issue: I want the column D to be the folding column of E and F, not column G.

 

Capture d’écran 2023-05-05 à 15.15.34.png

 

Any advices ?

 

SOLUTION: Go to the Mac bar right above, click on "Data" (not the "Data" from Excel) > Group and Create a plan > Options...

0 Replies