How to Add Data to a Pivot Table

Step-by-Step Guide

1. 1

   Step 1: Launch Microsoft Excel and open the spreadsheet containing your source data and pivot table.

   Make sure you are entering the new data exactly like the existing entries with the same columns. ,, Click inside the pivot table to force the "PivotTable Tools" menu to launch.
   
   Click the "Change Data Source" button on the toolbar or use the Pivot Table Wizard to find the source data.
   
   Adjust the range entered to include the newly added data in your Excel spreadsheet. , The "Refresh" icon is on your toolbar under the "PivotTable Tools" menu. , Using the Pivot Table Wizard, adjust the rows and columns that display by dragging and dropping the labels into the appropriate areas of the pivot table.
2. 2

   Step 2: Select the tab where your raw data is listed.

3. 3

   Step 3: Copy and paste or enter the data you want to add to your pivot table into this part of the Excel spreadsheet.

4. 4

   Step 4: Move to the tab containing the pivot table.

5. 5

   Step 5: Adjust the source data for your pivot table.

6. 6

   Step 6: Refresh your pivot table to finish bringing in the new data.

7. 7

   Step 7: Change the layout of your pivot table

8. 8

   Step 8: if necessary

9. 9

   Step 9: to reflect the newly added data.

Detailed Guide

About the Author