<\/figure>\n\n\n\nThe moved PivotTable retains most of its formatting except the column widths which need adjusting.<\/p>\n\n\n\n
The original PivotTable occupied a range starting with cell A1, but the moved PivotTable starts at cell A3. You need to move it so that it begins at cell A1. The next section covers how this can be done.<\/p>\n\n\n\n
To another location in the current worksheet<\/h3>\n\n\n\n We will use the following PivotTable that begins in cell A3 in our illustration.<\/p>\n\n\n\n <\/figure>\n\n\n\nWe use the following steps:<\/p>\n\n\n\n
\nSelect any cell in the PivotTable.<\/li>\n\n\n\n Click PivotTable Analyze >> Actions >> Move PivotTable<\/strong>.<\/li>\n\n\n\nIn the Move PivotTable<\/strong> dialog box under Choose where you want the PivotTable report to be placed<\/strong>, select Existing Worksheet<\/strong>. Type the full reference of the first cell of the destination range in the Location<\/strong> box and click the OK<\/strong> button. In our example, cell A1 is the first cell of our destination range.<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\nThe PivotTable is moved to a destination range that begins at cell A1.<\/p>\n\n\n\n <\/figure>\n\n\n\nNote:<\/strong> Instead of typing the first cell of the destination range in the Location<\/strong> box, you can use the point-and-click method. First, click the Collapse<\/strong> dialog box button that has an up-arrow icon.<\/p>\n\n\n\n <\/figure>\n\n\n\nThe Move PivotTable<\/strong> dialog box is collapsed.<\/p>\n\n\n\n <\/figure>\n\n\n\nClick cell A1.<\/p>\n\n\n\n <\/figure>\n\n\n\nThe selected cell A1 has a dotted border and its cell reference is entered in the Location<\/strong> box.<\/p>\n\n\n\nClick the Expand<\/strong> dialog button that has a down-arrow icon.<\/p>\n\n\n\n <\/figure>\n\n\n\nThe dialog box is expanded.<\/p>\n\n\n\n <\/figure>\n\n\n\nTo a worksheet in another workbook.<\/h3>\n\n\n\n The Move PivotTable dialog box does not have an option for moving a Pivotable to a worksheet in another workbook. We can use the copy and paste method to move the PivotTable.<\/p>\n\n\n\n
We use the following steps:<\/p>\n\n\n\n
\nSelect any cell in the PivotTable.<\/li>\n\n\n\n Click PivotTable Analyze >> Actions >> Select >> Entire PivotTable<\/strong>.<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\n\nClick any blank cell in the worksheet to deselect the Actions<\/strong> group command. Press Ctrl + X<\/strong> to cut the PivotTable<\/strong> and copy it to the Clipboard<\/strong>.<\/li>\n\n\n\nOpen the worksheet in another workbook and select cell A1.<\/li>\n\n\n\n Press Ctrl + V<\/strong> to paste the PivotTable.<\/li>\n<\/ol>\n\n\n\nThe moved PivotTable retains most of its formatting except the column widths which you need to adjust.<\/p>\n\n\n\n
Conclusion<\/h2>\n\n\n\n You may want to move a PivotTable in Excel to another location to create room for new rows, columns, or even cells. This tutorial showed how to move a PivotTable to a new worksheet in the current workbook or another workbook. It also explained how to move a PivotTable to another location in the active worksheet.<\/p>\n","protected":false},"excerpt":{"rendered":"
Sometimes you may want to move a PivotTable to another location in Excel. The reason could be that you want to create room…<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[170,190],"yoast_head":"\n
Move a Pivot Table in Excel<\/title>\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\t \n\t \n\t \n