How to Create a Pivot Table Based on Multiple Tables in Excel 2013

how to create pivottable lead 675403

Up until recently, if you had data spread across several tables in Microsoft Excel that you wanted to consolidate in a single pivot table, you would have faced a headache-inducing process of manual formatting and data preparation. The most recent version of the software, Excel 2013, fixes this problem by allowing you to create a pivot table from multiple tables automatically — no manual formatting required. Just follow these steps to get started.

1. Click “Insert” at the top of the screen.

how to create pivottable 1 click insert 675403

2. Click the “PivotTable” button on the Ribbon.

how to create pivottable 2 click pivottable 675403

3. Select the first table you want to add to the pivot table.

how to create pivottable 3 select table 675403

4. Check the box labeled “Add this data to the Data Model” and press OK.

how to create pivottable 4 check add 675403

5. Click “All” in the PivotTable Fields window to view all of the tables. Excel automatically detects multiple tables, so you won’t need to repeat these steps for each additional table.

how to create pivottable 5 click all 675403

6. Check the boxes of the cells you wish to include in the pivot table.

how to create pivottable 6 check boxes 675403

Email* (will not be published)
*Indicates required field
Submit Comments

  1. HeyAdmin Says:

    Like the article, but what if the tables are on different sheets?


    If a user with excel 2013 creates a pivot table with multiple sheets that have different columns can a excel 2010 user use it?

All Product Types Accessories Cars Digital Camcorders Digital Cameras eReaders GPS Laptops MP3 & Video Players Projectors Smartphones Software Storage Tablets / MIDs VoIP Wi-Fi
All Subcategories
All Subcategories All-Purpose Budget Business Desktop Replacement Gaming Multimedia Netbook Nettop Rugged Student Tablet PCs Ultraportable
Acer Alienware Apple Archos ASUS Averatec BenQ CTL Corp. Dell Digital Storm eMachines Emtec Everex Fujitsu GammaTech Gateway General Dynamics Getac Gigabyte Hercules HP HTC iBuyPower Intel Lenovo MSI Nokia Nvidia OCZ OLPC OQO Origin Panasonic Sager Samsung Sony Sylvania Systemax TabletKiosk Toshiba Verizon Viewsonic Viliv VooDoo Workhorse PC ZT Systems
Minimum Rating
Any Rating 4.5 Stars 4.0 Stars 3.5 Stars 3.0 Stars
Screen Size
10 11 12 13 14 15 16 17 18 20 4 5 6 7 8 9
1024x576 1024x600 1024x768 1200X800 1280 x 720 1280x1024 1280x768 1280x800 1366x678 1366x768 1440x1050 1440x900 1600x768 1600x900 1680x1050 1680x945 1920x1080 1920x1200 800x400 800x480
Weight Range
10.1 - 12.0 pounds 12.1 - 14.0 pounds 14.1 - 16.0 pounds 2 lbs 2 pounds and under 2+ lbs 2.1 - 4.0 pounds 4.1 - 6.0 pounds 6.1 - 8.0 pounds 8.1 - 10.0 pounds Over 16 pounds Under 2 pounds
more options