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.
Move a Pivot Table to an Existing Worksheet
Below are the steps to move your Pivot table to an existing worksheet in the Excel workbook: 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:
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: 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)