Practical guide

Create Your First Excel PivotTable

A PivotTable summarizes rows without changing the source data. A tidy, rectangular table makes the most reliable starting point.

What to do

  1. Check that the data has one header row, no blank header names, consistent columns, and no completely blank rows inside the dataset.
  2. Select a cell in the data and choose Insert > PivotTable. Confirm the range and choose a new worksheet for the summary.
  3. Drag fields into Rows, Columns, Values, or Filters. For a numeric field in Values, verify whether Excel is using Sum or Count.
  4. Refresh the PivotTable after editing the source data. Convert a growing source range to an Excel Table so new rows are easier to include.

Checks and limitations

  • Mixed text and number values in a column can cause Excel to count instead of sum.
  • A PivotTable is a summary, not a live replacement for row-level records; preserve and protect the source data.