Headings Group columns

  • Thread starter Thread starter Shailesh
  • Start date Start date
S

Shailesh

How can I group a few columns together?
Suppose I group Column 1 , Coulumn2, ...., Column6 as One and
similarly I group Column 7, Coulmn 8, ....., Column10 as Two and I
put One and Two as heading in top of columns .
then how can I retain their labels / headings when I insert more
columns in the left or right of it?

Will appreciate your quick response and will be happy to clarify it
more or write to you my business justification?
 
Hi

Mark the range of cells in row 1.
Format>Cells>Alignment>Horizontal>Centre across Selection
 
Actually I have a Pivot table having 5 Page fields and
I group Column 1 , Coulumn2, ...., Column6 as One and
similarly Column 7, Coulmn 8, ....., Column10 as Two and I
put One and Two as heading in top of columns .

How ever as I bring down columns these headings looses formatting?

Any help?
 
Back
Top