How do I...
Make a pivot table
What to do
- Click any cell in your data.
- Go to Insert, then PivotTable, then click OK.
- In the panel on the right, drag a field to Rows, such as Region.
- Drag a number field to Values, such as Sales.
Good to know
- Each column needs a heading, with no blank columns.
- Pivot tables do not update by themselves. Right-click one and choose Refresh.
- Click the arrow beside a field in Values to switch from Sum to Count or Average.
The idea in general
It sorts a long list into groups and totals each group, with no formulas needed.
What I assumed
- You are using Excel on a computer. Menus can look a little different on a Mac or in a browser.