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!

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

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.

Voila! You have successfully moved your Pivot Table!

Helpful Resource:

If you like this Excel tip, please share it

email

### Related Posts

Sort an Item Row (Left to Right) With Excel Pivot ... I knew that I could sort virtually anywhere with Excel Pivot Tables, but I was surprised that I could even sort any row from left to right!!Below I have an Excel Pivot Table that consists of Sales Numbers over a three year period.Make sure to download the Excel Workbook b...
Show The Percent of Column Total With Excel Pivot ... 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 COLUMN TOTAL calculation.This option will immediately calculate the percentages for you from a table filled with numbers such as sales data, ...
Group By Custom Dates With Excel Pivot Tables In my previous Group By Month post, we grouped our Sales by each month.However the cool thing with Excel is that we can take that a step further and customize our grouped date range!In the example below I show you how to get the Sales Grouped by Custom Dates:  ...
Group Sales by Weeks With Excel Pivot Tables I am sure that your boss has asked you to come up with Total Sales numbers per week at least once in your current role!  If not, he will....very very soon!Now your data has only sales for each individual day, which makes you scramble to come up with a solution.   How will you...