This article will guide you to enter data into a pivot table in Microsoft Excel. This guide can be followed on Windows and Mac versions of Microsoft Excel.
Step
![Add Data to a Pivot Table Step 1 Add Data to a Pivot Table Step 1](https://i.how-what-advice.com/images/001/image-399-1-j.webp)
Step 1. Double-click the Excel document containing the pivot table
The document will open.
![Add Data to a Pivot Table Step 2 Add Data to a Pivot Table Step 2](https://i.how-what-advice.com/images/001/image-399-2-j.webp)
Step 2. Click the tab containing the data you want to enter (eg Sheet 2) at the bottom of the Excel window
![Add Data to a Pivot Table Step 3 Add Data to a Pivot Table Step 3](https://i.how-what-advice.com/images/001/image-399-3-j.webp)
Step 3. Add or change the data you want to insert into the pivot table next to or below the existing data
- For example, if you already have data in cells A1 through E10, you can enter the data in column F or in row 11.
- If you only want to change the data that appears in the pivot table, change that data in the active worksheet.
![Add Data to a Pivot Table Step 4 Add Data to a Pivot Table Step 4](https://i.how-what-advice.com/images/001/image-399-4-j.webp)
Step 4. Return to the tab containing the pivot table by clicking on the tab name
![Add Data to a Pivot Table Step 5 Add Data to a Pivot Table Step 5](https://i.how-what-advice.com/images/001/image-399-5-j.webp)
Step 5. Click the pivot table to select it
![Add Data to a Pivot Table Step 6 Add Data to a Pivot Table Step 6](https://i.how-what-advice.com/images/001/image-399-6-j.webp)
Step 6. Click the Analyze button in the middle of the green ribbon in the Excel window
You will see a new toolbar below the ribbon.
If you are using a Mac, click the tab PivotTable Analyze.
![Add Data to a Pivot Table Step 7 Add Data to a Pivot Table Step 7](https://i.how-what-advice.com/images/001/image-399-7-j.webp)
Step 7. Click the Change Data Source button in the "Data" section of the "Analyze" toolbar
You will see a drop-down menu.
![Add Data to a Pivot Table Step 8 Add Data to a Pivot Table Step 8](https://i.how-what-advice.com/images/001/image-399-8-j.webp)
Step 8. From the menu, click Change Data Source…
A new window will open.
![Add Data to a Pivot Table Step 9 Add Data to a Pivot Table Step 9](https://i.how-what-advice.com/images/001/image-399-9-j.webp)
Step 9. Select your data
Click and drag the cursor from the top left cell to the bottom left. Cells containing the data you have entered will be selected as well.
![Add Data to a Pivot Table Step 10 Add Data to a Pivot Table Step 10](https://i.how-what-advice.com/images/001/image-399-10-j.webp)
Step 10. Click OK at the bottom of the window
![Add Data to a Pivot Table Step 11 Add Data to a Pivot Table Step 11](https://i.how-what-advice.com/images/001/image-399-11-j.webp)