Subtotals

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

Guest

I have a very large spreadsheet for which I have created subtotals. How can
I copy only the totals without all the detail to another spreadsheet?
 
Minimize the subtotals using the minus buttons to the left, once you have it
as you want, select the whole visible range that you want, press F5, click
special and select visible cells only, click OK and copy and paste it



--
Regards,



Peo Sjoblom
 

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
Subtotal of adjacent coloumn 4
Using the Subtotal function 2
Subtotals & Conditional Formatting Part 2 1
Subtotal Function is Inconsistent 4
How do I get the "subtotal" columns in XL in Office '07? 2
ON SUBTOTAL LINE CARRY FORWARD DENOMINATOR FROM PREVIOUS LINE 1
Additonal info into newly created Subtotal row 1

Back
Top