Copy and paste subtotals

  • Thread starter Thread starter Jennifer E.
  • Start date Start date
J

Jennifer E.

After using the subtotals function. How can I copy and
paste just the summary section of subtotal (I get to this
section by clicking the 2 button in the right margin)?

Any help is most appreciated.

Thank you.
 
Hi Jennifer,


Go to Edit -> Go To -> and choose 'special' in the "Go to "window.Then
choose "Visible cells only" in the next window.

This will choose only those rows which are visible which is only the
subtotals in your case.Then do a copy and paste it wherever you want.

Regards

Govind.
 
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
Additonal info into newly created Subtotal row 1
Subtotals copy paste 1
Using the Subtotal function 2
Subtotal =0 2
Intercept and Slope of visible rows, please. 0
subtotals 2
Copying Subtotals to new worksheet 2

Back
Top