|
Posted to microsoft.public.excel.misc
|
|
|
Pivot Table - Column Drop Down Lists...
Thank you very much!
"Debra Dalgleish" wrote:
Right-click on the field button
Choose Field Settings
Click Advanced
Under AutoSort options, choose Ascending.
Click OK, OK
Steve wrote:
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!
--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html
|