Page 155 - Excel Data Analysis

08 537547 Ch07.qxd 3/4/03 12:07 PM Page 141

WORKING WITH PIVOTTABLE REPORTS 7

If you want to copy all values from a PivotTable, If you want to see what values create a data value
you can use the Paste Special option. To copy the on the PivotTable report, you can view a summary
PivotTable, click PivotTable ➪ Select ➪ Entire of the original data values used to create the value.
Table to select the entire PivotTable. After the To view a summary, double-click the cell containing
PivotTable is selected, click Edit ➪ Copy to copy the data value on the PivotTable. Excel creates a
the selection. Select the first cell in the separate worksheet that shows the records from the
worksheet where you want to paste the copy of original database or Excel list that were used to
the PivotTable and click Edit ➪ Paste Special to create the data value.
display the Paste Special dialog box. Click the
Values option ( changes to ) and then click
OK. Excel pastes all of the visible values from the
PivotTable in the new location. Excel does not
copy any values that were hidden due to filtering
to the new location.

"State"

■ The Function Arguments ‡ Type the name of an ■ The PivotTable value
dialog box displays. associated field. displays on the worksheet.
ˇ Type a name for the data ° Type the name of the
field. item.
Á Specify a cell reference to · Repeat steps 7 and 8 for
the PivotTable. all fields and items associated
with the value.
‚ Click OK. 141