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

M

Mj

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
 
M

Mj

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
 

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

Top