copying subtotals in Pivot tables

T

Tab

In a large Pivot table, with 12 subtotals, (each subtotal has a value and a
count), in excel 97, by copying on subtotal to a different cell, yu copied
all the other subtotals. How do you do this in excel 2003?, by copying only
one subtotal.and doing it only once
 
D

Debra Dalgleish

You may have to enable selection (From the Pivot toolbar, choose
PivotTable>Select, and click on Enable Selection)

Then, move the pointer to the left edge of a subtotal heading in the
pivot table.
When the black arrow appears (like the one that appears when the pointer
is over a row button), click to select all the subtotal rows for that
field in the pivot table.
 
Top