copying subtotals in Pivot tables

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.


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

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

"Debra Dalgleish" wrote:

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

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

Tab wrote:
> Ms Debra: Great Advise. It worked and I appreciate it very much. Have a great
> day.
> Tab
>
> "Debra Dalgleish" wrote:
>
>
>>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.
>>
>>
>>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
>>
>>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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

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.


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

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

"Debra Dalgleish" wrote:

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

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

Tab wrote:
> Ms Debra: Great Advise. It worked and I appreciate it very much. Have a great
> day.
> Tab
>
> "Debra Dalgleish" wrote:
>
>
>>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.
>>
>>
>>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
>>
>>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html