How to Move a Pivot Table in Excel? 4 Easy Ways

• Facebook
• Twitter
• YouTube

(Note: This guide on how to move a Pivot Table in Excel is suitable for all Excel versions including Office 365)

Imagine you are working with a large amount of data. In such cases, using a pivot table in Excel greatly helps you organize, search for, and retrieve the content. 

What if there was a data summarization tool that helps users quickly evaluate large amounts of data in a detailed fashion without any difficulty?

Pivot Table is one such Excel tool that has changed how people perform data analysis conventionally. 

In this article, you will learn how to move a Pivot Table in Excel.

You’ll learn:

• What are Pivot Tables in Excel?
• Different Ways to Move Pivot Tables in Excel
• How to move a Pivot Table in Excel? (With an Example)
• Using the Move Table Option Under Pivot Table Analyze
  • Within the Same Worksheet
  • To a New Worksheet
• Using the Keyboard Shortcuts

Related reads:

GETTING TO GRIPS WITH PIVOTTABLES IN EXCEL (1-HOUR RECORDED WEBINAR)

DASHBOARDS IN EXCEL USING PIVOT TABLES, PIVOT CHARTS AND SLICERS

How to Move Chart to New Sheet in Excel? 2 Easy Ways

What Are Pivot Tables In Excel?

Before we learn how to move a Pivot Table in Excel, let’s quickly understand the concept and the importance of pivot tables. 

1. Minimizes large amounts of data and summarizes the values in a strong simplified format.
2. It gives the flexibility to compare values within the data assigned in the table.
3. It can be used to view the summarized output in the form of charts for professional and official purposes.
4. It is easy to learn, create, modify, and perform data analysis, even for a beginner having basic Excel knowledge.

Different Ways To Move A Pivot Table In Excel

Sometimes, the Pivot table must be adjacent to the original data, and in other cases, it should be completely out of sight as it is only for your reference. 

In any given case, it is possible to move the Pivot table in Excel anywhere you want.

Let us look at the different ways to move Pivot Tables in Excel,

• Using the Move Table option from Pivot Table Analyze
• Using the Keyboard Shortcuts

How To Move A Pivot Table In Excel? (With An Example)

Now, let us consider the following data as an example, create a Pivot table and use it to move it.

Creating a Pivot Table is simple: select the range of data you want to view in Pivot Table and click on Insert > Pivot Table.

Using the Move Table Option Under Pivot Table Analyze

The Move table option under the Pivot Table Analyze Tab allows you to perform the following actions: 

1. Move the table within the Existing Worksheet
2. Move the table to a new Worksheet

Within the Same Worksheet

In this instance, let’s assume the Pivot table needs to be moved close to the original data under analysis.

• If you want to analyze the whole sheet, select the entire cell range containing data or select the necessary data you want to evaluate using the Pivot Table.

• To move the Pivot table, click on any value inside the Table and go to the Pivot Table Analyze tab > click on Move Pivot Table.
• The Move table dialog box opens at once with options suggesting the location where you want to move the Pivot table.

• Once you click on the Move table, you can either move the table to a New Worksheet or Existing Worksheet. In this case, the table is initially in the J8 cell position.
• While choosing to move within the same worksheet, you need to specify the location where you want to move the table.

• You can click on the location bar and select any cell on the worksheet using the mouse or arrow keys. Note that the destination of the table must not contain any data, as an error pop-up message will appear in such cases.
• You can also manually enter the cell address using the following format

Sheet(No.)!$(column)$(row)  {say – Sheet1!$P$20}

• Click OK to move the table to the specified location.

Suggested reads:

How to Remove Spaces in Excel? 3 Easy Methods

How to Indent in Excel? 3 Easy Methods

How to Insert a New Worksheet in Excel? 5 Easy Ways

To a New Worksheet

If you don’t want to alter the existing worksheet, you can use the following steps to move your table to a new worksheet.

• The same procedure applies, except at the end, where you have to select move to a New Worksheet option from the dialog box and hit OK.

Using the Keyboard Shortcuts

Till now, we saw how to move a Pivot table in Excel using the Pivot Table Analyze tab. I know we all agree that operating data can be fun and time-saving by knowing keyboard shortcuts. 

• The Pivot table can also be moved using the keyboard shortcuts 

Ctrl+X [to cut] & Ctrl+V [to paste]

• Select the Pivot table by dragging the mouse across the entire Pivot table or by selecting the cells holding the Shift key.
• Press Ctrl+X to cut the table from the initial position, go to the cell where you want to move the table, and press Ctrl+V to paste the table in the final location.

Also, read:

How to Use Icon Sets in Excel? A Step-by-Step Guide

How to Change Row Height in Excel? 5 Easy Ways

How to Use Cell Styles in Excel: A Step-by-Step Guide

FREQUENTLY ASKED QUESTIONS

CLOSING THOUGHTS

In this article, we saw how to move a Pivot table in Excel using the Analyze tab and keyboard shortcuts. Never leave a worksheet untidy ever again. Summarize your worksheet using Pivot tables and organize by moving them within Worksheets or to a new Workbook to maintain your data regularly.

Please visit our free resources center for more high-quality guides on Excel and other Microsoft Suite applications.

Ready to dive deep into Excel? Click here for advanced Excel courses with in-depth training modules.

Simon Sez IT has been teaching Excel and other business software for over ten years. You can get access to 150+ IT training courses for a low monthly fee.

Simon Calder

Chris “Simon” Calder was working as a Project Manager in IT for one of Los Angeles’ most prestigious cultural institutions, LACMA.He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course - the rest, as they say, is history!