How to Create a Pivot Table in Excel
Learn how to create pivot tables in Excel step by step. Summarize large datasets, find trends, and build reports — or let AI do it for you instantly.
What Is a Pivot Table?
A pivot table is one of Excel's most powerful features for data analysis. It lets you summarize thousands of rows of data into a compact, interactive report without writing a single formula. Pivot tables can group data by categories, calculate sums, averages, counts, and more — all with drag-and-drop simplicity. Whether you are analyzing sales by region, tracking expenses by month, or comparing product performance, pivot tables turn raw data into actionable insights.
How to Create a Pivot Table Step by Step
First, organize your data in a table with clear column headers and no blank rows. Select any cell in your data range and go to Insert > PivotTable. Excel will auto-detect the range. Choose whether to place the pivot table on a new worksheet or the existing one. Once created, drag fields from the field list into the Rows, Columns, Values, and Filters areas. For example, drag 'Product' to Rows, 'Region' to Columns, and 'Revenue' to Values to see total revenue by product and region.
Common Pivot Table Problems
The most frequent issues include blank cells causing incorrect ranges, date fields not grouping properly, and calculated fields returning errors. Refreshing data after source changes is another common pain point — you must right-click the pivot table and select Refresh, or it will show stale numbers. Formatting is also lost when you refresh unless you check 'Preserve cell formatting on update' in PivotTable Options.
Skip the Manual Work — Let AI Build Your Pivot Table
Building pivot tables manually works for simple cases, but complex multi-level summaries with custom calculations can take hours of trial and error. With ohsheet.ai, you simply upload your Excel file and describe what you need: 'Create a pivot table showing quarterly revenue by product line with percentage of total.' Our AI builds the pivot table, applies formatting, and returns your file in seconds.