How to Move Pivot Table in Excel?

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.

Data to create Pivot Table

Using the above data set, I have generated a Pivot Table that shows sales done by all representatives in different regions.

Pivot table to be moved

Below are the steps to move this Pivot Table to an existing worksheet in the workbook:

  1. Select any cell inside the Pivot Table
Select any cell in the Pivot table
  1. 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
Click on Pivot Table Analyze
  1. In the ‘Actions’ section, click on the Move PivotTable option
Click on Move PivotTable
  1. This will open the Move PivotTable dialog box
Move PivotTable dialog box
  1. Here we want to move the Pivot Table in the existing worksheet so select the Existing Worksheet radio button.
Select existing worksheet option
  1. 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.
Select cell in the destination worksheet
  1. Click OK
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.

Pivot Table moved

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.

Dataset

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.

Pivot table is in sheet1

Now follow the below-mentioned steps to move Pivot Table to a new worksheet

  1. Select any cell inside the Pivot Table
select any cell in the pivot table
  1. 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
Click on Pivot Table Analyze tab
  1. In the Actions section click on the Move PivotTable option
click on Move Pivot Table
  1. This will open the Move PivotTable dialog box
Move PivotTable dialog box
  1. Here we want to move the Pivot Table in the new worksheet so select the New Worksheet radio button. 
Click on new worksheet option
  1. 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.

Pivot table moved to new sheet

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:

I am a huge fan of Microsoft Excel and love sharing my knowledge through articles and tutorials. I work as a business analyst and use Microsoft Excel extensively in my daily tasks. My aim is to help you unleash the full potential of Excel and become a data-slaying wizard yourself.

Leave a Comment