View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mr. Low Mr. Low is offline
external usenet poster
 
Posts: 505
Default Excel 2002 - Pivot Table : How to rearranged columns by draging ?

Dear Sir ,

I have the following Pivot Table :


Sum of Amt Column Label
Row Label Claim Collectable Dispute Outstanding Grand Total
A921 xxx
B841 xxx
D147
E465
P544
Grand Total

By default the column is sorted in alphabetical order, may I know how to
drag the column to the order I wanted ? I try but the column does not move.

Also can you show me how to eliminate row and column total if they are not
needed ?

Thanks

Low

--
A36B58K641