Paste into visible cells

[Guest]

I have a situation where I'm trying to copy a range (e.g. A15) 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?

 

[Dave Peterson]

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

Then paste.

 

[toom]

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

 

[Guest]

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

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

 

[R..VENKATARAMAN]

how to do DRAG COPY PASTE

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

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