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

  • Thread starter No Room in the Attic
  • 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
 
D

Debra Dalgleish

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.
 

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

Pivot Table Filter values 5
Pivot Table Solve Order 1
Pivot Table Help! 1
Update Filter List AFTER Filter Applied 3
Turning Data into a Table 1
PIVOT - Reference a cell outside the table for report filtering 2
Pivot Table 1
pivot table - drop down filter box has 10% of items out of order 2

Top