Click and drag the Sales field into Value Fields section of the Pivot Table.

To create this article, 48 people, some anonymous, worked to edit and improve it over time.

This article received 20 testimonials and 80 of readers who voted found it helpful, earning it our reader-approved status.

They can sort, count, and total the data, and are available in a variety of spreadsheet programs.

Excel allows you to easily create pivot tables by dragging and dropping your relevant information into the appropriate boxes.

You can then filter and sort your data to find patterns and trends.

A Pivot Table allows you to create visual reports of the data from a spreadsheet.

You can perform calculations without having to input any formulas or copy any cells.

You will need a spreadsheet with several entries in order to create a Pivot Table.

In order to take advantage of the pivot table features, your spreadsheet should meet some basic criteria: 1.

This basically just means that at least one column should have repeating data.

In the example discussed in the next section, the Product Type column has two entries: Table or Chair.

In the example in the next section, the Sales column has numerical data.

Click the PivotTable button on the left side of the Insert ribbon.

By default, Excel will select all of the data on your active spreadsheet.

You can click and drag to choose a specific part of the spreadsheet, or you can type the cell range in manually.

After selecting your range, choose your location option from the same window.

By default, Excel will place the table on a new worksheet, allowing you to switch back and forth by clicking the tabs at the bottom of the window.

You can also choose to place the Pivot Table on the same sheet as the data, which allows you to pick the cell you want it to be placed.

Your Pivot Table will be placed and the interface will change.

Drag a field from the Field List on the right onto the Row Fields section of the Pivot Table to insert the information.

You have a spreadsheet with the number (Sales) of each product (Product Type) sold in your five stores (Store).

You want to see how much of each product is sold in each store.

To see how much of each type of product was sold, drag the Product Type field to the Column Fields section.

Excel Pivot Tables For Mac