Pasting in visible cells only

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
 
D

Dave Peterson

Can you sort your data so that the visible rows are grouped together. Then you
could paste to that nice contiguous range.
 
P

Per Erik Midtrød

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
Do not paste in hidden cells 9
How do I VLookup visible cells only? 2
visible cell only 1
Problem with Pasting into Filtered Fields 2
How to copy and paste only visible cells from Excel using vbscript 0
copy visible cells 1
Pasting to visible cells only? 1

Top