Pasting in visible cells only

[Howieben]

I have a list that I would like to copy and paste into a spreadsheet that is
filtered. when I do this, some of the data goes into the hidden rows. Is
there a way to "paste" to visible cells only? I can't seem to do it with the
"select visible cells" function.
Thanks!
Heidi

[Dave Peterson]

Can you sort your data so that the visible rows are grouped together. Then you
could paste to that nice contiguous range.



Howieben wrote:
>
> I have a list that I would like to copy and paste into a spreadsheet that is
> filtered. when I do this, some of the data goes into the hidden rows. Is
> there a way to "paste" to visible cells only? I can't seem to do it with the
> "select visible cells" function.
> Thanks!
> Heidi

--

Dave Peterson

[Per Erik Midtrød]

Select the range you want to paste to an choose to edit - go to and
select visible cells only.

Per Erik

On Thu, 4 May 2006 11:54:02 -0700, Howieben
<[email protected]> wrote:

>I have a list that I would like to copy and paste into a spreadsheet that is
>filtered. when I do this, some of the data goes into the hidden rows. Is
>there a way to "paste" to visible cells only? I can't seem to do it with the
>"select visible cells" function.
>Thanks!
>Heidi