Copy only visible cells after applying "Subtotals"
 

Hello,

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

Copy only visible cells after applying "Subtotals"
 

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.



"H.G. Lamy" wrote:

Hello,

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

Copy only visible cells after applying "Subtotals"
 

Dave,
that was it, many thanks!
Regards,

H.G. Lamy

"Dave Peterson" wrote in message
...
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.



"H.G. Lamy" wrote:

Hello,

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