Pivot Table Layout

S

SJT

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.
 
B

Bob Phillips

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)
 
D

Dave Peterson

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.
 
Top