View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default Ordering Columns in Pivot Tables - Excel 2000

Hi

You need to double click on the field nameAdvancedchoose Manual Sorting
then you should have the options to move the columns as you wish.

--

Regards
Roger Govier

"SnoHo71" wrote in message
...
I have a Pivot table consisting of 25 columns. I would like to customize
the
sort order of the columns. Here is what I have tried thus far:
1) Dragging cells to order them. I get a pop up saying that the operation
can't be complete
2) Custom Sort. 23 of the 25 columns sort correctly. The problem is that
the columns that 2 columns that should be in the middle (should be columns
12
and 13) end up at the end (columns 24 and 25).

3) Using the order functionality. All options: Move to Begining, Move UP,
Move Down, Move to End are "greyed out" (unable to select).

Any advice is much appreciated. Thanks