How to Add Data to a PivotTable in Excel: 11 Steps (with Pictures)

Table of contents:

How to Add Data to a PivotTable in Excel: 11 Steps (with Pictures)
How to Add Data to a PivotTable in Excel: 11 Steps (with Pictures)
Anonim

This wikiHow teaches you how to add data to an existing PivotTable in Microsoft Excel. You can do this in both the Windows and Mac versions of Excel.

Steps

Add Data to a Pivot Table Step 1

Step 1. Open the Excel document containing the pivot table

Double click on the Excel document containing the pivot table. It opens.

Add Data to a Pivot Table Step 2

Step 2. Go to the spreadsheet page with your data

Click on the tab with your details (eg. Sheet 2) at the bottom of the Excel window.

Add Data to a Pivot Table Step 3

Step 3. Add or change your details

Enter the data you want to add to your pivot table, right next to or below the current data.

  • For example: if you have data in the cells A1 to E10 then add a column in the f-column or any other row in the

    Step 11.-queue.

  • If you just want to change the data in your pivot table, you can do it here.
Add Data to a Pivot Table Step 4

Step 4. Go back to the PivotTable tab

Click on the tab where you have the pivot table.

Add Data to a Pivot Table Step 5

Step 5. Select your pivot table

Click on the pivot table to select it.

Add Data to a Pivot Table Step 6

Step 6. Click on the Options tab

This can be found in the middle of the green ribbon at the top of the Excel window. This will open a toolbar just below the green ribbon.

  • On a Mac, click the tab Analyze pivot table.
Add Data to a Pivot Table Step 7

Step 7. Click Change data source

This option can be found in the 'Data' group of the toolbar Options. A drop-down menu will appear.

Add Data to a Pivot Table Step 8

Step 8. Click Change Data Source…

You will find this option in the drop-down menu. A window will appear.

Add Data to a Pivot Table Step 9

Step 9. Select your data

Click and drag from the top left cell in your data group down to the left cell at the bottom of the group. This includes the column(s) or row(s) you added.

Add Data to a Pivot Table Step 10

Step 10. Click OK

You will find this at the bottom of the window.

Add Data to a Pivot Table Step 11

Step 11. Click Refresh

This can be found in the 'Data' group of the toolbar.

Popular by topic