Summarise data with a PivotTable
Updated November 13, 2026
Make a PivotTable
- Click in your data and choose Insert › PivotTable.
- Choose where it goes, then OK. The PivotTable Fields list opens.
- 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.