How to Enter Data into a Pivot Table: 11 Steps (with Pictures)

Table of contents:

How to Enter Data into a Pivot Table: 11 Steps (with Pictures)
How to Enter Data into a Pivot Table: 11 Steps (with Pictures)

Video: How to Enter Data into a Pivot Table: 11 Steps (with Pictures)

Video: How to Enter Data into a Pivot Table: 11 Steps (with Pictures)
Video: Pivot Table Excel Tutorial 2024, November
Anonim

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

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

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

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

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

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

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

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

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

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

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

Step 11. In the "Data" section of the toolbar, click Refresh

If you add a new column to the pivot table, check the checkbox on the right of the Excel window to display it

Recommended: