Copy Pivot Table Format and Values

To keep your data details confidential, you might want to send someone a copy of a pivot table, without the link back to its source data. It’s easy to copy a pivot table, and paste it as values, but if you try to paste the values and source formatting, you’ll be disappointed by the results. The values are pasted, but not the PivotTable Style formatting.
pivotformatcopy02
Fortunately, John Walkenbach discovered that you can paste from the Office Clipboard, instead of using the Paste Values command, and the PivotTable Style formatting is pasted too.
pivotformatcopy04
The result is something that looks like the original pivot table, without the link to the source data.
pivotformatcopy05
For more instructions on PivotTable Styles and pivot table formatting see the Contextures Pivot Table Format page.

Watch the Pivot Table Format Copy Video

To see the steps for pasting the pivot table formatting and values, watch this short Excel tutorial video.

_____________