| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table - Column Drop Down Lists...
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table - Column Drop Down Lists...
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 |
|
#3
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table -- Refresh Data in Field Dropdown Lists | Excel Discussion (Misc queries) | |||
| The Pivot Table Field Lists Do not Display | Excel Discussion (Misc queries) | |||
| Pivot tables and drop-down lists | New Users to Excel | |||
| Internet explorer is very slow in opening Excel Pivot Table lists | Excel Discussion (Misc queries) | |||
| 2 column drop down lists | Excel Discussion (Misc queries) | |||
Hybrid Mode
