• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Techbout

Technology Simplified.

  • iOS
  • Windows
  • Mac
  • Internet

How to Create Two Pivot Tables in Single Worksheet

By: Sam Patwegar | February 23, 2025

If required, you can Insert or Create two Pivot tables in a single Microsoft Excel worksheet and report or present your data in two different ways.

This can be done by using the option to Insert Pivot Table in the same worksheet that automatically becomes available, whenever there is an existing Pivot Table in an Excel Worksheet.

Create Two Pivot Tables in Single Worksheet

To explain the process of creating Two Pivot Tables in a single worksheet, let us consider the following Sales Data as recorded at 2 different store locations (Store#1 and Store#2).

Pivot Table Data Source

Advertisement

For the above Sales Data, let us go ahead and create the First Pivot Table to report ‘Sales Data by Gadget Type’ and the second Pivot Table to report ‘Sales Data by Store’.

1. Create First Pivot Table

Follow the steps below to create the First Pivot Table to show Sales Data by Products.

1. Select any Cell in the Source Data > click on Insert > Tables and select Recommended PivotTables option.

Insert Recommended Pivot Table in Excel

2. On Recommended PivotTables screen, select the PivotTable Layout that you want to use and click on OK.

Select Recommended Pivot Table in Excel

3. Once you click on OK, Excel will insert the first Pivot Table in a new worksheet.

4. Once Pivot Table is inserted, click on any Cell within the Pivot Table and this will bring up the ‘PivotTable Fields’ List.

Modify Pivot Table Layout

Modify the first Pivot Table as required by adding and dragging the Field Items between Columns, Rows and Values areas.

2. Create Second Pivot Table in Same Worksheet

Now, you can create a second Pivot Table in the same Worksheet by following the steps below.

1. Click on any empty cell in the same Worksheet – Make sure the Cell is away from the first pivot table that you just created.

2. Next, click on the Insert tab and click on PivotTable option.

Insert Pivot Table Option in Excel

3. On the next screen, select Pivot Table Range, select Existing Worksheet option and click on the OK button to insert a blank Pivot Table in the same Worksheet.

Select Pivot Table Range

4. Once blank Pivot Table is inserted, build the second Pivot Table as required by selecting items and dragging them between Columns, Rows and Values areas in PivotTable Fields list.

Build Pivot Table Report Using PivotTable Fields List

This way, you will end up with two Pivot tables on the same worksheet, reporting sales data in two different ways.

Two Pivot Tables in Single Worksheet

Whenever new sales are added, you can just refresh the two Pivot Tables and this will update the data in both Pivot Tables.

Similarly, you can add as many pivot tables in the same worksheet as you want and report data in different ways.

How to Fix Pivot Table Report Overlap Warning

When you insert two or more Pivot Tables in the same Worksheet, you may come across Pivot Table Report overlap warning, whenever you try to make changes in the Pivot Tables.

Pivot Table Report Overlap Warning

If this happens, click on OK to close the warning message and simply space out the two Pivot Tables.

You can space out Pivot Tables by inserting few blank rows (if Pivot Tables are one above another) and by inserting some blank columns (if Pivot Tables are side by side).

If you are going to change Pivot Tables frequently (adding and removing fields), it is better to keep the Pivot Tables on separate worksheets.

Sam Patwegar

Brings practical experience in technical writing from an engineering background to produce fluff-free, easy-to-follow and well tested troubleshooting guides and informative tech-related articles on this website.

Related
  • How to Merge and Unmerge Cells in Excel
  • How to Create Waterfall Chart in Excel
  • How to Automatically Refresh Pivot Table Data

Primary Sidebar

Advertisement

Recent Posts

  • Fix: System Tray Icon Missing in Windows 11/10
  • How to Use Internet Explorer in Windows 11
  • Fix: Cast to Device Not Working in Windows 11/10
  • Fix: MacBook Camera Not Working Issue
  • Multiple Ways to Disable Face ID on iPhone

© 2025 Techbout.com · All Rights Reserved
About | Privacy Policy | Terms | Contact
Twitter(X) | Facebook