| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
changing column order in pivot tables?
You can manually rearrange the columns, if manual sort is on. Or, create
a custom list, and the pivot table will sort in that order: Type the list on the worksheet Select the list Choose ToolsOptions Select the Custom List tab Click the Import button Click OK plato wrote: Is it possible to change the column order in pivot tables or do I need to change the column names of the raw data into alphabetical or numerical order and then change them back? plato -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing column order in pivot table | Excel Discussion (Misc queries) | |||
| Pivot Tables -changing datasource for exsting Pivot Table | Setting up and Configuration of Excel | |||
| Using Order in Excel Pivot Tables | Excel Worksheet Functions | |||
| I have two identical pivot tables with different sort order of th. | Excel Discussion (Misc queries) | |||
| Can you reformat order of items in Pivot Tables after refresh? | Excel Discussion (Misc queries) | |||
Linear Mode
