Click the worksheet containing the data for the pivot table and select all the cells with data. The Select a table or range option is automatically selected. On the Insert tab, click the Pivot Table option. The new worksheet is where the pivot table is created.Ĭreate, delete, rename, copy, and move a worksheet in Excel. Open the Excel spreadsheet containing the data you want to use to create a pivot table.Ĭreate a new, blank worksheet in the spreadsheet.

To create a pivot table in Microsoft Excel, follow the steps below. To create or edit a pivot table from your data, click the appropriate link below. It works with small or large amounts of spreadsheet data to manipulate and organize data for review and to find trends and insights. Microsoft Excel is a popular program for creating pivot tables. In business, pivot tables are frequently used to provide an overview of sales data or business costs. It’s often used as a way to quickly view totals, provide average values, or display data in a categorized method for review. A pivot table is a summary of a larger set of information stored in a spreadsheet or database.

Pivot tables in excel values