Skip to main content

Create pivot table

You can create pivot tables on a new sheet or on an existing sheet.

Insert a pivot table​

  1. Select a cell or the desired range of cells with your data.
  2. On the Insert tab, click the Pivot table button.
  3. Click the Data source field and enter the address or select the range of cells to analyze.
  4. To place the table on a new sheet, select the New sheet option.
  5. To place the table on an existing sheet, select the Existing sheet option, then enter the address or select the desired cell in the Destination cell field.
  6. Click OK.