Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
copying subtotals in Pivot tables
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 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 |
#4
|
|||
|
|||
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 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 -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
bring back ability to format subtotals in pivot tables | Excel Discussion (Misc queries) | |||
Macro for Pivot Tables | Excel Discussion (Misc queries) | |||
Copying sheets with pivot tables | Excel Worksheet Functions | |||
Product Function in Pivot Tables from Multiple Consolidation Range | Excel Worksheet Functions | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) |