Forum Discussion
EXCEL PIVOT TABLES
I often take a Pivot Table and send it out to individuals as a report. I like to send only values in my report so I often copy the P.T. and Paste Value the results. This action means that the forma...
Theo_Bear if the entire pivot table is included in the selection, paste formats does not paste the formatting. That is the problem we're trying to solve!
First, select and copy the entire pivot table. You can use Control + A to select the whole table.
Next, in a new worksheet, use Paste Special, then Values. This will strip away all formatting and leave you with just the data.
With the pivot table still on the clipboard, use paste special again. This time, choose Formats. This will bring in all the cell and number formatting.
Finally, if you like, you can use Paste Special one more time to bring in the original column widths.
Pasting column widths is one of those quirky features that makes paste special so useful?
- Theo_Bear depends on what you select sometimes it does refuse to paste formats
