How to Add Data to a Pivot Table

PDF download Download Article
Easy guide to update your pivot table
PDF download Download Article

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

Steps

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/5c\/Add-Data-to-a-Pivot-Table-Step-1-Version-2.jpg\/v4-460px-Add-Data-to-a-Pivot-Table-Step-1-Version-2.jpg","bigUrl":"\/images\/thumb\/5\/5c\/Add-Data-to-a-Pivot-Table-Step-1-Version-2.jpg\/aid1608530-v4-728px-Add-Data-to-a-Pivot-Table-Step-1-Version-2.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>"}
    Double-click the Excel document that contains your pivot table. It will open.
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/bd\/Add-Data-to-a-Pivot-Table-Step-2-Version-3.jpg\/v4-460px-Add-Data-to-a-Pivot-Table-Step-2-Version-3.jpg","bigUrl":"\/images\/thumb\/b\/bd\/Add-Data-to-a-Pivot-Table-Step-2-Version-3.jpg\/aid1608530-v4-728px-Add-Data-to-a-Pivot-Table-Step-2-Version-3.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 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\/a\/a0\/Add-Data-to-a-Pivot-Table-Step-3-Version-3.jpg\/v4-460px-Add-Data-to-a-Pivot-Table-Step-3-Version-3.jpg","bigUrl":"\/images\/thumb\/a\/a0\/Add-Data-to-a-Pivot-Table-Step-3-Version-3.jpg\/aid1608530-v4-728px-Add-Data-to-a-Pivot-Table-Step-3-Version-3.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>"}
    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, alter the data here.
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/9d\/Add-Data-to-a-Pivot-Table-Step-4-Version-3.jpg\/v4-460px-Add-Data-to-a-Pivot-Table-Step-4-Version-3.jpg","bigUrl":"\/images\/thumb\/9\/9d\/Add-Data-to-a-Pivot-Table-Step-4-Version-3.jpg\/aid1608530-v4-728px-Add-Data-to-a-Pivot-Table-Step-4-Version-3.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 the tab on which your pivot table is listed.
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/2a\/Add-Data-to-a-Pivot-Table-Step-5-Version-2.jpg\/v4-460px-Add-Data-to-a-Pivot-Table-Step-5-Version-2.jpg","bigUrl":"\/images\/thumb\/2\/2a\/Add-Data-to-a-Pivot-Table-Step-5-Version-2.jpg\/aid1608530-v4-728px-Add-Data-to-a-Pivot-Table-Step-5-Version-2.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 the pivot table to select it.
  6. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/98\/Add-Data-to-a-Pivot-Table-Step-6-Version-3.jpg\/v4-460px-Add-Data-to-a-Pivot-Table-Step-6-Version-3.jpg","bigUrl":"\/images\/thumb\/9\/98\/Add-Data-to-a-Pivot-Table-Step-6-Version-3.jpg\/aid1608530-v4-728px-Add-Data-to-a-Pivot-Table-Step-6-Version-3.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 middle of the green ribbon that's at the top of the Excel window. Doing so will open a toolbar just below the green ribbon.
    • On a Mac, click the PivotTable Analyze tab here instead.
  7. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/9e\/Add-Data-to-a-Pivot-Table-Step-7-Version-3.jpg\/v4-460px-Add-Data-to-a-Pivot-Table-Step-7-Version-3.jpg","bigUrl":"\/images\/thumb\/9\/9e\/Add-Data-to-a-Pivot-Table-Step-7-Version-3.jpg\/aid1608530-v4-728px-Add-Data-to-a-Pivot-Table-Step-7-Version-3.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>"}
    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\/d\/d1\/Add-Data-to-a-Pivot-Table-Step-8.jpg\/v4-460px-Add-Data-to-a-Pivot-Table-Step-8.jpg","bigUrl":"\/images\/thumb\/d\/d1\/Add-Data-to-a-Pivot-Table-Step-8.jpg\/aid1608530-v4-728px-Add-Data-to-a-Pivot-Table-Step-8.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 drop-down menu. Doing so opens a window.
  9. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c4\/Add-Data-to-a-Pivot-Table-Step-9.jpg\/v4-460px-Add-Data-to-a-Pivot-Table-Step-9.jpg","bigUrl":"\/images\/thumb\/c\/c4\/Add-Data-to-a-Pivot-Table-Step-9.jpg\/aid1608530-v4-728px-Add-Data-to-a-Pivot-Table-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\/e\/eb\/Add-Data-to-a-Pivot-Table-Step-10.jpg\/v4-460px-Add-Data-to-a-Pivot-Table-Step-10.jpg","bigUrl":"\/images\/thumb\/e\/eb\/Add-Data-to-a-Pivot-Table-Step-10.jpg\/aid1608530-v4-728px-Add-Data-to-a-Pivot-Table-Step-10.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 at the bottom of the window.
  11. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d3\/Add-Data-to-a-Pivot-Table-Step-11.jpg\/v4-460px-Add-Data-to-a-Pivot-Table-Step-11.jpg","bigUrl":"\/images\/thumb\/d\/d3\/Add-Data-to-a-Pivot-Table-Step-11.jpg\/aid1608530-v4-728px-Add-Data-to-a-Pivot-Table-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 in the right side of the Excel window to display it.
    12. Advertisement

Community Q&A

Search
Add New Question
  • Question
    How can I refresh data on a pivot table?
    Community Answer
    While in the data of the Pivot Table, the Analyze/Design tabs are viewable on the Ribbon, select the 'Refresh' button on the ribbon (it has 2 arrows that create a circle).
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 8 Helpful 10
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Video

      Tips

      • It's a good idea to save your pivot table before making any changes to it so that you can revert to the saved version if something goes wrong.
        Thanks
        Helpful 0 Not Helpful 0
      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!
      Advertisement

      You Might Also Like

      How to
      Calculate Average Growth Rate in Excel
      How to
      Apply Conditional Formatting in Excel
      How to
      Excel in High School
      How to
      Manage Priorities with Excel
      How to
      Calculate Age on Microsoft Excel Using Functions
      The Ultimate Guide to Using Microsoft Access
      How to
      Learn Data Entry
      2 Ways to Import Data from the Web into Excel: Windows & Mac
      How to
      Reset SA Password in SQL Server
      How to
      Order Alphabetically in SQL
      How to
      Make an Inventory Database in Access: Complete Guide
      Everything You Need to Know About Removing Duplicate Records in Oracle
      How to
      Make a Database Using MS Access
      How to
      Download Microsoft Access
      Advertisement

      About This Article

      In other languages
      Thanks to all authors for creating a page that has been read 359,776 times.

      Is this article up to date?

      Advertisement