How to Copy a Pivot Table to Another Worksheet

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.

Microsoft Excel is a spreadsheet application in which you can organize information into columns and rows. Then you can apply a Pivot Table to the data, and Excel automatically creates an entirely new spreadsheet complete with analytical calculations that summarize your data. In most cases, Excel inserts this Pivot Table into its own new worksheet. There are two simple ways to copy the Pivot Table to another worksheet inside the Excel document. This is useful if you want to format or manipulate the Pivot Table without losing its original version.

Advertisement

Copy the Worksheet

Video of the Day

Step 1

Click on the worksheet that contains the Pivot Table. You can do this easily by clicking the appropriate worksheet tab that appears at the bottom of the Excel window.

Video of the Day

Step 2

Right-click the worksheet tab again. A pop-up menu will appear. Choose the "Move or Copy" option. Another pop-up menu appears.

Step 3

Click the "Create a copy" check box. Then click once on the existing worksheet in the menu list before which you wish to place the copy of the Pivot Table.

Step 4

Press the "OK" button. Excel copies the Pivot Table to another worksheet and places the copy in the specified worksheet location.

Advertisement

Copy the Pivot Table

Step 1

Click on the worksheet that contains the Pivot Table you wish to copy.

Advertisement

Step 2

Click once on an empty cell in the upper left of the Pivot Table, just above the Pivot Table data.

Advertisement

Step 3

Drag the mouse down and to the right until you reach an empty cell on the lower right of the Pivot Table.

Step 4

Right-click on the selected Pivot Table cells and choose the "Copy" option. Alternately, press the "Ctrl" and "C" keys on your keyboard to copy the information.

Advertisement

Step 5

Click in the worksheet where you wish to place the copied Pivot Table. Press the "Ctrl" and "V" keys, or right-click and choose the "Paste" command.

Advertisement

Advertisement

references