May 12 2022 08:30 AM
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.
May 12 2022 09:56 AM
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.
May 12 2022 10:03 AM
@Riny_van_Eekelen I think this is the best approach, thank you!
May 12 2022 09:56 AM
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.