Learn How To Create A Pivot Table With Fewer Clicks With This Microsoft Excel Tutorial

Learn How To Create A Pivot Table With Fewer Clicks With This Microsoft Excel Tutorial
Page content

See all Microsoft Excel tips

Strategy:

This method is only available in Excel 2000 and newer versions.

Follow these steps.

  1. Select a single cell in the original data, as shown in Fig. 911.

  2. From the menu, select Data – PivotTable. Click Finish, as shown in Fig. 912.

You are given a blank pivot table on a new sheet, as shown in Fig. 913.

  1. Drag fields from the field list to the table, as shown in Fig. 914.

**

Summary:

This visual method for creating a pivot table is faster and more intuitive.

Commands Discussed:

PivotTable

**

See all Microsoft Excel tips

Images

Fig. 912

Fig. 913

Fig. 914