LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Joyce
 
Posts: n/a
Default Sorting pivot table drop-down

I notice that the drop-down menu for one of the fields of a pivot table is
randomly arranged. I like for it to be ascending or alphabetical order. Do
you know what order it is sorting in (is it based on the order of the source
data?) and is there a way to get it to sort alphabetically?

Thanks
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need help sorting pivot table Randy Harris Excel Discussion (Misc queries) 6 April 25th 05 05:38 AM
How do I remove items listed in a pivot table drop down list box Hart165Hour Excel Discussion (Misc queries) 3 March 16th 05 04:19 AM
Problems with Pivot Table Field Sorting in Excel 2002 Phoenix71555 Excel Discussion (Misc queries) 1 February 27th 05 11:25 PM
Problems with sorting a pivot table Gavim Francis Excel Discussion (Misc queries) 1 February 3rd 05 11:32 PM
Problem with Pivot Table Drop-Down Menus Mac Excel Worksheet Functions 4 November 7th 04 01:18 PM


All times are GMT +1. The time now is 11:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"