As a busy professional, you often don’t have time to waste when it comes to data analysis.
That’s where Pivot Tables come in handy. With just a few clicks, you can quickly summarize large data sets and draw insightful conclusions.
However, Pivot Tables can also create clutter in your workbook if you’re not careful.
To keep your workbook clean and organized, it’s important to know how to move Pivot Tables around.
If you have multiple Pivot Tables in a single worksheet, you can arrange them side by side or even move them to a new worksheet entirely.
By taking the time to tidy up your workbook, you’ll be able to work more efficiently and effectively with your data.
In this tutorial, I will show you how to quickly move your Pivot Table to another worksheet in the same workbook, or move your Pivot Table to another Excel workbook altogether.
Move Pivot Table to an Existing Worksheet
In this section, I will show you how you can move a Pivot Table to an existing worksheet in the same workbook.
By existing worksheet, I mean to say all the worksheets that are open in your currently active workbook.
Using this method you can move your Pivot Table to any of the worksheets in your active workbook.
To show the method I used a sales-related dataset as shown in the screenshot.
Using the above data set, I have generated a Pivot Table that shows sales done by all representatives in different regions.
Below are the steps to move this Pivot Table to an existing worksheet in the workbook:
- Select any cell inside the Pivot Table
- Click on the PivotTable Analyze tab in the ribbon. This is the contextual tab and would only appear when you select any cell inside the Pivot Table
- In the ‘Actions’ section, click on the Move PivotTable option
- This will open the Move PivotTable dialog box
- Here we want to move the Pivot Table in the existing worksheet so select the Existing Worksheet radio button.
- Click inside the Location input box and specify the cell location where you want to move the Pivot Table by highlighting the cell. In this case, I am going to highlight cell A1 in the active sheet. You can choose any cell in any of the existing worksheets.
- Click OK
This will move the Pivot Table to the desired location. Similarly using this option you can move Pivot Table to any Existing worksheet.
Note: In the above steps I’ve shown you how to move a Pivot Table in one of the existing worksheets in the current workbook. you can also use the same steps to move the pivot table twin already opened workbook as well. To do that, follow steps 1 to 5 as is, and then in step 6, select a cell in the workbook to which you want to move the pivot table
Also read: How to Lock a Pivot Table in Excel
Move Pivot Table to a New Worksheet
There is another option available in Excel using which you can move the Pivotal Table to a new worksheet.
When using that option, Excel will create a completely new worksheet and then move the Pivot Table to this brand-new worksheet.
Below is an example explaining the method.
For demonstration purposes, I used the same data set as in Method 1.
Based on the above data set I generated a Pivot Table inside the same worksheet where the data set is present, which is “sheet1” in my case.
Now follow the below-mentioned steps to move Pivot Table to a new worksheet
- Select any cell inside the Pivot Table
- Click on the PivotTable Analyze tab in the ribbon. This is the contextual tab and would only appear when you select any cell inside the Pivot Table
- In the Actions section click on the Move PivotTable option
- This will open the Move PivotTable dialog box
- Here we want to move the Pivot Table in the new worksheet so select the New Worksheet radio button.
- Click on OK.
This will create a new worksheet and move the Pivot Table to that sheet which is “sheet2” in our case. The result is shown in the screenshot.
In this tutorial, I showed you how you can quickly move the Pivot Table in Excel.
Excel allows you to move a Pivot Table to an existing worksheet, or insert a new worksheet and then move the Pivot Table to this newly inserted worksheet.
You can also move your pivot table to another workbook as well.
Other Excel articles you may also like:
- How to Sort a Pivot Table in Excel
- How to Refresh Pivot Table in Excel? (Shortcut + VBA)
- How to Delete a Pivot Table? 4 Different Ways!
- How to Group by Months in Excel Pivot Table?
- Remove Grand Total From Pivot Table in Excel
- Pivot Table Field Name is Not Valid – How to Fix?
- How to Copy a Pivot Table in Excel?