{"id":11747,"date":"2022-09-20T09:30:22","date_gmt":"2022-09-20T09:30:22","guid":{"rendered":"https:\/\/officetuts.net\/excel\/?p=11747"},"modified":"2024-03-28T11:46:43","modified_gmt":"2024-03-28T11:46:43","slug":"move-a-pivot-table","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/move-a-pivot-table\/","title":{"rendered":"Move a Pivot Table in Excel"},"content":{"rendered":"\n
Move-a-Pivot-Table-in-Excel<\/a>Download File<\/a><\/div>\n\n\n\n

Sometimes you may want to move a PivotTable to another location in Excel. The reason could be that you want to create room for new worksheet rows, columns, or cells. This tutorial explains how to move a PivotTable in Excel.<\/p>\n\n\n\n

Move a PivotTable in Excel<\/h2>\n\n\n\n

We can move a PivotTable in Excel to a new worksheet in the current workbook or another workbook. We can also move it to another location in the active worksheet.<\/p>\n\n\n\n

To a new worksheet in the current workbook<\/h3>\n\n\n\n

We will use the following PivotTable in our illustration.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

We use the following steps:<\/p>\n\n\n\n

    \n
  1. Select any cell in the PivotTable.<\/li>\n\n\n\n
  2. Click PivotTable Analyze >> Actions >> Move PivotTable<\/strong>.<\/li>\n<\/ol>\n\n\n\n
    \"Graphical<\/figure>\n\n\n\n

    The Move PivotTable<\/strong> dialog box is displayed.<\/p>\n\n\n\n

      \n
    1. Under Choose where you want the PivotTable report to be placed<\/strong>, select the New Worksheet<\/strong> option and click the OK<\/strong> button.<\/li>\n<\/ol>\n\n\n\n
      \"\"<\/figure>\n\n\n\n

      Excel opens a new worksheet and moves the PivotTable to it.<\/p>\n\n\n\n

      \"Table\n\nDescription<\/figure>\n\n\n\n

      The 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\n

      We use the following steps:<\/p>\n\n\n\n

        \n
      1. Select any cell in the PivotTable.<\/li>\n\n\n\n
      2. Click PivotTable Analyze >> Actions >> Move PivotTable<\/strong>.<\/li>\n\n\n\n
      3. In 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\n

        The PivotTable is moved to a destination range that begins at cell A1.<\/p>\n\n\n\n

        \"\"<\/figure>\n\n\n\n

        Note:<\/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

        \"Graphical<\/figure>\n\n\n\n

        The Move PivotTable<\/strong> dialog box is collapsed.<\/p>\n\n\n\n

        \"A<\/figure>\n\n\n\n

        Click cell A1.<\/p>\n\n\n\n

        \"\"<\/figure>\n\n\n\n

        The selected cell A1 has a dotted border and its cell reference is entered in the Location<\/strong> box.<\/p>\n\n\n\n

        Click the Expand<\/strong> dialog button that has a down-arrow icon.<\/p>\n\n\n\n

        \"\"<\/figure>\n\n\n\n

        The dialog box is expanded.<\/p>\n\n\n\n

        \"Graphical<\/figure>\n\n\n\n

        To 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

          \n
        1. Select any cell in the PivotTable.<\/li>\n\n\n\n
        2. Click PivotTable Analyze >> Actions >> Select >> Entire PivotTable<\/strong>.<\/li>\n<\/ol>\n\n\n\n
          \"\"<\/figure>\n\n\n\n
            \n
          1. Click 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\n
          2. Open the worksheet in another workbook and select cell A1.<\/li>\n\n\n\n
          3. Press Ctrl + V<\/strong> to paste the PivotTable.<\/li>\n<\/ol>\n\n\n\n

            The 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":"\nMove a Pivot Table in Excel<\/title>\n<meta name=\"description\" content=\"Learn how to move a PivotTable in Excel to create more space for new data or cells. Follow simple steps to move it to a new worksheet or another workbook.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/examples\/move-a-pivot-table\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Move a Pivot Table in Excel\" \/>\n<meta property=\"og:description\" content=\"Learn how to move a PivotTable in Excel to create more space for new data or cells. Follow simple steps to move it to a new worksheet or another workbook.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/examples\/move-a-pivot-table\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-20T09:30:22+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-28T11:46:43+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/09\/word-image-11747-1.png\" \/>\n<meta name=\"author\" content=\"Christopher Sirali\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Christopher Sirali\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/move-a-pivot-table\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/move-a-pivot-table\/\"},\"author\":{\"name\":\"Christopher Sirali\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/b303a8b219a448ca09f1e9eed3903370\"},\"headline\":\"Move a Pivot Table in Excel\",\"datePublished\":\"2022-09-20T09:30:22+00:00\",\"dateModified\":\"2024-03-28T11:46:43+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/move-a-pivot-table\/\"},\"wordCount\":579,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/move-a-pivot-table\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/09\/word-image-11747-1.png\",\"keywords\":[\"file\",\"pinterest\"],\"articleSection\":[\"examples\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/move-a-pivot-table\/\",\"url\":\"https:\/\/officetuts.net\/excel\/examples\/move-a-pivot-table\/\",\"name\":\"Move a Pivot Table in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/move-a-pivot-table\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/move-a-pivot-table\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/09\/word-image-11747-1.png\",\"datePublished\":\"2022-09-20T09:30:22+00:00\",\"dateModified\":\"2024-03-28T11:46:43+00:00\",\"description\":\"Learn how to move a PivotTable in Excel to create more space for new data or cells. Follow simple steps to move it to a new worksheet or another workbook.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/move-a-pivot-table\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/examples\/move-a-pivot-table\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/move-a-pivot-table\/#primaryimage\",\"url\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/09\/word-image-11747-1.png\",\"contentUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/09\/word-image-11747-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/move-a-pivot-table\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Move a Pivot Table in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/b303a8b219a448ca09f1e9eed3903370\",\"name\":\"Christopher Sirali\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/21aaff468311813001dc2723f1937cf0?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/21aaff468311813001dc2723f1937cf0?s=96&d=mm&r=g\",\"caption\":\"Christopher Sirali\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Move a Pivot Table in Excel","description":"Learn how to move a PivotTable in Excel to create more space for new data or cells. Follow simple steps to move it to a new worksheet or another workbook.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/officetuts.net\/excel\/examples\/move-a-pivot-table\/","og_locale":"en_US","og_type":"article","og_title":"Move a Pivot Table in Excel","og_description":"Learn how to move a PivotTable in Excel to create more space for new data or cells. Follow simple steps to move it to a new worksheet or another workbook.","og_url":"https:\/\/officetuts.net\/excel\/examples\/move-a-pivot-table\/","article_published_time":"2022-09-20T09:30:22+00:00","article_modified_time":"2024-03-28T11:46:43+00:00","og_image":[{"url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/09\/word-image-11747-1.png"}],"author":"Christopher Sirali","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Christopher Sirali","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/examples\/move-a-pivot-table\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/examples\/move-a-pivot-table\/"},"author":{"name":"Christopher Sirali","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/b303a8b219a448ca09f1e9eed3903370"},"headline":"Move a Pivot Table in Excel","datePublished":"2022-09-20T09:30:22+00:00","dateModified":"2024-03-28T11:46:43+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/move-a-pivot-table\/"},"wordCount":579,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/move-a-pivot-table\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/09\/word-image-11747-1.png","keywords":["file","pinterest"],"articleSection":["examples"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/examples\/move-a-pivot-table\/","url":"https:\/\/officetuts.net\/excel\/examples\/move-a-pivot-table\/","name":"Move a Pivot Table in Excel","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/move-a-pivot-table\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/move-a-pivot-table\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/09\/word-image-11747-1.png","datePublished":"2022-09-20T09:30:22+00:00","dateModified":"2024-03-28T11:46:43+00:00","description":"Learn how to move a PivotTable in Excel to create more space for new data or cells. Follow simple steps to move it to a new worksheet or another workbook.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/examples\/move-a-pivot-table\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/examples\/move-a-pivot-table\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/examples\/move-a-pivot-table\/#primaryimage","url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/09\/word-image-11747-1.png","contentUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/09\/word-image-11747-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/examples\/move-a-pivot-table\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Move a Pivot Table in Excel"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."},{"@type":"Person","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/b303a8b219a448ca09f1e9eed3903370","name":"Christopher Sirali","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/21aaff468311813001dc2723f1937cf0?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/21aaff468311813001dc2723f1937cf0?s=96&d=mm&r=g","caption":"Christopher Sirali"}}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/11747"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=11747"}],"version-history":[{"count":4,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/11747\/revisions"}],"predecessor-version":[{"id":14217,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/11747\/revisions\/14217"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=11747"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=11747"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=11747"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}