Paste Subtotals Only

G

Guest

I use the Subtotals command from the Tools Menu and then use the Outline Bar
to collapse my list so that only the subtotals and grand totals are
displayed. I then want to be able to copy only that information. If I copy
and paste I get all the intervening rows and if I copy and paste special only
values I still get all the intervening rows.

Is there a way to do this?

I am using 2003
 
D

Dave Peterson

After you've collapsed the range, hit Edit|Goto and click Visible cells only.

Then 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

Similar Threads


Top