11

When you group columns, there is a toggle button on top to fold/unfold the group.

This button by default appears on the right, which means that when you unfold the group, it jumps. So that you can't just fold and unfold in 2 clicks : you first have to find where the button has jumped

Does anyone know how to put the grouping toggle button on the left, and not on the right as is the default after grouping columns ?

1
  • For all those left to right readers out there !
    – nicolas
    Aug 21, 2019 at 12:57

2 Answers 2

14
  1. Go to the Data tab on the ribbion
  2. In the Outline section (where you have the Group buttons), click the little button at the bottom right to open the Outline Settings dialog box
  3. Uncheck Summary Columns to the Right of Detail

If the settings icon is grayed out, make sure to select a cell that is not inside an excel table. The menu will then enable, and the check boxes can be hit. The setting will apply to any groupings you make inside the table.

1
  • Ah, but this seems to do it for all columns in the sheet rather than just the selected columns. Unless there's something I'm missing?
    – Some_Guy
    May 8, 2017 at 13:55
1

You could customize your keyboard shortcuts

in Tools + Customize keyborad

Data

Hide details (select your shortcut)

Show details (select your shortcut)

enter image description here

2
  • I could, but I quite like using the mouse... :)
    – nicolas
    Apr 24, 2013 at 20:01
  • @nicolas Then, I do not know the answer.
    – Ruskes
    Apr 24, 2013 at 20:15

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .