If you have your Excel Pivot Table ready, but it’s not in the best location, how do you move this onto another section of your Excel worksheet?

Well, you can simply select Move PivotTable and you can move your Excel Pivot Table very quickly!

For our example, let’s move this lovely Pivot Table upwards!

Move an Excel Pivot Table

Move an Excel Pivot Table | MyExcelOnline

DOWNLOAD EXCEL WORKBOOK

STEP 1: Make sure you have selected your Pivot Table. Go to Analyze/Options > Actions > Move PivotTable

Move an Excel Pivot Table

 

STEP 2: Select the new location where you want to move it.  You have the options to move the Pivot Table to a New Worksheet or Existing Worksheet.

In our example, we selected cell A4 and click OK.

Move an Excel Pivot Table

Voila! You have successfully moved your Pivot Table!

Move a Pivot Table

 

HELPFUL RESOURCES:

JOIN OUR FREE EXCEL COURSES BELOW
Click here to access these FREE Excel courses!

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn