• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Copying and Pasting Pivot Table as values while keeping its formatting

It can be done in two steps.

1. Copy Pivot Table and paste as values only.
2. Use format painter to copy format and paste.
 
Then do above. Delete original pivot table. And cut and paste copied range into original location.
 
You must log in or register to reply here.
Back
Top