How to create a pivot table in Excel
Interactive walkthrough — 6 steps. Click through at your own pace.
Your version:
AutoSave ●Book1 — Excel—▢✕
HomeInsertPage LayoutFormulasDataViewReviewDraw
Clipboard
Font
Alignment
Number
Styles
Cells
Editing
B3fx
Sheet1Ready100%
Simplified simulation — your Excel may show more buttons.
1
Click any cell inside your data — here B3 is selected, shown by the green border.
Excel will detect the full range automatically.
Steps in text
- Click any cell inside your data — here B3 is selected, shown by the green border.
- Click the Insert tab.
- Click PivotTable.
- Confirm the data range and click OK — Excel places the pivot table on a new sheet.
- Drag Region into Rows and Sales into Values.
- The pivot table fills in — one row per region, with its sales totalled.