Can Pivot Table layout be copied???

  • Thread starter Thread starter K. Georgiadis
  • Start date Start date
K

K. Georgiadis

A few weeks ago, I ended up with the perfect Pivot Table
layout by dragging fields around -- I just don't remember
how I got there!

I have attempted to create a similar table (with new
data) but, even though the field layout buttons are in
the exact same locations, the table looks different. I'm
trying to get "Sum of 2004", "Sum of 2005," etc. as
column headings across the top instead of having all
years one below the other.

Is there any way to copy the layout from the "perfect"
table to the new one?
 
I answered my own question, with help from Debra's
excellent website!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table data layout - columns to rows 1
re-using pivot table layout 1
Pivot table - undo of a macro 1
Pivot table wizards 2
Multiple measures in MS Access pivot table-Sigma Value in Row not Column 0
Excel 2003 Pivot Table Issues 3
prevent pivot tables / charts from editing 1
Dynamic data ranges in pivot tables 3

Back
Top