SOLVED

Center Across Selection + Column Grouping

%3CLINGO-SUB%20id%3D%22lingo-sub-3365692%22%20slang%3D%22en-US%22%3ECenter%20Across%20Selection%20%2B%20Column%20Grouping%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3365692%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20center%20a%20heading%20across%20columns%20C%3AR.%20I%20have%20a%20column%20grouping%20from%20C%3AM.%20When%20I%20have%20the%20columns%20ungrouped%2C%20I%20can%20see%20the%20heading%20centered%20across%20the%20selection%2C%20C%3AR.%20However%2C%20when%20I%20group%20the%20columns%20I%20can%20no%20longer%20see%20the%20heading.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20the%20heading%20to%20appear%20in%20columns%20N%3AR%20when%20grouped.%20I%20also%20do%20not%20want%20to%20use%20Merge%20and%20Center.%20I%20only%20want%20to%20use%20Center%20Across%20Selection.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3365692%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3366383%22%20slang%3D%22en-US%22%3ERe%3A%20Center%20Across%20Selection%20%2B%20Column%20Grouping%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3366383%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1388556%22%20target%3D%22_blank%22%3E%40rsantamor%3C%2FA%3E%26nbsp%3BYou%20should%20enter%20the%20value%20to%20be%20centered%20outside%20columns%20C%3AM.%20For%20instance%2C%20a%20very%20narrow%20column%20B%20as%20in%20the%20picture%20below.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202022-05-12%20at%2018.54.35.png%22%20style%3D%22width%3A%20505px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F371237iA6E082B3D206D781%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202022-05-12%20at%2018.54.35.png%22%20alt%3D%22Screenshot%202022-05-12%20at%2018.54.35.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3366390%22%20slang%3D%22en-US%22%3ERe%3A%20Center%20Across%20Selection%20%2B%20Column%20Grouping%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3366390%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3BI%20think%20this%20is%20the%20best%20approach%2C%20thank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I am trying to center a heading across columns C:R. I have a column grouping from C:M. When I have the columns ungrouped, I can see the heading centered across the selection, C:R. However, when I group the columns I can no longer see the heading. 

 

I want the heading to appear in columns N:R when grouped. I also do not want to use Merge and Center. I only want to use Center Across Selection.

2 Replies
best response confirmed by Grahmfs13 (Microsoft)
Solution

@rsantamor You should enter the value to be centered outside columns C:M. For instance, a very narrow column B as in the picture below.

Screenshot 2022-05-12 at 18.54.35.png

@Riny_van_Eekelen I think this is the best approach, thank you!