Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Filtering by criteria within Pivot Tables in Excel 2000 | Excel Discussion (Misc queries) | |||
Recommondation for training sites for Pivot Tables in Excel 2000? | Excel Worksheet Functions | |||
Sorting in Excel 2000 Pivot Tables | Excel Discussion (Misc queries) | |||
Pivot Tables in Excel 2000 | Excel Discussion (Misc queries) | |||
How can I delete rows from Pivot Tables in Excel 2000 as in 97 | Excel Discussion (Misc queries) |