"Add a Second Pivot Table to the Same Sheet"

Lauren Aug 08, 2026

Are you looking to enhance the data visualization and analysis in your Excel worksheet by adding another pivot table?дион

Pivot Tables in 20 seconds
Pivot Tables in 20 seconds

Excellent! You're about to boost your Excel skills and increase your worksheet's functionality. This step-by-step guide will walk you through the process of adding a second pivot table to the same sheet, with no need to resort to the dark side of copy-pasting or creating a new sheet.

Ultimate excel pivot tables tutorial
Ultimate excel pivot tables tutorial

Preparing Your Data

Before you begin, ensure your data is ready. It should be clean, well-structured, and free of any errors. You might need to filter, sort, or remove duplicates to prepare your data.

Convert a Pivot Table to a Table
Convert a Pivot Table to a Table

Also, make sure your Excel version is up-to-date. The procedures can vary slightly between versions, but the core process remains the same.

Inserting a New Pivot Table

Make a Pivot from Another Pivot Table in Excel
Make a Pivot from Another Pivot Table in Excel

To start, click anywhere within your data range. Then, go to the 'Insert' tab and click 'PivotTable'. In the 'Create PivotTable' window, ensure the data range is correct and choose where you want to place the new pivot table - select 'New Sheet' to place it on a new sheet or 'Existing Worksheet' to add it to the current sheet.

For now, select 'Existing Worksheet' and choose an existing cell or a new location. Click 'OK'.

Designing Your New Pivot Table

Make Pivot Table from Multiple Sheets in Excel
Make Pivot Table from Multiple Sheets in Excel

Now, the 'PivotTable Fields' pane will appear. Here, you'll see your data fields listed. Drag and drop the fields you want to add to your pivot table. You can add fields to 'Rows', 'Columns', 'Values', or 'Filters' areas to customize your pivot table's layout.

For example, you might want to add 'Category' to Rows, 'Salesperson' to Columns, and 'Total Sales' to Values. Adjust the layout according to your needs.

Formatting and Updating Your Pivot Tables

How to Use Pivot Tables in 4 Easy Steps | The Finance posted on the topic | LinkedIn
How to Use Pivot Tables in 4 Easy Steps | The Finance posted on the topic | LinkedIn

Once you've designed your pivot tables, it's time to format them to enhance readability. Use the 'Design' and 'Home' tabs to customize the fonts, colors, and styles.

After formatting, you might want to update both pivot tables with fresh data. To do this, right-click on any cell in the pivot table and select 'Refresh' or go to the 'Data' tab and click 'Refresh All'. This will update both pivot tables in real-time.

How to make a pivot table when you have data in multiple sheets [Tutorial]
How to make a pivot table when you have data in multiple sheets [Tutorial]
Pivot Table from Multiple Sheets | How to Create a Pivot Table?
Pivot Table from Multiple Sheets | How to Create a Pivot Table?
Management training, Soft skills, Power BI, Excel Learning solutions
Management training, Soft skills, Power BI, Excel Learning solutions
How to create a new pivot table style
How to create a new pivot table style
Master Pivot Tables - 101 Excel Examples
Master Pivot Tables - 101 Excel Examples
Add a Running Total in a Pivot Table
Add a Running Total in a Pivot Table
You Won't Believe These Crazy PIVOT TABLE Hacks!
You Won't Believe These Crazy PIVOT TABLE Hacks!
How to apply a pivot table style
How to apply a pivot table style
Pivot Tables in Excel Explained: What Are They Actually For?
Pivot Tables in Excel Explained: What Are They Actually For?
How To Make Use of 5 Advanced Excel Pivot Table Techniques | Envato Tuts+
How To Make Use of 5 Advanced Excel Pivot Table Techniques | Envato Tuts+
multiple excel pivot tables - how to add multiple pivot tables from the same data set and connect a slice t
multiple excel pivot tables - how to add multiple pivot tables from the same data set and connect a slice t
How to Sort a Pivot Table in Excel (Sorting Pivot Tables)
How to Sort a Pivot Table in Excel (Sorting Pivot Tables)
How to Create Pivot Table in Excel With Step by Step Guide
How to Create Pivot Table in Excel With Step by Step Guide
Sum VS Count in Pivot Table | MyExcelOnline
Sum VS Count in Pivot Table | MyExcelOnline
101 Excel Pivot Tables Examples | MyExcelOnline
101 Excel Pivot Tables Examples | MyExcelOnline
Excel Pivot Table in 5 Speedy Steps | MyExcelOnline
Excel Pivot Table in 5 Speedy Steps | MyExcelOnline
an image of a computer screen with the words pivot table in front of it
an image of a computer screen with the words pivot table in front of it
Pivot Tables in Excel Explained: What Are They Actually For?
Pivot Tables in Excel Explained: What Are They Actually For?
Pivot Table Super Tips in Excel
Pivot Table Super Tips in Excel

Using Slicers and Filters

To make your pivot tables more interactive, you can add 'Slicers' and 'Filters'. Slicers allow users to filter the data using buttons, while Filters appear in the header of the pivot table and filter data within the same pivot table.

To add a Slicer, go to the 'Analyze' or 'Options' tab and click 'Insert Slicer'. To add a Filter, right-click on the header and select 'Insert Slicer' or 'Filter'.

Arranging and Resizing Pivot Tables

Finally, you can adjust the size and position of your pivot tables. Click and drag the resize handles or select the entire pivot table and use the 'Format' tab to specify the size.

You can also use the 'Home' tab to group, merge, or resize cells within the pivot table for better organization.

There you have it – a second pivot table, perfectly integrated into your existing worksheet. Enjoy your enhanced data analysis capabilities!