| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table drop downs
When setting up a pivot table i have a field 'names' which I have placed in
the 'Drop Page Fields Here' so that I can print the rest of the table for each individual. However when I select the drop down it offers me all the names in random order. This would be ok with up to 10 names but is very time consuming when there re a couple of hudred names. Is it possible to put the drop downinto alphabetical order? -- Tony |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| reading into pivot table drop downs | Excel Discussion (Misc queries) | |||
| Vlookup using drop downs and table | Excel Worksheet Functions | |||
| Can Pivot table drop-downs act like AutoFilter | Excel Discussion (Misc queries) | |||
| drop downs | Excel Discussion (Misc queries) | |||
| Cross-referenced drop-down menu (nested drop-downs?) | Excel Worksheet Functions | |||
Threaded Mode
