View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
kleivakat kleivakat is offline
external usenet poster
 
Posts: 29
Default 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