Group Two Excel Pivot Tables Independently

Let me demonstrate how you can group two pivot tables independently.

Exercise Workbook:

---

Here is our Pivot Table setup:

STEP 1: Let us duplicate this, select the entire Pivot Table by pressing CTRL + A, right-click and select Copy

Pick any cell right next to it and select Paste.

STEP 2: Right-click on the new Pivot Table and select Group

Make any grouping selection that you prefer and click OK

STEP 3: Notice that the grouping is applied to both Pivot Tables! But we do not want that to happen.

Click the Undo button and let us work on the workaround for this.

STEP 4: Select the new Pivot Table and click the Cut icon

STEP 5: Open a new Excel workbook by pressing CTRL + N and select Paste

STEP 6: Now right-click on this Pivot Table in the new Excel workbook, select Group and pick the groupings that you prefer. Click OK

STEP 7: Looking good! Select this Pivot Table and click the Cut icon again

STEP 8: Paste this back on the original workbook

You will notice that the grouping is now applied only to this Pivot Table!

This is how you can easily group two Pivot Tables independently!

 

Make sure to download our FREE PDF on the 333 Excel keyboard Shortcuts here: