Headings Group columns

[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?

 

[Roger Govier]

Hi

Mark the range of cells in row 1.
Format>Cells>Alignment>Horizontal>Centre across Selection

 

[Shailesh]

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?