copying subtotals in Pivot tables

[Guest]

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

 

[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.

 

[Guest]

Ms Debra: Great Advise. It worked and I appreciate it very much. Have a great
day.
Tab

 

[Debra Dalgleish]

You're welcome. Thanks for letting me know that it worked.