The simplest way to copy a pivot table depends on what you need the copy to do
A pivot table is not a regular table, so copying it works differently than copying cells. If you copy a pivot table the normal way — select all, Ctrl+C, paste — you get only the values you see on screen, and the copy loses all the pivot structure. That matters because it means you cannot rearrange the copy by dragging fields around, refresh it with new data, or edit the underlying settings.
Whether you want to keep the pivot structure or just grab the numbers depends on what you are doing next. If you need a static snapshot to put in a report or email, copying values is fine. If you need to keep working with the data as a pivot table — filtering it, changing the layout, or updating it when the source data changes — you need a different approach.
Key Takeaways
- Copying a pivot table with Ctrl+C and pasting it gives you only the visible numbers, not the pivot structure or the ability to rearrange fields.
- To keep a working pivot table, copy the entire sheet or duplicate the sheet tab instead of copying individual cells.
- In Excel, right-click the sheet tab at the bottom and select "Move or Copy" to duplicate the whole sheet with the pivot table intact.
- In Google Sheets, right-click the sheet tab and select "Duplicate" to copy the sheet and its pivot table in one step.
- If you only need the numbers for a report or email, paste as values using Paste Special (Ctrl+Shift+V in Excel, Ctrl+Shift+V in Google Sheets) to keep just the visible data without the pivot structure.
Copying a pivot table as values only (for reports and emails)
This is the fastest route if you want to send the pivot table to someone else or include it in a document where you do not need to edit it further. You are taking a snapshot of what the pivot table shows right now.
In Excel: Select the entire pivot table by clicking the top-left cell and dragging to the bottom-right, or click once inside the pivot table and press Ctrl+A. Press Ctrl+C to copy. Click the cell where you want to paste it. Press Ctrl+Shift+V to open Paste Special. Select "Values" and click OK. The result is a regular table with just the numbers — no pivot fields, no refresh button, no way to rearrange.
In Google Sheets: Select the pivot table the same way. Press Ctrl+C. Click where you want to paste. Press Ctrl+Shift+V to open Paste Special. Select "Values only" and click OK. Google Sheets will paste only the numbers you see.
This method works well when you are building a report, sending data to someone who does not use spreadsheets, or creating a clean table without the pivot interface cluttering the view.
Duplicating the sheet to keep the pivot table working
If you need the copy to remain a pivot table — so you can still filter, sort, and refresh it — do not copy the cells. Instead, copy the entire sheet that contains the pivot table. This preserves all the pivot settings and the link to the source data.
In Excel: Right-click the sheet tab at the bottom of the window (where it says "Sheet1" or the name of your sheet). Select "Move or Copy". A dialog box opens. Choose where you want the copy to go — usually "move to end" is easiest. Check the box that says "Create a copy". Click OK. Excel creates a new sheet with the same pivot table, and you can now edit each one separately.
In Google Sheets: Right-click the sheet tab at the bottom. Select "Duplicate". Google Sheets creates a copy of the entire sheet, including the pivot table, and names it automatically (usually adding a number to the original name). The copy is a fully working pivot table.
After you duplicate the sheet, both versions are independent. If you refresh the data in one pivot table, the other does not change. If you rearrange fields in one, the other stays as it was. This is useful when you want to show the same data in different layouts, or when you want to keep one version as a backup while you experiment with another.
Copying a pivot table to a different workbook or file
Moving a pivot table to a completely different Excel file or Google Sheets file requires a different step because the pivot table needs to stay connected to its source data.
In Excel: The safest approach is to copy the entire sheet, not just the pivot table. Right-click the sheet tab, select "Move or Copy", and in the dialog choose the destination workbook from the "To book" dropdown. Select "Create a copy" and click OK. Excel copies the sheet and the pivot table to the new file. If the source data is in a different file, you may need to update the data source after the copy is complete — right-click the pivot table, select "Pivot Table Options", and check the data range.
In Google Sheets: You cannot move a pivot table between files the way you can in Excel. Instead, open both files side by side. In the original file, right-click the sheet tab and select "Duplicate". Then move that duplicated sheet to the new file by right-clicking the tab, selecting "Move to", and choosing the destination file. Alternatively, copy the source data to the new file first, then create a new pivot table there based on that data.
What happens when you copy a pivot table the wrong way
If you select a pivot table, press Ctrl+C, and paste it into a new location without using Paste Special, you get a regular table with only the values that are currently visible. Any fields you have hidden do not appear. Any formatting tied to the pivot structure disappears. The refresh button vanishes. You cannot drag fields to rearrange the layout.
This is not a disaster — it is just a static copy. But it means you have lost the ability to work with the data as a pivot table. If your plan was to filter the copy or change how it is organized, you will have to rebuild it as a new pivot table from the source data instead.
The same thing happens if you copy a pivot table and paste it into a different program, like Word or Google Docs. Those programs do not understand pivot tables, so they convert it to a regular table automatically. If you need to preserve the pivot structure, keep it in a spreadsheet.
Copying just part of a pivot table
Sometimes you only want a few rows or columns from a pivot table, not the whole thing. In that case, select only the cells you need, copy them, and paste as values. This is faster than copying the entire pivot table and then deleting what you do not want.
Click the first cell you want to copy. Hold Shift and click the last cell. Press Ctrl+C. Click where you want to paste. Press Ctrl+Shift+V, select "Values", and click OK. You now have just the data you selected, as a regular table.
This method is useful when you are pulling specific numbers from a pivot table to build a smaller summary, or when you want to extract one section to share with someone else.
Refreshing a copied pivot table with new data
If you duplicated the sheet and the source data has changed, you can refresh the pivot table to pull in the new numbers. This only works if the pivot table is still connected to its source data — which it is if you duplicated the sheet or copied the entire workbook.
In Excel: Right-click anywhere inside the pivot table. Select "Refresh". Excel pulls the latest data from the source and updates the pivot table. If the source data has grown or shrunk, you may need to update the data range first — right-click the pivot table, select "Pivot Table Options", and check that the range includes all your data.
In Google Sheets: Click the pivot table. At the top, you will see a "Refresh" button (it looks like a circular arrow). Click it. Google Sheets updates the pivot table with the latest data from the source.
If you copied the pivot table as values only, there is no refresh button and no way to update it automatically. You would have to copy and paste the new numbers manually.
Frequently Asked Questions
Can I copy a pivot table from Excel to Google Sheets?
You can copy the values, but not the pivot structure. Copy the pivot table as values (using Paste Special), paste it into Google Sheets, and it will be a regular table. To have a working pivot table in Google Sheets, you need to create a new one from the source data in Google Sheets itself.
What if I copy a pivot table and the numbers look wrong?
You probably copied it as values and some rows or columns were hidden in the original pivot table. Hidden data does not copy. Go back to the original pivot table, unhide all fields and rows, then copy again. Or rebuild the pivot table in the new location with the same settings.
Does duplicating a sheet use more storage?
Yes, duplicating a sheet doubles the storage used by that data. In Google Sheets, this counts toward your account storage limit. In Excel, it increases the file size. If storage is tight, copy as values instead, which uses less space because it is just numbers, not formulas or pivot structure.
Can I copy a pivot table and keep it connected to a different source data range?
Yes, but you have to change the data source after you copy. Right-click the pivot table, select "Pivot Table Options" (Excel) or edit the pivot table (Google Sheets), and update the data range to point to the new source. The pivot table will then refresh from the new data.
What is the fastest way to copy a pivot table to multiple sheets?
Duplicate the sheet once, then duplicate the duplicate. Each copy is independent, so you can edit them separately. This is faster than copying the pivot table cells multiple times, and it preserves the pivot structure in each copy.