Easy methods to Transfer Pivot Desk In Excel

After making a Pivot Desk, you could discover that it’s not in the precise location or you could wish to transfer it to a different worksheet. You can find beneath the steps to maneuver Pivot Desk in Excel.

Transfer Pivot Desk in Excel

As you possibly can see within the picture beneath, the Pivot Desk is ranging from Row 8 (Cell A8) with pointless empty Rows on the prime. This challenge could be simply corrected by transferring the Pivot Desk to Cell A2.

Equally, you could come throughout the necessity to transfer Pivot Desk to a brand new Worksheet inside the similar Workbook or to New Worksheet in one other Workbook.

All these duties could be simply achieved by making use of the Transfer PivotTable command as obtainable in Microsoft Excel.

1. Transfer Pivot Desk Inside the Similar Worksheet

Observe the steps beneath to maneuver Pivot Desk to a different space on the identical worksheet

1.1. Click on wherever on the Pivot Desk.

1.2. Subsequent, click on on the Analyze tab situated within the prime menu bar and click on on Transfer PivotTable possibility.

1.3. On the Transfer PivotTable dialogue field, click on within the Location field after which click on on the New location the place you wish to transfer the Pivot Desk and click on on OK.

Within the above instance, we’ve clicked in Cell A2 so as to transfer the Pivot Desk to this location.

2. Transfer Pivot Desk to New or One other Worksheet

More often than not, you could come throughout the necessity to transfer Pivot Desk to a New Worksheet. This fashion the Pivot Desk will probably be housed in its personal separate Worksheet.

2.1. Click on wherever on the Pivot Desk.

2.2. Subsequent, click on on the Analyze tab situated within the prime menu bar after which click on on Transfer PivotTable possibility.

Observe: Transfer PivotTable possibility might also be situated underneath PivotTable Choices Tab.

2.3. On the Transfer PivotTable dialogue field, choose New Worksheet possibility and click on on OK.

Excel will robotically open a brand new worksheet and the Pivot Desk will probably be moved to the New Worksheet.

3. Transfer Pivot Desk to One other Workbook

There may be actually no possibility in Excel to maneuver Pivot Desk to a different workbook. Nonetheless, it’s potential to repeat the Pivot Desk and paste it in one other workbook.

3.1. Click on wherever on the Pivot Desk.

3.2. Subsequent, click on on the Analyze tab situated in prime menu bar > click on on Choose after which click on on Total PivotTable possibility within the drop-down menu.

Observe: Chances are you’ll discover Transfer PivotTable possibility situated underneath PivotTable Choices Tab.

3.3. As soon as the Pivot Desk is chosen, right-click on it and click on on the Copy possibility.

3.4. Now navigate to the opposite Workbook > right-click on the cell at which you need the Pivot Desk to start out after which click on on Paste Particular possibility within the menu that seems.

3.5. On the Paste Particular display screen, guarantee that “All” possibility is chosen and click on on OK.

You’ll instantly see the Pivot Desk being pasted within the New Workbook. The pasted Pivot Desk ought to retain most of its formatting and you could solely be required to regulate the column widths.

• Easy methods to Change Pivot Desk Knowledge Supply and Vary
• Easy methods to Add or Take away Subtotals in Pivot Desk