How to Add Data to a Pivot Table

Easy guide to update your pivot table

Written by Jack Lloyd

Last Updated: August 31, 2023 Tested

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

Download Article

{"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.
{"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
{"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>"}

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, alter the data here.
{"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.
{"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.
{"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>"}

6
Click the Analyze tab. 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.
{"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.
{"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.
{"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.
{"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.
{"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>"}

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 in the right side of the Excel window to display it.

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

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

Submit

Thanks for submitting a tip for review!

Log in

How to Add Data to a Pivot Table

Steps

Community Q&A

Video

Tips

You Might Also Like

About This Article

Is this article up to date?

Quizzes

You Might Also Like

Featured Articles

Trending Articles

Featured Articles

Featured Articles

Watch Articles

Trending Articles

Explore Categories