Microsoft Office Tutorials and References
In Depth Information
The Create PivotTable
dialog box appears.
Click a data source
If you selected a
range in the current
workbook, the range
Click to select where
to place the report
If you want to place
the list in the existing
worksheet, click the cell
in which you want to
place the list, or type a
Excel opens the PivotTable Field List.
The PivotTable tools become available.
If you want to remove a PivotTable from your
worksheet, click anywhere in the PivotTable.
The PivotTable tools become available. Click the
Options tab. Click Select in the Actions group.
A menu appears. Click Entire Table. Excel selects
the entire table. Press the Delete key. Excel
deletes your PivotTable.
PivotTables are based on lists. When creating a
PivotTable, do not use a list with blank columns
or rows. Excel may not create the PivotTable
correctly if the list includes a blank column
Chapter 5: Explore the Patterns in Your Data