Pivot tables are very easy to create and even easier to move to some other worksheet or a new worksheet in the same Excel workbook.
Many Excel users often end up creating multiple Pivot tables in the same worksheet, which is not a very organized way of doing things.
But thanks to a readily available in-built option in Excel, you can move your existing Pivot table from the current worksheet to a different worksheet with a few clicks.
In this short tutorial, I will show you the best ways to quickly move a Pivot table in Excel.
This Tutorial Covers:
ToggleMove a Pivot Table to an Existing Worksheet
Below are the steps to move your Pivot table to an existing worksheet in the Excel workbook:
- Select any cell in the Pivot Table
- Click on the ‘PivotTable Analyze’ tab
- In the Actions group, click on the ‘Move PivotTable’ option
- In the ‘Move Pivot Table’ dialog box that opens up, make sure the ‘Existing Worksheet’ option is selected
- Specify the location where you want the Pivot Table to be moved. You can use your cursor to navigate to the sheet and select the cell where you want the Pivot table to be moved
- Click the OK button
The above steps would instantly move your Pivot table to the specified location.
When you move up the Pivot Table, it is removed from the original location and moved to the specified destination location, so you end up with only one copy of the Pivot Table
Note that the location where you are moving your Pivot Table should be empty and there shouldn’t be any cells that already have some data. In case the cells are not empty, you will see a prompt as shown below:
Pro Tip: The keyboard shortcut to open the Move Pivot Table dialog box is ALT + J + T + V. You need to press these keys in succession (one after the other). Also, make sure you have selected any cell in the Pivot Table that you want to move before using this shortcut
Move a Pivot Table to a New Worksheet
Another useful option is to move your existing Pivot table to a new worksheet in the same Excel workbook.
When you use this option, a new worksheet is inserted, and your Pivot table is moved to this newly inserted worksheet.
Below are the steps to move a Pivot table to a new worksheet in the same Excel Workbook:
- Select any cell in the Pivot Table
- Click on the PivotTable Analyze tab
- In the Actions group, click on the Move PivotTable option
- In the ‘Move Pivot Table’ dialog box, select the ‘New Worksheet’ option
- Click the OK button
Can You Move Pivot Table to Another Workbook?
Yes, you can.
Just like you can move a Pivot table to another worksheet by specifying the destination location, you can also move it to another workbook by specifying the location of a cell in that workbook.
Below are the steps to move a Pivot table to another Excel workbook:
- Select any cell in the Pivot Table
- Click on the PivotTable Analyze tab
- In the Actions group, click on the Move PivotTable option
- Select the ‘Existing Worksheet’ option
- Specify the location of the workbook in which you want to move this Pivot Table. It’s best to open that workbook and use your mouse cursor to click the cell in the workbook so that it automatically picks up the location
- Click the OK button
The above steps would move the Pivot Table from the existing workbook to the specified workbook.
One important thing you need to remember when moving a Pivot Table from one workbook to another is that the source data remains in the original workbook and the Pivot table moves to the other destination workbook.
This link needs to be maintained for this Pivot Table to function properly. So make sure that you do not change the name of the file or delete or move that file that has the original data from which the Pivot Table was created.
In case that file is deleted or renamed, the link would be broken and your Pivot Table would stop working.
Note: While I have only covered how to move a Pivot table to another sheet or workbook in this tutorial, you can use the same process to move a Pivot Chart as well. When you click on a pivot chart, you will see the PivotChart Analyze tab, and there would be a Move Chart option in it
In this tutorial, I showed you how to easily move a pivot table to an existing worksheet in the workbook, to a new worksheet, or to an entirely different workbook.
I hope you found this excel tutorial helpful.
Other Excel tutorials you may also like:
- How to Move Chart to New Sheet in Excel? 2 Easy Ways!
- How to Delete a Pivot Table in Excel
- Preparing Source Data For Pivot Table
- Using Slicers in Excel Pivot Table – A Beginner’s Guide
- How to Move Rows and Columns in Excel (The Best and Fastest Way)
- How to Refresh Pivot Table in Excel (Manually + Auto-Refresh with VBA)
- How to Add and Use an Excel Pivot Table Calculated Field
- How to Show Pivot Table Fields? (Get Pivot Table Menu Back)