Copy Pivot Table Format And Values - Contextures Blog

Trang chủ » Cách Copy Bảng Pivottable » Copy Pivot Table Format And Values - Contextures Blog

Có thể bạn quan tâm

Skip to content 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 it is difficult to copy pivot table format and values.

No Formatting

After you copy a pivot table, 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

Use the Clipboard

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 information on PivotTable Styles and pivot table formatting see the Contextures Pivot Table Format page.

Copy Pivot Table Format and Values Video

To see the steps to copy pivot table format and values, watch this short Excel tutorial video.

_____________

27 thoughts on “Copy Pivot Table Format and Values”

Comments navigation

Older comments

  1. what i found is if i just copy the data and disregard the top 3 rows (headings) that it will copy and i can paste the actual data and then i can go back and copy the 3 rows of heading and paste them – that works

    Reply

Comments navigation

Older comments

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Comment *

Name *

Email *

Website

Δ

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Post navigation

Previous post: Split Prize Money for Tied RANK in Excel Next post: Highlight Winning Lottery Numbers in Excel

© 2025 Contextures Inc.

About Contextures

Excel Tutorials

Policies

Blog RSS Feed

Search for: Search
  • Contextures Excel Tips
  • Debra's Blog
  • Pivot Table Blog
  • Spreadsheet Day Blog

As an Amazon Associate I earn from qualifying purchases

Từ khóa » Cách Copy Bảng Pivottable