How to Edit a Pivot Table in Excel

PDF download Download Article
PDF download Download Article

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.

Editing a Pivot Table

  1. Open the Excel project that includes the pivot table you want to edit.
  2. Create separate rows and columns to enter the data you want in your pivot table.
  3. Click on the Analyze tab on the Pivot Table tab, then select Change Data Source.
  4. Select the new data you entered, click OK, then refresh to view your changes.

Steps

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/7f\/Edit-a-Pivot-Table-in-Excel-Step-1.jpg\/v4-460px-Edit-a-Pivot-Table-in-Excel-Step-1.jpg","bigUrl":"\/images\/thumb\/7\/7f\/Edit-a-Pivot-Table-in-Excel-Step-1.jpg\/aid12808339-v4-728px-Edit-a-Pivot-Table-in-Excel-Step-1.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    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. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/8f\/Edit-a-Pivot-Table-in-Excel-Step-2.jpg\/v4-460px-Edit-a-Pivot-Table-in-Excel-Step-2.jpg","bigUrl":"\/images\/thumb\/8\/8f\/Edit-a-Pivot-Table-in-Excel-Step-2.jpg\/aid12808339-v4-728px-Edit-a-Pivot-Table-in-Excel-Step-2.jpg","smallWidth":460,"smallHeight":349,"bigWidth":728,"bigHeight":553,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    Click the tab that contains your data (e.g., Sheet 2 ) at the bottom of the Excel window.
    Advertisement
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/63\/Edit-a-Pivot-Table-in-Excel-Step-3.jpg\/v4-460px-Edit-a-Pivot-Table-in-Excel-Step-3.jpg","bigUrl":"\/images\/thumb\/6\/63\/Edit-a-Pivot-Table-in-Excel-Step-3.jpg\/aid12808339-v4-728px-Edit-a-Pivot-Table-in-Excel-Step-3.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":547,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    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. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/99\/Edit-a-Pivot-Table-in-Excel-Step-4.jpg\/v4-460px-Edit-a-Pivot-Table-in-Excel-Step-4.jpg","bigUrl":"\/images\/thumb\/9\/99\/Edit-a-Pivot-Table-in-Excel-Step-4.jpg\/aid12808339-v4-728px-Edit-a-Pivot-Table-in-Excel-Step-4.jpg","smallWidth":460,"smallHeight":349,"bigWidth":728,"bigHeight":553,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    Click the tab on which your pivot table is listed.
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/48\/Edit-a-Pivot-Table-in-Excel-Step-5.jpg\/v4-460px-Edit-a-Pivot-Table-in-Excel-Step-5.jpg","bigUrl":"\/images\/thumb\/4\/48\/Edit-a-Pivot-Table-in-Excel-Step-5.jpg\/aid12808339-v4-728px-Edit-a-Pivot-Table-in-Excel-Step-5.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":547,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    Click the pivot table to select it.
  6. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/fe\/Edit-a-Pivot-Table-in-Excel-Step-6.jpg\/v4-460px-Edit-a-Pivot-Table-in-Excel-Step-6.jpg","bigUrl":"\/images\/thumb\/f\/fe\/Edit-a-Pivot-Table-in-Excel-Step-6.jpg\/aid12808339-v4-728px-Edit-a-Pivot-Table-in-Excel-Step-6.jpg","smallWidth":460,"smallHeight":344,"bigWidth":728,"bigHeight":545,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    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. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/0e\/Edit-a-Pivot-Table-in-Excel-Step-7.jpg\/v4-460px-Edit-a-Pivot-Table-in-Excel-Step-7.jpg","bigUrl":"\/images\/thumb\/0\/0e\/Edit-a-Pivot-Table-in-Excel-Step-7.jpg\/aid12808339-v4-728px-Edit-a-Pivot-Table-in-Excel-Step-7.jpg","smallWidth":460,"smallHeight":344,"bigWidth":728,"bigHeight":545,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    This option is in the "Data" section of the Analyze toolbar. A drop-down menu will appear.
  8. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/4b\/Edit-a-Pivot-Table-in-Excel-Step-8.jpg\/v4-460px-Edit-a-Pivot-Table-in-Excel-Step-8.jpg","bigUrl":"\/images\/thumb\/4\/4b\/Edit-a-Pivot-Table-in-Excel-Step-8.jpg\/aid12808339-v4-728px-Edit-a-Pivot-Table-in-Excel-Step-8.jpg","smallWidth":460,"smallHeight":344,"bigWidth":728,"bigHeight":545,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    It's in the drop-down menu. Doing so opens a window.
  9. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/af\/Edit-a-Pivot-Table-in-Excel-Step-9.jpg\/v4-460px-Edit-a-Pivot-Table-in-Excel-Step-9.jpg","bigUrl":"\/images\/thumb\/a\/af\/Edit-a-Pivot-Table-in-Excel-Step-9.jpg\/aid12808339-v4-728px-Edit-a-Pivot-Table-in-Excel-Step-9.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    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. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/b4\/Edit-a-Pivot-Table-in-Excel-Step-10.jpg\/v4-460px-Edit-a-Pivot-Table-in-Excel-Step-10.jpg","bigUrl":"\/images\/thumb\/b\/b4\/Edit-a-Pivot-Table-in-Excel-Step-10.jpg\/aid12808339-v4-728px-Edit-a-Pivot-Table-in-Excel-Step-10.jpg","smallWidth":460,"smallHeight":344,"bigWidth":728,"bigHeight":545,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    It's at the bottom of the window.
  11. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a7\/Edit-a-Pivot-Table-in-Excel-Step-11.jpg\/v4-460px-Edit-a-Pivot-Table-in-Excel-Step-11.jpg","bigUrl":"\/images\/thumb\/a\/a7\/Edit-a-Pivot-Table-in-Excel-Step-11.jpg\/aid12808339-v4-728px-Edit-a-Pivot-Table-in-Excel-Step-11.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    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

Expert Q&A

Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Tips

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Name
      Please provide your name and last initial
      Submit
      Thanks for submitting a tip for review!

      You Might Also Like

      How to
      Unprotect an Excel Sheet
      How to
      Merge Cells in Microsoft Excel: A Quick Guide
      How to
      Use If‐Else in Microsoft Excel: Step-by-Step Tutorial
      How to
      Create a Graph in Excel
      How to
      Insert Pictures in Excel That Automatically Size to Fit Cells
      How to
      Show Hidden Columns in Microsoft Excel & Unhide Column A
      How to
      Create a Mortgage Calculator With Microsoft Excel
      How to
      Unhide Multiple Rows in Microsoft Excel
      3 Easy Ways to Freeze Panes to Lock Columns or Rows in Excel
      How to
      Fix Ethernet Doesn't Have a Valid IP Configuration on Windows
      How to
      Change from Lowercase to Uppercase in Microsoft Excel
      How to
      Add a Column or Calculated Field in an Excel Pivot Table
      The Best Ways to Make & Format Lists in Excel
      How to
      Add a Best Fit Line 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

      Article Summary X

      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?
      Thanks to all authors for creating a page that has been read 135,285 times.

      Is this article up to date?

      Advertisement