How to Edit a Pivot Table in Excel

After you create a pivot table, you might need to edit it later. This wikiHow will show you how to edit a pivot table in Excel on your computer by adding or changing the source data. After you make any changes to the data for your Pivot Table, you will need to refresh it to see any changes.

Steps

  1. Image titled Edit a Pivot Table in Excel Step 1
    1
    Open your project in Excel. To do this, double-click the Excel document that contains your pivot table in Finder (Macs) or File Explorer (Windows). Alternatively, if you already have Excel open, click File > Open and select the file that has your pivot table.
  2. Image titled Edit a Pivot Table in Excel Step 2
    2
    Go to the spreadsheet page that contains the data for the pivot table. Click the tab that contains your data (e.g., Sheet 2) at the bottom of the Excel window.
    Advertisement
  3. Image titled Edit a Pivot Table in Excel Step 3
    3
    Add or change your data. Enter the data that you want to add to your pivot table directly next to or below the current data.
    • 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, edit the data here. It won't be reflected in the pivot table until you refresh the data, though.
  4. Image titled Edit a Pivot Table in Excel Step 4
    4
    Go back to the pivot table tab. Click the tab on which your pivot table is listed.
  5. Image titled Edit a Pivot Table in Excel Step 5
    5
    Select your pivot table. Click the pivot table to select it.
  6. Image titled Edit a Pivot Table in Excel Step 6
    6
    Click the Analyze tab. It's in the middle of the editing ribbon that's at the top of the Excel window. Doing so will open a toolbar just below the editing ribbon.
    • On a Mac, click the PivotTable Analyze tab here instead.
  7. Image titled Edit a Pivot Table in Excel Step 7
    7
    Click Change Data Source. This option is in the "Data" section of the Analyze toolbar. A drop-down menu will appear.
  8. Image titled Edit a Pivot Table in Excel Step 8
    8
    Click Change Data Source…. It's in the drop-down menu. Doing so opens a window.
  9. Image titled Edit a Pivot Table in Excel Step 9
    9
    Select your data. Click and drag from the top-left cell in your data group down to the bottom-left cell in the group. This will include the column(s) or row(s) that you added.
  10. Image titled Edit a Pivot Table in Excel Step 10
    10
    Click OK. It's at the bottom of the window.
  11. Image titled Edit a Pivot Table in Excel Step 11
    11
    Click Refresh. It's in the "Data" section of the toolbar.
    • If you added a new column to your pivot table, check its box on the right side of the Excel window to display it.[1]
    12. Advertisement

You Might Also Like

Create a Mortgage Calculator With Microsoft Excel
How to
Create a Mortgage Calculator With Microsoft Excel
Make a Spreadsheet in Excel
How to
Make a Spreadsheet in Excel
Unprotect an Excel Sheet
How to
Unprotect an Excel Sheet
Create a Timeline in ExcelHow to Create a Timeline in Excel: SmartArt, Templates, and More
Create a Graph in Excel
How to
Create a Graph in Excel
Change from Lowercase to Uppercase in Excel
How to
Change from Lowercase to Uppercase in Excel
Merge Cells in ExcelHow to Merge Cells in Microsoft Excel: A Quick Guide
Insert Pictures in Excel That Automatically Size to Fit Cells
How to
Insert Pictures in Excel That Automatically Size to Fit Cells
How to
Unhide Rows in Excel
Convert Excel to Word3 Easy Ways to Convert Microsoft Excel Data to Word
Use ExcelNew to Excel? Here's Super Easy Tricks to Get You Started
Find Duplicates in Excel
How to
Find Duplicates in Excel
Calculate Age on ExcelHow to Calculate Age on Microsoft Excel Using Functions
Link Sheets in Excel
How to
Link Sheets in Excel
Advertisement

References

  1. ↑ https://support.microsoft.com/en-us/office/change-the-source-data-for-a-pivottable-afd93524-f7de-432c-84d0-3896fbbc2577

About This Article

Darlene Antonelli, MA
Written by:
Darlene Antonelli, MA
wikiHow Technology Writer
This article was co-authored by wikiHow staff writer, Darlene Antonelli, MA. Darlene Antonelli is a Technology Writer and Editor for wikiHow. Darlene has experience teaching college courses, writing technology-related articles, and working hands-on in the technology field. She earned an MA in Writing from Rowan University in 2012 and wrote her thesis on online communities and the personalities curated in such communities. This article has been viewed 48,736 times.
How helpful is this?
Co-authors: 4
Updated: October 29, 2021
Views: 48,736
Categories: Featured Articles | Microsoft Excel
Article SummaryX

1. Open your project in Excel.
2. Go to the spreadsheet that contains the data for the pivot table
3. Add or change your data.
4. Go back to the pivot table tab.
5. Select your pivot table.
6. Click Analyze tab (Windows) or PivotTable Analyze (Mac).
7. Click Change Data Source.
8. Click Change Data Source.
9. Select your data.
10. Click Ok.
11. Click Refresh.

Did this summary help you?
Advertisement