Excel 2010: how to group column data to the left
fsardin
Posted messages
2
Status
Membre
-
aziz -
aziz -
Hello,
I am a "power user" of Excel, but here I am with the 2010 version of Excel, and I can no longer find a function that allows grouping data to the left instead of to the right (by default).
Here are the details: when you want to group data (Data/Group), Excel automatically places the summary column on the right (that's where the little "+" symbol appears). Now, it used to be possible to set the options and specify that we would prefer the summary line to be on the left.
My problem is that... I can no longer find this option in the 2010 version of Excel.
Can anyone help me?
Thank you!
I am a "power user" of Excel, but here I am with the 2010 version of Excel, and I can no longer find a function that allows grouping data to the left instead of to the right (by default).
Here are the details: when you want to group data (Data/Group), Excel automatically places the summary column on the right (that's where the little "+" symbol appears). Now, it used to be possible to set the options and specify that we would prefer the summary line to be on the left.
My problem is that... I can no longer find this option in the 2010 version of Excel.
Can anyone help me?
Thank you!
2 réponses
Good evening,
It is still possible to do it.
You just need to click on the dialog box launcher in the "Plan" group of the "Data" tab (the small arrow in the bottom right of this group).
In the dialog box, uncheck the second box "Summary columns to right of details." I'm sorry, but I have the software in English.
Have a great evening.
Best regards,
E
It is still possible to do it.
You just need to click on the dialog box launcher in the "Plan" group of the "Data" tab (the small arrow in the bottom right of this group).
In the dialog box, uncheck the second box "Summary columns to right of details." I'm sorry, but I have the software in English.
Have a great evening.
Best regards,
E
I suspected it was a simple procedure. However, this little arrow in the bottom right is not selectable (it's a light gray). Maybe it's because I'm trying to "group" a table?
Your ideas are welcome.
Thank you!
F.
The "small arrow in the bottom right" of the "Data" section of the Excel ribbon cannot be selected when selecting columns that contain a table formatted with the "Format as Table" function.
Solution/Tips to get the small "+" cross on the left:
1. select a column that does not contain a formatted table
2. click on the "small arrow in the bottom right" because this time it’s accessible and choose the option that suits you.
Thank you very much,
I had the same problem and I've been stuck on it for weeks (it's not urgent to fix, but still annoying) and I was desperate to find the answer.
Standing ovation
dbl.