Microsoft Office Tutorials and References
In Depth Information
The Create PivotTable
dialog box appears.
4
Click a data source
(
changes to
).
If you selected a
range in the current
workbook, the range
appears here.
l
4
5
Click to select where
to place the report
(
5
changes to
).
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
location.
l
6
6
Click OK.
Excel opens the PivotTable Field List.
l
The PivotTable tools become available.
l
Delete It!
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.
Caution!
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
or row.
Chapter 5: Explore the Patterns in Your Data
111
 
Search JabSto ::




Custom Search