Rearrange data columns in Pivot Table
 

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

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

JulieD wrote:
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.


Julie,

I tried to type in a new heading in a column but it did not reorder the
columns. Any ideas?

TIA

Pete

Hi

um, always works for me - got to type it EXACTLY and it only rearranges once
you click in another cell or press enter.
but just checking:

you have something along the following lines ...
........A..................B...................... C.......................D
3....SumofNums...Department.................
4.....Location........Accounts........Admin....... .........I.T.
5.....North...............57..................67.. ..................3

and you want to see I.T. then Accounts then Admin
so click in B4, type
I.T.
press enter and it should rearrange - as i said i don't think you can move
the grand total.

Let me know how you go

Cheers
JulieD



"hedrew3" wrote in message
oups.com...
JulieD wrote:
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.


Julie,

I tried to type in a new heading in a column but it did not reorder the
columns. Any ideas?

TIA

Pete

JulieD wrote:
Hi

um, always works for me - got to type it EXACTLY and it only
rearranges once
you click in another cell or press enter.
but just checking:

you have something along the following lines ...

........A..................B...................... C.......................D
3....SumofNums...Department.................
4.....Location........Accounts........Admin....... .........I.T.
5.....North...............57..................67.. ..................3

and you want to see I.T. then Accounts then Admin
so click in B4, type
I.T.
press enter and it should rearrange - as i said i don't think you can
move
the grand total.

Let me know how you go

Cheers
JulieD



Ahhh...the light finally came on. Now it works.

What I kept doing was RENAMING Admin (for ex) to something like 'Human
Resources', and expecting the pivot table to re-sort - which it does
not do.

But now I see what you are saying --- just type in another of the
column (or row) values and it will rearrange the order.

Thanks,

Pete

you're welcome

"hedrew3" wrote in message
oups.com...

JulieD wrote:
Hi

um, always works for me - got to type it EXACTLY and it only
rearranges once
you click in another cell or press enter.
but just checking:

you have something along the following lines ...

.......A..................B......................C .......................D
3....SumofNums...Department.................
4.....Location........Accounts........Admin....... .........I.T.
5.....North...............57..................67.. ..................3

and you want to see I.T. then Accounts then Admin
so click in B4, type
I.T.
press enter and it should rearrange - as i said i don't think you can
move
the grand total.

Let me know how you go

Cheers
JulieD



Ahhh...the light finally came on. Now it works.

What I kept doing was RENAMING Admin (for ex) to something like 'Human
Resources', and expecting the pivot table to re-sort - which it does
not do.

But now I see what you are saying --- just type in another of the
column (or row) values and it will rearrange the order.

Thanks,

Pete