Pivot Table - Column Drop Down Lists...

S

Steve

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
 
S

Steve

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...
 
Top