How To Add Data To A Pivot Table 11 Steps With Pictures

For example, if you have data in cells A1 through E10, you would add another column in the F column or another row in the 11 row. If you simply want to change the data in your pivot table, alter the data here.

On a Mac, click the PivotTable Analyze tab here instead.

If you added a new column to your pivot table, check its box in the right side of the Excel window to display it.