Copy only visible cells after applying "Subtotals"


H.G. Lamy


in an XL-list I need to copy only a block of subtotals to another area,
without the detail rows in between. I believe there once was a command like
"paste only visible cells" (or similar), but I can't find a solution.
Anybody who knows how to do this ?

Thank you in advance,

H.G. Lamy

Dave Peterson

You can copy the visible cells.

Show just the subtotals
select the range to copy
Edit|goto (or F5 or ctrl-g)|special|visible cells only

Then edit|copy
and paste where you want.

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