30 Advanced Excel Tips for 2026

Excel Champs / Pivot Table / How to Move a Pivot Table in Excel
By Puneet Gogia (Microsoft MVP)

How to Move a Pivot Table in Excel

30+ Advanced Excel Tips for 2026

No spam. Only Excel Stuff. God Promise. 😊

Click any cell in the pivot table and go to PivotTable Analyze → Actions → Move PivotTable. In older versions the tab is called Analyze or Options.

In the dialog, choose New Worksheet to put the pivot on a fresh sheet, or choose Existing Worksheet and click the cell where its top-left corner should go, on the same sheet or another one. Click OK.

To move it from the keyboard instead, select the whole pivot with PivotTable Analyze → Actions → Select → Entire PivotTable, press Ctrl + X, click the new cell and press Ctrl + V. Selecting it this way brings any report filters above the table with it, which clicking inside and pressing Ctrl + A can miss.

To move it to another workbook, select the entire pivot the same way, press Ctrl + C, paste it into the other workbook with Ctrl + V, then go back, select the original and press Delete. The copy still reads its data from the first workbook, so if you are moving the data too, point the copy at it with PivotTable Analyze → Change Data Source.

If Excel warns that a PivotTable report cannot overlap another PivotTable report, or that the destination already holds data, pick a cell with more empty rows and columns around it. Leave room for the pivot to grow, because a refresh that adds new items needs that space.

Pivot tables are one of the best ways to create reports quickly. The best part is that you can move a pivot table from one section to another, a new worksheet, or even a new workbook.

Two Ways to Move a Pivot Table

  • New Worksheet: Select this option if you want to move your pivot to a new worksheet. Excel will automatically create a new worksheet and move the pivot.
  • Existing Worksheet: This option will help you move the pivot to one of the existing worksheets in the workbook. Once you select this option, all you need to do is select the cell where you need your pivot table.
Move a Pivot Table | Quick Excel Tips

Steps to Move a Pivot Table to an Existing Worksheet

  • Click on any cell within the pivot table to activate Excel’s pivot table tools. This will add the “PivotTable Analyze” tab to the Excel ribbon (it’s called “Analyze” in Excel 2013 to 2019 and “Options” in Excel 2010).
  • Navigate to the “PivotTable Analyze” tab on the Excel ribbon. This tab is dedicated to functions related to pivot tables and only appears when a cell inside a pivot table is selected.
  • Within the “PivotTable Analyze” tab, locate and click on the “Move PivotTable” command. You will find it in the “Actions” group.
  • A dialog box will open after you click on the “Move PivotTable” command. This dialog box allows you to select the location where you want to move the pivot table.
  • In the dialog box, identify and select the target sheet where you want to relocate your pivot table. If you move the pivot table to a new location within the same worksheet, you can specify the cell in the top-left corner of the new location for the pivot table.
  • Once you’ve chosen the new location for your pivot table, confirm your choice by clicking “OK” in the dialog box. Excel will then move the pivot table to the location you have chosen.

Steps to Move a Pivot Table to a New Worksheet

If you need to move a Pivot Table in Excel, you can easily do so by following the steps outlined below.

  1. Select any cell in the pivot table, look at the ribbon tabs and click on 'PivotTable Analyze' (or 'Analyze', depending on the version of Excel you're using). These tabs house the controls for modifying Pivot Tables.
  2. Within the 'Actions' group of buttons, find and click on the 'Move PivotTable' button. This will open a dialog box.
    under-analyze-tab-click-move-pivot-table
  3. The Move PivotTable dialog box provides the options to move the PivotTable to a 'New worksheet' or an 'Existing worksheet'. When you choose 'Existing worksheet', you will also need to specify the location on the worksheet where you want to place the PivotTable.
  4. Now, in the dialog box, select 'New Worksheet' and click OK. Excel adds a new worksheet and moves the pivot table there.
    move-pivot-table-dialogue-box

Once you’ve moved the PivotTable, be sure to save your changes. This will ensure that the new location of the pivot table is preserved.

Important Note: Moving a pivot table to a new worksheet or workbook doesn’t move the data source. And that’s why you need to ensure you won’t break that connection between the source data and the pivot table.

Use Keyboard Shortcut to Move a Pivot Table

You can easily do this by selecting the entire pivot table, cutting it (Ctrl+X), and then pasting it (Ctrl+V) in the desired location in your Excel worksheet.

  • Select the Pivot Table: The keyboard shortcut Ctrl + A allows you to select a pivot table entirely. Before using this shortcut, select a cell in the pivot table and then use the shortcut. If your pivot table has report filters above it, use PivotTable Analyze → Actions → Select → Entire PivotTable instead, as Ctrl + A can leave them out.
  • Cut the Pivot Table: Once the pivot table is selected entirely, you can use Ctrl + X to cut it from its current position.
  • Paste the Pivot: The last thing to do is paste the pivot table into the new place. This could be in an existing sheet, a new worksheet, or a different workbook.

Move a Pivot Table to a Different Workbook

The best way to move a pivot table to a different workbook is by using the keyboard shortcuts we have discussed in the above method:

  1. Open Both Workbooks: Begin by opening the workbook that currently houses the pivot table (source workbook) and the workbook to which you wish to move the pivot table (destination workbook).
  2. Select the Entire Pivot Table in the Source Workbook: Navigate to the source workbook and ensure you select the entire pivot table, including all rows and columns.
  3. Copy the Pivot Table: Once you have selected the entire pivot table, copy it by pressing Ctrl+C.
  4. Switch to the Destination Workbook: Now move over to the destination workbook. It’s important to consider where you want to place the pivot table in this workbook.
  5. Paste the Pivot Table: Once you’ve chosen a suitable location in the destination workbook, paste the pivot table by pressing Ctrl+V.

This creates a copy, so delete the pivot table from the source workbook once you’ve checked the new one. Also, the pasted pivot table still uses the data in the source workbook. If you want it to use data in the new workbook, move the data as well and update the source with PivotTable Analyze → Change Data Source.

When you are working with pivot tables in Excel and need to move them, there are a few things you should take care of:

  • Select the Full Pivot Table Before Moving: Before cutting or copying your pivot table, ensure you have selected the entire table. This includes all rows, columns, and any report filters. If you select only a part of it, Excel shows a message that you can’t change that part of a PivotTable report.
  • Check All Related Formulas or Links: Pivot tables often have connected formulas or links that automatically update based on the data within the table. When you move a pivot table, these connections may need to be adjusted or updated. After moving your pivot table, double-check all related formulas or links to ensure they still function correctly.
  • Leave Enough Space: If the new location has data in the way, Excel asks if you want to replace the contents of the destination cells, and if it would overlap another pivot table, it shows the “A PivotTable report cannot overlap another PivotTable report” message. Pick an empty area with room for the pivot table to grow.

Move a Pivot Table with VBA

If you move pivot tables often, you can do it with a macro. The PivotTable object has a Location property that you can set to the new top-left cell. The following code moves the first pivot table on the active sheet to cell A3 of “Sheet2”:

Sub move_pivot_table()
Dim pt As PivotTable
Set pt = ActiveSheet.PivotTables(1)
pt.Location = "'Sheet2'!$A$3"
End Sub

Frequently Asked Questions

Does moving a pivot table change its data?

No. Only the location of the report changes. The source data, the fields and the formatting stay the same.

Why is Move PivotTable greyed out?

Usually because the sheet or the workbook structure is protected, or because the selected cell isn’t inside a pivot table. Unprotect the sheet and select a cell in the pivot table first.

Will my pivot chart move with the pivot table?

No. A pivot chart stays where it is and keeps working with the pivot table at its new location. Cut and paste the chart if you want it next to the pivot table.