Subtotals

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?
 
P

Peo Sjoblom

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

Subtotals & Conditional Formatting Part 2 1
how do i pull all subtotals from a spreadsheet 1
How do I copy, paste subtotals only from an Excel list? 2
Presentation 1
Updating subtotals 2
Using the Subtotal function 2
Eliminating particular numbers from a column help! 1
filtering subtotals and if functions 2

Top