Copy pivot table - here's how to do it

Pivot tables allow you to analyze and merge lists and databases in Excel. For larger data sets based on the same data source, it can help if you copy the pivot table and divide it into multiple parts to keep track.

How to copy pivot tables in Excel

If you have your data set in a pivot table and want to split the data and arrange it according to different criteria, the table will quickly become large and confusing. To avoid this, you can copy the pivot table and thus split it into several tables with different focuses. The copies of the pivot table automatically refer to the same data set as their origin.Follow these steps to copy pivot tables in Excel:

1. Start Excel and open a document with a pivot table.
2. Select the table with the left mouse button and press [Ctrl] and [C] to copy.
3. To paste, click in any cell and press [Ctrl] and [V].

Alternatively to the keyboard shortcut, right-click on the worksheet name and select the "Move or Copy..." option. Then set the checkbox at "Create copy" and click "Ok". Excel will then create a new worksheet with the copy of the table.

Update data - you need to know

If you edit the source data or the data in the source table, Excel will automatically update the associated copies. Alternatively, you can use the Refresh function to bring the data up to date.