How do I copy, paste subtotals only from an Excel list?

G

Guest

After I insert subtotals in a list of 20K lines I collapse to subtotals and
very often want to use the collapsed version only in another spreadsheet. If
I copy, paste values I carry along the details. How do I make a spreadsheet
of the sub and grand totals only?
 
F

Frank Kabel

Hi
after collapsing the data and highlighting the data area:
- hit F5 and click 'Special'
- choose 'visible cells only'
- now copy + paste
 
G

Guest

Thanks for the monumental time saver!

Frank Kabel said:
Hi
after collapsing the data and highlighting the data area:
- hit F5 and click 'Special'
- choose 'visible cells only'
- now copy + paste
Click to expand...
 

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 copy paste 1
Subtotals 1
can i automatically copy subtotals in excel to another s/sheet? 1
Paste Special Values 2
Copying only subtotals 1
How do I copy and paste only the sub-total from a list 3
How do I selectand copy only subtotals in a sheet 1
Paste Subtotals Only 2

Top