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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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