excel 2007 pivot table: how to paste special formats?

E

excelgeek

In Excel 2007 - how to copy formats from pivot table? In Excel 2003, you
could have a pivot table, then copy, paste special values, and then copy,
paste special formats - I can't figure out how to paste special formats in
Excel 2007!
 
D

Debra Dalgleish

Unlike the old pivot table AutoFormats, you can't copy the pivot table
style formatting and paste it as formats on the worksheet.
 

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 copy and pasteing 2
Paste Special Values 2
Copy column, paste special formulas & number formats doesn't work 3
Paste Special not working 4
Paste Special in Excel 2003 6
I can't copy and paste equations 0
What happened to paste special in Excel 2007? 6
Pivot Table Formats 2

Top