Pivot table - how do you order a drop down filter box?

  • Thread starter Thread starter No Room in the Attic
  • Start date Start date
N

No Room in the Attic

The columns in a pivot table display arrows that, when clicked, display the
values in the column, which the user can pick to filter the pivot table.
But the values don't appear to be in any particular order. Is there a way
to tell Excel to display them in the drop down box in a sorted order?

Appreciate your feedback, Jon
 
Select one of the cells under that heading
Click the A-Z button (or Z-A) on the toolbar and the dropdown list
should also be sorted.
 
Back
Top