SOLVED

Center Across Selection + Column Grouping

Copper 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!

1 best response

Accepted Solutions
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

View solution in original post