Paste into visible cells

I have a situation where I'm trying to copy a range (e.g. A1:D5) into a
sheet with hidden rows. I cannot find a way to paste into visible cells only.
(I can copy FROM visible cells only, but cannot paste TO visible cells only).

Does anyone know if there is a way to do this?
--
ERR229

Sometimes you can sort the range first--so that your intended paste range is
nicely grouped.

Then paste.

ERR229 wrote:
>
> I have a situation where I'm trying to copy a range (e.g. A1:D5) into a
> sheet with hidden rows. I cannot find a way to paste into visible cells only.
> (I can copy FROM visible cells only, but cannot paste TO visible cells only).
>
> Does anyone know if there is a way to do this?
> --
> ERR229

--

Dave Peterson

Pasting into a filtered view doesn't work because when you click paste,
excel pastes into a contiguous vertical range, not just the visible
cells. However you can drag-copy paste to or from a contiguous column
and only the visible rows will get changed. I guess in this case you
are actual copying and pasting across columns rather than up and down
them so the hidden data remains unchanged and the invisible rows get
ignored. If you are working within the same worksheet this might be
useful to know.

toom



Dave Peterson wrote:
> Sometimes you can sort the range first--so that your intended paste range is
> nicely grouped.
>
> Then paste.
>
> ERR229 wrote:
> >
> > I have a situation where I'm trying to copy a range (e.g. A1:D5) into a
> > sheet with hidden rows. I cannot find a way to paste into visible cells only.
> > (I can copy FROM visible cells only, but cannot paste TO visible cells only).
> >
> > Does anyone know if there is a way to do this?
> > --
> > ERR229
>
> --
>
> Dave Peterson

Toom,

Thanks. That's a great thing to do within a single sheet. Unfortunatlely,
this copy and paste is across sheets. Ah well, Excel can't do everything!

--
ERR229


"toom" wrote:

> Pasting into a filtered view doesn't work because when you click paste,
> excel pastes into a contiguous vertical range, not just the visible
> cells. However you can drag-copy paste to or from a contiguous column
> and only the visible rows will get changed. I guess in this case you
> are actual copying and pasting across columns rather than up and down
> them so the hidden data remains unchanged and the invisible rows get
> ignored. If you are working within the same worksheet this might be
> useful to know.
>
> toom
>
>
>
> Dave Peterson wrote:
> > Sometimes you can sort the range first--so that your intended paste range is
> > nicely grouped.
> >
> > Then paste.
> >
> > ERR229 wrote:
> > >
> > > I have a situation where I'm trying to copy a range (e.g. A1:D5) into a
> > > sheet with hidden rows. I cannot find a way to paste into visible cells only.
> > > (I can copy FROM visible cells only, but cannot paste TO visible cells only).
> > >
> > > Does anyone know if there is a way to do this?
> > > --
> > > ERR229
> >
> > --
> >
> > Dave Peterson
>
>

how to do DRAG COPY PASTE

"ERR229" <ERR229@discussions.microsoft.com> wrote in message
news:7655CF67-C1CE-4FAE-80A6-877709AEB6AF@microsoft.com...
> Toom,
>
> Thanks. That's a great thing to do within a single sheet. Unfortunatlely,
> this copy and paste is across sheets. Ah well, Excel can't do everything!
>
> --
> ERR229
>
>
> "toom" wrote:
>
>> Pasting into a filtered view doesn't work because when you click paste,
>> excel pastes into a contiguous vertical range, not just the visible
>> cells. However you can drag-copy paste to or from a contiguous column
>> and only the visible rows will get changed. I guess in this case you
>> are actual copying and pasting across columns rather than up and down
>> them so the hidden data remains unchanged and the invisible rows get
>> ignored. If you are working within the same worksheet this might be
>> useful to know.
>>
>> toom
>>
>>
>>
>> Dave Peterson wrote:
>> > Sometimes you can sort the range first--so that your intended paste
>> > range is
>> > nicely grouped.
>> >
>> > Then paste.
>> >
>> > ERR229 wrote:
>> > >
>> > > I have a situation where I'm trying to copy a range (e.g. A1:D5)
>> > > into a
>> > > sheet with hidden rows. I cannot find a way to paste into visible
>> > > cells only.
>> > > (I can copy FROM visible cells only, but cannot paste TO visible
>> > > cells only).
>> > >
>> > > Does anyone know if there is a way to do this?
>> > > --
>> > > ERR229
>> >
>> > --
>> >
>> > Dave Peterson
>>
>>