Paste into visible cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Sometimes you can sort the range first--so that your intended paste range is
nicely grouped.

Then paste.
 
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
 
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 said:
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
Click to expand...
 
how to do DRAG COPY PASTE

ERR229 said:
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 said:
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
Click to expand...
Click to expand...
 
Back
Top