Pivot table copy and pasteing

G

Guest

In office 2007 I am unable to copy a pivot table and "paste special" values
and formats as I could in office 2003. I want the text, borders and shading
from the pivot table to copy over but not the entire pivot table. In Excel
2003 this was done by copying and then "paste special" "values" and then
"paste special" "formats". Any clue how to do this in '07?
 
D

Debra Dalgleish

If regular worksheet cells are included in the copied range, the pivot
table formatting won't paste onto the copy.
As a workaround, you can do the following:

Copy the entire pivot table, and paste it as values.
Then, copy the body of the original pivot table, and paste it as formats
on the body of the copy.
Copy the report filters (one at a time), and paste as formats on the
report filters in the copy.
 

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

excel 2007 pivot table: how to paste special formats? 1
Hide Sheets 2
Code to add gridlines to Excel Pivot Tables 0
Pivot Table Formats 2
Pivot table wizards 2
Paste Special Values 2
any way to copy and paste values from pivot table and keepformatting? 4
Duplicating Pivot Tables 2

Top