| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table
To sort the items in the dropdown list, you can sort the field:
Double-click the field button, and click Advanced. Under AutoSort options, click on Ascending or Descending Brennan wrote: Hello, I have a pivot table and I will add data periodically and then refresh the entire table, which works. The problem exists when I use one of the pull down criteria boxes. They were alphbetized at first, but now all of the new entries from newer data just fall to the bottom of the drop down. Is there a way to have those alphabetized with each new data entry? Thanks for your help. I appreciate it. B -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
| Copying values from pivot table to cells outside pivot table | Excel Discussion (Misc queries) | |||
| Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
| Filter lines with Pivot table and non Pivot table columns | Excel Discussion (Misc queries) | |||
| Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
Threaded Mode
