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
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" <peteg@garlic.com> wrote in message
news:1105602987.150773.303560@z14g2000cwz.googlegroups.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" <peteg@garlic.com> wrote in message
news:1107544668.052758.115990@l41g2000cwc.googlegroups.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" <peteg@garlic.com> wrote in message
news:1107589115.620444.142260@l41g2000cwc.googlegroups.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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks