How to Create a Pivot Table From Multiple Excel Worksheets

By Erika Dean

Excel is a spreadsheet program you can use to analyze data and create reports. One type of report you can create using Excel is called a pivot table. A pivot table takes a range of data and creates a report that you can easily modify to make the data easier to analyze. If you have ever created a pivot table using Excel, you may have noticed that you can only select a range from one worksheet. But you can create a pivot table using data from multiple worksheets using the Pivot Table Wizard.

Step 1

Open the Excel workbook you want to insert a pivot table in.

Step 2

Press "ALT + D + P" to start the Pivot Table Wizard.

Step 3

Select "Multiple consolidation ranges" when the Pivot Table Wizard asks which type of data you want to analyze. Click "Next."

Step 4

Choose whether you want the pivot table to have one or more page fields and click "Next."

Step 5

Use your mouse to highlight the ranges you want to enter on the pivot table. Click "Add" after selecting a range from each worksheet.

Step 6

Click "Next" and select where you want to place the pivot table. You can insert the table on a new worksheet or on an existing worksheet. After choosing, click "Finish."