| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table field selection order
Hi Herbert,
Great solution! I was interested to know how you access the PT Wizard in 2007 ?? While looking for it, I found the answer tomy own question. In PivotTable Tools Ribbon under the Options Tab in the PivotTable section where the PivotTable name is there is an Options tab. Click this, select Options and then the Display Tab. At the bottom is a Field List option that sorts the Source Data as you like it. Thanks for the steer though!! Good tip for the future! Best regards, Bony "Herbert Seidenberg" wrote: Excel 2007 Pivot Table See comparison of the two types of PTs. http://www.mediafire.com/file/yw4tjlmumzi/06_10_09.xlsx |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table field selection order
Excel 2007
ALT+D+P or Customize Quick Access Toolbar PivotTable and PivotChart Wizard |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table field selection order
Thanks again :)
"Herbert Seidenberg" wrote: Excel 2007 ALT+D+P or Customize Quick Access Toolbar PivotTable and PivotChart Wizard |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Synchronize the Pivot table page field selection in 2 tables? | Excel Worksheet Functions | |||
| Pivot Table field list order | Excel Discussion (Misc queries) | |||
| Pivot table row field order | Excel Discussion (Misc queries) | |||
| Selection of multiple values for pivot table field | Excel Discussion (Misc queries) | |||
| Pivot Table Ascending Order of Row Field | Excel Discussion (Misc queries) | |||
![Bony Pony[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
