LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default pivot table - drop down filter box has 10% of items out of order

Most of my numeric items appear in the drop down filter box in order. . I
know all these are numeric and I even tried to move it down to within the
pivot table report and got same problem. In excel 2007, I cannot figure out
how to ensure the drop down is in alphabetical order. This is a productivity
killer when looking for certain items. Any ideas?
 
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
Filter drop down box in pivot table marcmiller New Users to Excel 2 June 11th 09 06:33 PM
how do I control the sort order of a filter in a pivot table? Grizz Excel Discussion (Misc queries) 1 December 20th 08 02:01 PM
Specifying the order of pivot table calculated fields/items Rick Excel Discussion (Misc queries) 1 August 10th 08 01:56 AM
Pivot Table DATA area drop down menu items disapper after switchof Kith Excel Discussion (Misc queries) 1 April 30th 07 03:35 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


All times are GMT +1. The time now is 03:58 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"