• Skip to main content
  • Skip to primary sidebar

Techbout

Technology Simplified.

  • Windows
  • iOS
  • Mac
  • Android
  • Office
Home » Office » How to Move Pivot Table In Excel

How to Move Pivot Table In Excel

By: Waseem Patwegar

After creating a Pivot Table, you may find that it is not in the right location or you may want to move it to another worksheet. You will find below the steps to move Pivot Table in Excel.

Move Pivot Table In Excel

Move Pivot Table in Excel

As you can see in the image below, the Pivot Table is starting from Row 8 (Cell A8) with unnecessary empty Rows at the top. This issue can be easily corrected by moving the Pivot Table to Cell A2.

Pivot Table in Incorrect Location

Similarly, you may come across the need to move Pivot Table to a new Worksheet within the same Workbook or to New Worksheet in another Workbook.

All these tasks can be easily achieved by making use of the Move PivotTable command as available in Microsoft Excel.

1. Move Pivot Table Within the Same Worksheet

Follow the steps below to move Pivot Table to another area on the same worksheet

1.1. Click anywhere on the Pivot Table.

1.2. Next, click on the Analyze tab located in the top menu bar and click on Move PivotTable option.

Move PivotTable Option in Excel

1.3. On the Move PivotTable dialogue box, click in the Location box and then click on the New location where you want to move the Pivot Table and click on OK.

Move PivotTable to Another Location in Same Worksheet

In the above example, we have clicked in Cell A2 in order to move the Pivot Table to this location.

2. Move Pivot Table to New or Another Worksheet

Most of the time, you may come across the need to move Pivot Table to a New Worksheet. This way the Pivot Table will be housed in its own separate Worksheet.

2.1. Click anywhere on the Pivot Table.

2.2. Next, click on the Analyze tab located in the top menu bar and then click on Move PivotTable option.

Move PivotTable Option in Excel

Note: Move PivotTable option may also be located under PivotTable Options Tab.

2.3. On the Move PivotTable dialogue box, select New Worksheet option and click on OK.

Move Pivot Table to New Worksheet

Excel will automatically open a new worksheet and the Pivot Table will be moved to the New Worksheet.

3. Move Pivot Table to Another Workbook

There is really no option in Excel to move Pivot Table to another workbook. However, it is possible to copy the Pivot Table and paste it in another workbook.

3.1. Click anywhere on the Pivot Table.

3.2. Next, click on the Analyze tab located in top menu bar > click on Select and then click on Entire PivotTable option in the drop-down menu.

Select Entire Pivot Table

Note: You may find Move PivotTable option located under PivotTable Options Tab.

3.3. Once the Pivot Table is selected, right-click on it and click on the Copy option.

Copy Pivot Table to Clipboard

3.4. Now navigate to the other Workbook > right-click on the cell at which you want the Pivot Table to start and then click on Paste Special option in the menu that appears.

Paste Special Option in Excel

3.5. On the Paste Special screen, make sure that “All” option is selected and click on OK.

Paste Special Dialog Box in Excel

You will immediately see the Pivot Table being pasted in the New Workbook. The pasted Pivot Table should retain most of its formatting and you may only be required to adjust the column widths.

Related
  • How to Change Pivot Table Data Source and Range
  • How to Add or Remove Subtotals in Pivot Table

You May Also Like
    • Prevent Outlook From Adding Calendar Events
      How to Prevent Outlook From Adding Calendar Events
      • Show Developer Tab in Excel Ribbon Menu
        Add or Show Developer Tab in Excel Ribbon Menu
        • Set Out of Office Message in Microsoft Teams
          How to Set Out of Office Message in Microsoft Teams

Primary Sidebar



Gadget Guide

  • Should You Buy MacBook or Windows Laptop
  • Chromebook vs Windows Laptop
  • 12 Reasons to Switch to Chromebook
  • Kindle E-Reader Comparison
  • Best Asus Laptops Under 500




About | Privacy Policy | Disclosure | Terms | Contact
© 2023 Techbout.com · All Rights Reserved