Grouper symboles invisibles

%3CLINGO-SUB%20id%3D%22lingo-sub-2820800%22%20slang%3D%22fr-FR%22%3EGroup%20invisible%20symbols%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2820800%22%20slang%3D%22fr-FR%22%3E%3CP%3EGood%20morning%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20example%20below%2C%20columns%20B%20and%20C%20are%20grouped%20together%20and%20columns%20A%2C%20B%2C%20and%20C%20are%20also%20grouped%20together.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22pdhuicq_0-1633587956304.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F315794i3037FA3053A6B906%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22pdhuicq_0-1633587956304.png%22%20alt%3D%22pdhuicq_0-1633587956304.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EStill%2C%20I%20don't%20have%20the%20%2B-%20sign%20for%20columns%20B%20and%20C.%20I%20only%20have%20the%20symbol%20to%20reduce%20or%20expand%20the%203%20columns%2C%20not%20just%20the%20two%20columns%20B%20and%20C.%3C%2FP%3E%3CP%3EI%20would%20like%20to%20have%20something%20like%20this%2C%20but%20for%20columns%20(I%20specify%20that%20for%20rows%2C%20I%20get%20the%20desired%20result)%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22pdhuicq_1-1633588185545.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F315799i1DA60DED1E295CA3%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22pdhuicq_1-1633588185545.png%22%20alt%3D%22pdhuicq_1-1633588185545.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2820800%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2821088%22%20slang%3D%22en-US%22%3ERe%3A%20Grouper%20symboles%20invisibles%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2821088%22%20slang%3D%22en-US%22%3EUse%20Home%20Ribbon-%26gt%3B%20Data-%26gt%3B%20Group%20to%20Group%20Columns.%3CBR%20%2F%3E%3CBR%20%2F%3E1.%20I%20never%20did%20it%20before%2C%20but%20for%20you%20i%20tried%20it.%3CBR%20%2F%3E2.%20Group%20the%20from%20small%20to%20biggest%20number%20of%20columns.%20While%20do%20grouping%2C%20a%20blank%20column%20should%20be%20added.%20Try%20this.%3CBR%20%2F%3E%3CBR%20%2F%3EEg.%20Group%20B%2C%20C%20Columns%20first.%20Then%2C%20leave%20D%20Column.%20Group%20E%2C%20F.%20Leave%20G%20Column.%20Group%20H%2CI%2CJ.%20Then%20Leave%20K%20column.%20Group%20B%20From%20L.%20Then%20Group%20A%20to%20N.%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
New Contributor

Bonjour,

 

Dans l'exemple ci-dessous, les colonnes B et C sont groupées ensembles et les colonnes A, B et C sont aussi groupées ensemble.

 

pdhuicq_0-1633587956304.png

Pourtant, je n'ai pas le signe +- pour les colonnes B et C. Je n'ai le symbole que pour réduire ou développer les 3 colonnes, et pas seulement les deux colonnes B et C.

J'aimerais avoir quelque chose comme ça, mais pour les colonnes (Je précise que pour les lignes, j'obtiens le résultat voulu) :

 

pdhuicq_1-1633588185545.png

Merci de votre aide.

 

 

2 Replies
Use Home Ribbon-> Data-> Group to Group Columns.

1. I never did it before, but for you i tried it.
2. Group the from small to biggest number of columns. While do grouping, a blank column should be added. Try this.

Eg. Group B, C Columns first. Then, leave D Column. Group E, F. Leave G Column. Group H,I,J. Then Leave K column. Group B From L. Then Group A to N.

Ok, thanks for your answer. It's odd ut it works. Just need to add at least 1 column for each side to work (only if you group from the left)

ie : Group A, B, then A, B, C : works fine but B,C then A, B, C doesn't and B, C, then A, B, C, D works fine too

 

Thanks !