How to Copy a Pivot Table to Another Worksheet

By James Highland

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.

Copy the Worksheet

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.

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.

Copy the Pivot Table

Step 1

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

Step 2

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

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.

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.