Hi
i'm not sure if you can move the "grand total" column, but the others can be
easily re-arranged by just typing the names in the order you want (ensure
that you don't make any typing errors though), what i mean is,
click on the A heading and type B
once you press enter B will now come first and A will be moved
continue as required.
Hope this helps
Cheers
JulieD
"hedrew3" wrote in message
oups.com...
In a pivot table, how do you rearrange the column order in the data
section?
Right now I show columns named A, B, C, and Grand Total.
I want to be able to rearrange them as follows (for example):
Grand Total, B, A, C.
I am using Excel 2000.
TIA
|