Pasting in visible cells only
 

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

Pasting in visible cells only
 

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

Pasting in visible cells only
 

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
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