Building a PivotTable from a blank field list means already knowing what you want to see — rows, columns, values, filters — before you've even looked at the data.
Excel can suggest a starting point instead, based on what it finds in your column headers.
Here's the trick:
Insert > Recommended PivotTables scans your data and offers ready-made summaries instead of building one from scratch.
How to use it
- Click any single cell inside your dataset.
- Go to Insert > Recommended PivotTables.
- Review the handful of suggested summaries Excel proposes — totals by category, by date, and so on.
- Click any thumbnail to insert that PivotTable, then rearrange fields from there if needed.
Where it helps most
Getting a usable summary in seconds when you're not sure yet exactly how you want to slice a dataset, rather than starting from a completely blank field list.
One thing to watch for
The suggestions are based on your column headers and data types, so clear, descriptive column names — not "Column1", "Column2" — produce noticeably better recommendations.
Found a faster way to do this, or a version that works differently on Mac? That's what the comments are for — this section connects to your comment system of choice (Disqus, giscus, etc.) once the site is live.