Pivot Table - Column Drop Down Lists...

G

Guest

Hello,

I have a Pivot Table that I use to to compare records with past history. I
select the records for the information I want to use for comparision from a
Column Drop Down list.

How is it that I get the Items in the drop down list to appear in alphabetic
order?

Thank you in advance!
 
D

Debra Dalgleish

Right-click on the field button
Choose Field Settings
Click Advanced
Under AutoSort options, choose Ascending.
Click OK, OK
 
G

Guest

Thank you very much!

Debra Dalgleish said:
Right-click on the field button
Choose Field Settings
Click Advanced
Under AutoSort options, choose Ascending.
Click OK, OK
Click to expand...
 

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

Filtered drop down list 2
Pivot Table Drop Downs 3
Excel Formatting in Drop Down Lists 2
How to refresh drop-down list of pivot table 3
pivot table - drop down filter box has 10% of items out of order 2
Pivot Table field drop-down not refreshing 1
pivot table filter 1
Reorder pivot table field lists 2

Top