excel 2007 pivot table: how to paste special formats?

  • Thread starter Thread starter excelgeek
  • Start date Start date
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!
 
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
Formats-Paste special 1
Paste Special Values 2
I can't copy and paste equations 0
I want Paste Special (not Paste Link) 2
Is Paste Special HTML broken in Excel/Office 2007? 1
Paste Special Formula Multiply feature doesn't work anymore 2
date 2

Back
Top