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

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Show The Percent of Parent Row Total With Excel Pi... 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 ROW TOTAL calculation. This is a new calculation in Excel 2010 and onwards. This option will immediately calculate the percentages f...
Use An External Data Source To Import Data Into An... When creating an Excel Pivot Table, what happens if your data source is in another location? Would you have to copy your data into the same spreadsheet? Well, NO!  You can simply use the External Data Sources feature in your Pivot Table and Excel will magically import the d...
Show The Percent of Difference From Previous Years...   I am sure that your boss has asked you to come up with a Year on Year variance report at some stage.  There are a couple of ways to get him/her an answer. One is using Formulas, but that will take time to set up and you are exposed to errors! The other method is t...
Group By Half Years With Excel Pivot Tables   In our previous post, we were able to Group by Month using Pivot Tables.  Let us take it up another notch, and group it by Half Years! In the example below I show you how to get the Sales Grouped by Half Years: January to June and July to December   DOWNL...