Alphabetize Pivot Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, How can you alphabetize the page field in a Pivot table? I have my
data alphabetized but one item in the dropdown in the page field is out of
order.
 
I've tried the Field Settings AutoSort in Ascending order but I still have
one out of place.
 
One of the items might be an entry in one of the custom lists
(Tools>Options, Custom Lists)

Try moving the field to the row area, change it to manual sort, and use
the A-Z button on the toolbar to sort it.
Then, move it back to the page area.
 

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 Sort Order 1
How do I sort a pivot table page list? 1
Excel Pivot Table - Sort Report Filter Values 3
Pivot Table Report Filter Sorting 3
Pivot Table Items 3
Pivot Table Labels: Pull-down orfer 2
pivot table - drop down filter box has 10% of items out of order 2
Pivot Table Column Order 2

Back
Top