copying subtotals in Pivot tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
Ms Debra: Great Advise. It worked and I appreciate it very much. Have a great
day.
Tab
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average of Subtotals in Pivot Table 0
Don't show all Pivot table subtotals 1
Subtotal based on a range of data in Pivot Table 5
Pivot Table with Quarter Subtotals across the top 1
Subtotal of adjacent coloumn 4
Subtotal percents in pivot table 1
% of subtotal in pivot tables 1
calculating subtotals for sequential blank cells in 1 column 1

Back
Top