Prev: Excel Hyperlinks Broken After Windows Update 11/25
Next: vba converters
From: Victor Delta on 25 Nov 2009 13:00
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

From: Excel Nut on 25 Nov 2009 13:12
You cannot do this because the range you are pasting to must be the
same size and shape as the range you are copying from. Also, you
cannot copy from multiple selection range to another multiple-
selection range.

Francis Hayes
www.TheExcelAddict.com
From: Dave Peterson on 25 Nov 2009 15:03
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
From: Victor Delta on 25 Nov 2009 15:19
I feared this might be the case. Many thanks to both of you for your
replies.

V

"Dave Peterson" <petersod(a)verizonXSPAM.net> wrote in message
news:4B0D8D7F.DAE370F0(a)verizonXSPAM.net...
> 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

 | 
Pages: 1
Prev: Excel Hyperlinks Broken After Windows Update 11/25
Next: vba converters