Moving Pivot table in Excel Report

Moving Pivot table in Excel Report

With Pivot Table there is no direct option to move Pivot Table anywhere in the Excel Sheet

So below are the steps to move a Pivot Table in Different Location or another Sheet.

Click your Pivot table
-Pivot Table tools will appear in the Menu bar (Note this option comes only when you click anywhere in the pivot table)
-Options

-MovePivotTable

-New Worksheet(If you want to move your pivot table in new sheet)

-Existing Sheet(If you want to move your pivot table in same sheet but in different location)

-Location(it displays current location of pivot table Change to anyother location in same sheet)

=Sheet4!C7(c7 is the cell no. and 4 is the sheet number)
ok

Screenshot of Moving Pivot table

Note: With Pivot chart  we have direct option to  select the pivot chart and Drag it to any location we want.