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

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

Move an Excel Pivot Table

Helpful Resource:

Excel Pivot Table

 

 

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

Share on Google+

Related Posts

Sort an Excel Pivot Table Manually You have your Pivot Table ready, all sorted nicely both from a row and column perspective.  However you just need that one minor sorting tweak or two.Well, Excel seemingly has a lot of tricks and you can even sort an Excel Pivot Table manually!For our example, let's see t...
Show The Percent of Parent Column Total With Excel...  Excel Pivot Tables have a lot of useful calculations under the SHOW VALUES AS option and one that can help you a lot is the PERCENT OF PARENT COLUMN TOTAL calculation.This option will immediately calculate the percentages for you from a table filled with numbers suc...
Group By Time With Excel Pivot Tables Let's put yourself in my place for a second.It was a dark, rainy night in Dublin city and I was working overtime...again!I downloaded a report with lots of transnational data.  Time of Sale in one column and Sales in another, among other columns.I wanted to get the Sa...
Refresh All for Excel Pivot Tables When the information in your data source gets updated or changed, you need to Refresh your Pivot Table to see those changes in your Pivot Table.How about if you have multiple Pivot Tables from the same data source in the same workbook? Or;Pivot Tables that are created fro...