How To Paste to Visible Cells in Excel

Learn a few tips for pasting to a range that contains hidden rows or columns, when you want to copy & paste to the visible cells only. This allows you to skip the hidden rows or columns when pasting. If you are receiving the error message, "This command cannot be used on multiple selections", this video explains a few workaround solutions.

00:00 Introduction
00:40 Select Visible Cells
01:45 Paste Visible

[Christymyre]

I cannot begin to thank you enough for this. I had THOUSANDS of filtered cells I needed to copy and paste for work. This would have taken me FOREVER! Your instructions and video were very clear and easy to follow. i appreciate you r skills!

[fiona]

I have been searching the answer to this question for so long. all the rest videos are showing how to paste in a new sheet. I am so frustrated, until I finally find this video, which gives us a great trick on how to paste in a filtered column. This is great! This is so helpful! Thank you very much for your knowledge and thank you so much for sharing!!!!

[lorraineg]

Paste buddy is a life saver. I had data running into 1800 values which I needed to copy into filtered cells. Thank you.

[keviehendrix]

Hello. I just downloaded the trail version of Paste Buddy....and I copied a sequential column of 255 visible cells located on one tab of my workbook --- and then I pasted this sequential data into another tab within my same workbook, into 255 filtered, but visible blank cells using the Paste Buddy Add-in....and it appeared that my Excel Program locked-up and crashed, but after about 30 seconds, my required data appeared in the 255 filtered, but visible cells! Wow! What a relief! Great Job with this handy Excel add-in!

[crs]

2023 and I’m still looking for this. Thank you 🙏

[오로라-gog]

I will try it tmr. I have been working for 5yrs but every time I struggle with this issue. Hope paste buddy can save my time.

[meradamerada]

I was looking exactly for this in the last 5 hours. Thanks a lot.

[alistairconway]

Brilliant - absolultely brilliant! I have been trying to get this for ages and no other video to date has helped, thank you so much for sharing this

[sammia]

What are we accountant going to do without guys like you who makes our job super fast!

[hgamedia]

finally, i found this video who trully needed the most. ty sir

[stevehunt]

Dude - You are THE MAN! Thanks for sharing this.

[ikiganda]

Thanks alot. I have used the first trick of Ctrl and Enter to populate the visible cells then removed the filter and copied the whole column with formulas and pasted only values all over the same column and it worked fine!

[leos]

Of all the videos I looked for for this issue, this was is simply the best !! Thanks so much :)

[fbmemar]

If you have an issue "pasting" in a visible range from another sheet when you have hidden rows, this is the easiest solution I've found:
See if you can remove the filter and instead, sort your data in a way that you see the cells you want to see on the top of the page; then also sort your source sheet similar to the first sheet.
Now you don't need to paste in the visible range. You just paste in the sorted area where needed.

[barryh]

You are on my christmas card list i have been trying to do this for ages thanks

[nahumndandok]

Thanks for Paste buddy, you are a life saver

[dharmeshpandya]

BHAI BHAI NUMBER.... SOLVED MY PROBLEM

[VP-ypip]

It saved me a lot of time. Thank you 🙏

[pallav]

Thank you so much. You are the saviour.

[Matawfik]

Thank you so much for sharing. This makes my life much easier