Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing column order in pivot table
Is there a way to change the order of a column in a pivot table? What about
rows? If I have a couple of tiers of information, and I want "Special" to show before "General", is there a way to change that? Thanks for any info. KK |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing column order in pivot table
click in the column
Data-Sort sounds liek you want descending, so check that radio button. "kleivakat" wrote: Is there a way to change the order of a column in a pivot table? What about rows? If I have a couple of tiers of information, and I want "Special" to show before "General", is there a way to change that? Thanks for any info. KK |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing column order in pivot table
Thanks. I found the radio buttons. But if I want to keep it on manual since
sometimes is not ascending or descending, how do I drop and drag the columns. I've tried clicking on them in the column heading in the pivot table, but they don't move. "Sean Timmons" wrote: click in the column Data-Sort sounds liek you want descending, so check that radio button. "kleivakat" wrote: Is there a way to change the order of a column in a pivot table? What about rows? If I have a couple of tiers of information, and I want "Special" to show before "General", is there a way to change that? Thanks for any info. KK |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing column order in pivot table
Select the cell that contains the column heading, e.g. Special
Point to the cell's border, and when the pointer changes to a four-headed arrow, drag the heading to a new position OR Right-click on a heading cell, and in the popup menu, choose Order, then one of the Move options kleivakat wrote: Thanks. I found the radio buttons. But if I want to keep it on manual since sometimes is not ascending or descending, how do I drop and drag the columns. I've tried clicking on them in the column heading in the pivot table, but they don't move. "Sean Timmons" wrote: click in the column Data-Sort sounds liek you want descending, so check that radio button. "kleivakat" wrote: Is there a way to change the order of a column in a pivot table? What about rows? If I have a couple of tiers of information, and I want "Special" to show before "General", is there a way to change that? Thanks for any info. KK -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort order not being matched in pivot table | Excel Discussion (Misc queries) | |||
Display the source for a pivot table page field | Excel Worksheet Functions | |||
Count only if another column has data in Pivot Table? | Excel Worksheet Functions | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions |