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 ?

  • For all those left to right readers out there ! – nicolas Aug 21 '19 at 12:57
  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.

| improve this answer | |
  • 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 '17 at 13:55

You could customize your keyboard shortcuts

in Tools + Customize keyborad


Hide details (select your shortcut)

Show details (select your shortcut)

enter image description here

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.