| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot tables - page section
If I have a data element in my page section of a pivot table and this data
element has various options in the drop down I want to always have them in alphabetical order. Is there a macro to do so? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pivot tables - page section
Double-click the page field button
Click the Advanced button Under AutoSort options, choose Ascending, click OK, click OK Jeliazkov wrote: If I have a data element in my page section of a pivot table and this data element has various options in the drop down I want to always have them in alphabetical order. Is there a macro to do so? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I remove old labels from refreshed pivot tables? | Excel Discussion (Misc queries) | |||
| Excel 97 Question (Pivot tables) | Excel Discussion (Misc queries) | |||
| Multiple Pivot Tables with single Page Field | Excel Discussion (Misc queries) | |||
| Macro for Pivot Tables | Excel Discussion (Misc queries) | |||
| Product Function in Pivot Tables from Multiple Consolidation Range | Excel Worksheet Functions | |||
Linear Mode
