How to Build a Pivot Table From Scratch
Intermediate
How-To · Excel
Summarize a large dataset into totals, averages, and counts without writing a single formula.
- Make sure your source data has clear column headers in row 1 with no blank rows or columns inside the range.
- Click anywhere inside your data, then Insert > PivotTable, and choose to place it in a new worksheet.
- In the PivotTable Fields pane, drag the field you want to group by (like "Region") into the Rows box.
- Drag the field you want to summarize (like "Sales") into the Values box — it defaults to Sum, which you can change to Average, Count, etc. by clicking the dropdown.
- Drag an additional field into the Columns box if you want a second dimension, like breaking Sales down by Region and Month at once.
- Right-click any value and choose "Value Field Settings" to change how it's calculated, or "Group" on a date field to roll daily data up into months or quarters.
Running into an error instead of just needing the how-to? Check our Excel troubleshooting guides or the error lookup.
Frequently Asked Questions
Will a pivot table change my original data?
No — a pivot table summarizes your data in a separate view without modifying the source data it's built from. You can delete the pivot table entirely and your original data stays untouched.
Do I need to update the pivot table manually if my data changes?
Yes — pivot tables don't update automatically when source data changes. Right-click the pivot table and choose Refresh, or set it to refresh automatically when the file opens.
More Excel how-tos
How to Build a Simple Budget Spreadsheet
Set up a working monthly budget with income, expenses, and an automatic running total.
How to Pull Data From Another Sheet With XLOOKUP
Look up a value in one table and pull back matching information from another — the modern replacement for VLOOKUP.
How to Freeze Rows or Columns So Headers Stay Visible
Keep your header row (or a key column) on screen while you scroll through a long sheet.