Summarise data with a PivotTable

Updated November 13, 2026

Make a PivotTable

  1. Click in your data and choose Insert › PivotTable.
  2. Choose where it goes, then OK. The PivotTable Fields list opens.
  3. Drag fields into Rows, Columns, Values and Filters. Values add up by default. Click a value field to show averages, counts and more.

Change it

Click in the PivotTable to show its tabs:

  • Refresh after the source data changes.
  • Subtotals, Grand Totals and Report Layout change how it’s laid out. PivotTable styles change the look.
  • Calculated Field… adds a field from a formula.
  • Insert Slicer and Insert Timeline add buttons and a date bar to filter it.
  • PivotChart makes a chart from it.
  • Field list shows or hides the fields.

Was this article helpful?