View Single Post
  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

You may have to enable selection (From the Pivot toolbar, choose
PivotTableSelect, 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.


Tab wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html