I feared this might be the case. Many thanks to both of you for your
replies.

V

"Dave Peterson" wrote in message
...
Maybe you can sort your "to" data so that the range to be pasted is
contiguous.
Then do the copy|Paste and then resort your data to put it in the order
you
like.

Victor Delta wrote:

I have an Excel spreadsheet where some of the rows are not visible as
they
are auto-filtered out.

I have a column of 20 cells from another sheet that I want to paste in to
cells in the top 20 visible rows of the first sheet. However, whenever I
try
this using Paste or Paste Values, it fills the top 20 cells including the
invisible rows.

Is there any way I can just paste into the visible rows please?

TIA

V

--

Dave Peterson