How to Copy a Pivot Table in Excel (2 Quick Methods)

In the dataset, you will see a shop’s Sales and Profit information on random days from June to August. We will use this data to create a Pivot Table and show you how to copy it.

how to copy a pivot table

Before copying, we need to create a Pivot Table using the data.

Steps:

  • Select the range of the data (B4:D15) and go to Insert >> Pivot Table.
  • The Pivot Table window will show up.
  • Select the option where you want your Pivot Table to be created and click OK. In this case, I selected a New Worksheet so that the Pivot Table will appear in a new worksheet.

  • Drag the PivotTable Fields to the PivotTable Area.


Method 1 – Using the Copy-Paste Feature to Copy a Pivot Table 

Using Copy-Paste Feature to Copy a Pivot Table (Same or Another Sheet)

Copy the table.

Steps:

  • Select the PivotTable data and press CTRL+C to copy it.

  • Paste the Pivot Table into another sheet. This step is very important because if you paste the Pivot Table into the same sheet, the original Pivot Table won’t work, as Excel does not allow one Pivot Table to overlap another. Both Pivot Tables work perfectly if you paste them into a different sheet.

You can see that there are various Paste Options, and you should choose any of them according to your purpose.

Using Copy-Paste Feature to Copy a Pivot Table (Same or Another Sheet)

  • Paste it (press CTRL+V).

  • Both these Pivot Tables work correctly.
  • Click on the Plus (+) icon beside the month of June in the original Pivot Table. You will see the detailed Sales and Profit.

how to copy a pivot table method 1

  • Do the same operation on the copied Pivot Table. You will see the same data on the Pivot Table.


Method 2 – Applying a Clipboard to Copy a Pivot Table

Steps:

  • Select the Pivot Table and press CTRL+C.
  • Click on the marked icon on the clipboard. You will find this ribbon in the Home tab.
  • Select a cell where you want to paste the Pivot Table.
  • Click on the marked item in the Clipboard.

Applying Clipboard to Copy a Pivot Table

  • You will see the Pivot Table data pasted in the Excel worksheet.


Download the Practice Workbook


How to Copy a Pivot Table in Excel: Knowledge Hub


<<Go Back to Pivot Table in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Kawser Ahmed
Kawser Ahmed

Kawser Ahmed is a Microsoft Excel Expert, Udemy Course Instructor, Data Analyst, Finance professional, and Chief Editor of ExcelDemy. He is the founder and CEO of SOFTEKO (a software and content marketing company). He has a B.Sc in Electrical and Electronics Engineering. As a Udemy instructor, he offers 8 acclaimed Excel courses, one selected for Udemy Business. A devoted MS Excel enthusiast, Kawser has contributed over 200 articles and reviewed thousands more. His expertise extends to Data Analysis,... Read Full Bio

1 Comment

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo