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 

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

Dave,
that was it, many thanks!
Regards,

H.G. Lamy

"Dave Peterson" <petersod@verizonXSPAM.net> wrote in message 
news:4B0199F1.EBAD3361@verizonXSPAM.net...
> 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