Create a PivotTable in Excel

1. Open your Excel spreadsheet, select the cells you want to create a PivotTable from.

Note:  Your data shouldn't have any empty rows or columns. It must have only a single-row heading.

2. Select Insert > PivotTable.

3. Under Choose the data that you want to analyze, select Select a table or range.

4. In Table/Range, verify the cell range.

5. Under Choose where you want the PivotTable report to be placed, select New worksheet to place the PivotTable in a new worksheet or Existing worksheet and then select the location you want the PivotTable to appear.

6. Select OK.



Was this helpful?
0 reviews


Article ID: 133908
Tue 7/6/21 9:22 AM
Mon 7/12/21 1:30 PM