Create a PivotTable

Create a PivotTable

1. Select the cells you want to create a PivotTable from.

2. Go to Insert > PivotTable.
<screenshot here>

3. Under Select Data Location and Range, choose Cell sheet or Database
<screenshot here>

4. In Range, verify the cell range.

5. Under Select Location for Inserting PivotTable, choose New Worksheet to place the PivotTable in a new worksheet or Existing Worksheet and then select the location you want the PivotTable to appear, and then choose Run.

6. To add a field to your PivotTable, select the field name checkbox in the PivotTables Field List.
<screenshot here>

Selected fields are added to their default areas: non-numeric fields are added to Row Area, date and time hierarchies are added to Column Area, and numeric fields are added to Data Area.

7. To move a field from one area to another, drag the field to the target area.

Was this article helpful?
0 out of 0 found this helpful