pivot table - drop down filter box has 10% of items out of order

D

davidsokay

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?
 
D

Debra Dalgleish

If you sort the field in the pivot table, the items in the field's
dropdown list should also be sorted.

To sort a column field, select a cell in the column area, and click the
A-Z button on the tool bar.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic Naming of Form Button 3
Filtered drop down list 2
Slicers and Calculated Items in Pivot Table 2
Pivot table - Filter - no filter by value 0
how do I control the sort order of a filter in a pivot table? 1
Excel Pivot Table - Sort Report Filter Values 3
How to refresh drop-down list of pivot table 3
Pivot Table Sort Order 1

Top