Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Layout
I have created a pivot table and wish to change the layout of rows and data
w/o recreating the table. Can I use the Pivot Table toolbar or another means to accomplish this? If so, how is this done? Thank you in advance for your assistance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Layout
Sure. There are a number of ways, but the simplest IMO is to grab a field in
the page fields, row fields or column fields, and drag it into one of the other areas of the PT. -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "SJT" wrote in message ... I have created a pivot table and wish to change the layout of rows and data w/o recreating the table. Can I use the Pivot Table toolbar or another means to accomplish this? If so, how is this done? Thank you in advance for your assistance. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Layout
And if you really get confused, rightclick on the pivottable and choose
Pivottable Wizard. Then hit the Layout button and change the layout. And finish up the wizard. ===== Ps. Save the workbook the way you like. Then do your experiments. It's really easy to screw up a nice layout. And it's nice to just close without saving and reopen the saved workbook. SJT wrote: I have created a pivot table and wish to change the layout of rows and data w/o recreating the table. Can I use the Pivot Table toolbar or another means to accomplish this? If so, how is this done? Thank you in advance for your assistance. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom field in Pivot Table? | Excel Discussion (Misc queries) | |||
Top 5 plus Other in Pivot table | Excel Worksheet Functions | |||
Insert a row after a pivot table | Excel Discussion (Misc queries) | |||
Change Data In Pivot Table | New Users to Excel | |||
Pivot Table Problems | Excel Discussion (Misc queries) |