Pasting in visible cells only

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

Guest

I have a list that I would like to copy and paste into a spreadsheet that is
filtered. when I do this, some of the data goes into the hidden rows. Is
there a way to "paste" to visible cells only? I can't seem to do it with the
"select visible cells" function.
Thanks!
Heidi
 
Can you sort your data so that the visible rows are grouped together. Then you
could paste to that nice contiguous range.
 
Select the range you want to paste to an choose to edit - go to and
select visible cells only.

Per Erik
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Paste visible cells? 8
How to copy and paste only visible cells from Excel using vbscript 0
Disabling copy/paste hidden cells 4
Problem with Pasting into Filtered Fields 2
copy visible cells 1
visible cell only 1
Do not paste in hidden cells 9
How do I VLookup visible cells only? 2

Back
Top