How to Clone a Pivot Table

To clone a Pivot Table, you can simply copy the whole Pivot Table, then paste to the location where you want, especially when you clone it within the same worksheet.

If you are clone a Pivot Table to a different worksheet, please use "Move and Copy…" function with the steps below:

Step 1: Move your mouse on the worksheet Tab name;

Step 2: Right-click, and select "Move and Copy…" from the list;

Step 3: Check "Create a copy" at the bottom;

Step 4: Click "OK", and the whole worksheet including the Pivot Table is now in a new worksheet.


  1. olden June 1, 2019
  2. Tyson June 20, 2019

Leave a Reply