Paste into Visible Cells Only | Copy Visible Cells and Paste Values Only to Visible Target Cells

Download the featued file here: www.bluepecantraining.com/wp-...
------------------------------------------------------------
Blue Pecan Computer Training Ltd offers on-site or online Excel training for businesses. Training can be delivered at your business premises in the south-east of England or via Teams wherever you are in the world. Visit our training page at www.bluepecan.co.uk
In this video, I demonstrate how to copy visible cells and paste only to visible target cells when using a filtered list in Microsoft Excel. If you do not know this trick you end up pasting over visible and hidden cells.
------------------------

[@mohsinkhan-je7ol]

Thanks a lot Chester. I had watched several videos on You tube regarding the fill option. However your video has provided the solution in most simple and logical way. Thanks a ton.

[@jonathandsouza3927]

I've searched how to do this multiple times in the past and given up. Can't believe it was this easy! Thanks a ton 😁

[@kctechie]

Same here! This issue has been causing me all kinds of headaches and now FINALLY coming across the answer AND it's so easy. Huge relief.

[@FastlaneProductions1]

You'd really think this would be the default behavior.

[@peterchang425]

I am so glad I found your video. The cell colour trick works a treat. You are an Excel GURU! Thank you.

[@hakodak]

Thank you so much.
I was having this issue for a very long time thanks to your video you made my life easier.

[@marybellandry2975]

Love the fill left visible cells only! Thank you sir!

[@user-xh5kw7du6p]

Thank you Chester

[@xpeciesanimales2023]

i lose time searching videos about this in spanish and nothing. You are a master, thanks a lot!!!

[@Matt-dv6sv]

Can't believe this is so hard to do something that looks so simple. Thank you for the tip!

[@SHAYNAxmusic]

Thank you for this video! The only time I've seen this method shared and it has saved me a lot of time & frustration!

[@ianodonoghue6011]

This video has saved me from a huge headache in work. Thanks. Liked and subscribed

[@vamshikrishna8374]

Wow, it is an amazing trick!
You have made my task so easy, thank you!

[@patricklim9051]

Hi, I trying to copy a row of data from Sheet A to Sheet B. Both Sheet has same format with hidden column. Problem is somehow by default when i copy it, the copied data is excluding hidden data. And when i paste it, data will paste on the hidden column. I hope you understood and can advise on it. Thx!

[@andresparins]

Thank you so much man!! I spent 2hrs aprox. trying, you saved me

[@IvanCortinas_ES]

Great trick Chester! Thank you!

[@BBBBBBBBBB1232342343]

Great video, very helpful ways to overcome this flaw in Excel

[@muostapher]

Amazing trick. saved me a lot of time. Thanks!

[@krzysztofgacek5633]

You just saved me a TONE of time ! - THANKS A LOOT !

[@coolguy5726]

The only answer I could find that worked. Thank you so much

[@minkymomo2242]

Finally, the hero we were waiting for 😃 Thanks a lot!

[@fosterjovin4893]

Many thanks, you are a life saver. This is exactly what I was looking for.

[@jahnobidas5000]

Thank you so much!! Was looking everywhere for this

[@tashchirume5171]

Thanks so much I did it within seconds after endless tries from others. Well done

[@alwinweinman7852]

This is a huge help, thanks Chester!

[@yusuvyasar]

You’re a life saver, good sir!

[@SlickLikeSamson]

Thank you sir. Yours was the only video that was helpful to me.

[@rexbk]

Beautiful! Thanks

[@vinodjames2007]

Thank you so much, you are a life saver. This is exactly what I was looking for more than 2 years

[@nancys.5968]

You've made my life so much easier 🙂 Thank you!

[@a.j.wilkes6352]

That was a helpful Excel tip.

[@lcitpublicschool987]

thanks for sharing this valuable trick.

[@TranquilUniverseExploration]

Fabulous! You saved me finally!

[@salomebeshidze8376]

smart solution, I would add another column with 1,2,3 and so on and you can use this one to sort back to original order.

[@emmalungulesei9418]

Very useful! Thank you!

[@RA-lc5ed]

Good video. Is there another way to paste values from a sheet into a filtered table in another sheet without removing the filters first? This particular document has many columns with preset filters so it can get messy... Thanks

[@pulkitanand9854]

This. Did you figure this out ?

[@SpotlightImpact]

Great video Chester, thank you. This was exactly what I was looking for today!

[@TNCMusicS]

Thank you soooo much!!!!!

[@digitalmarketerREI]

Thank you so much. I was working on it almost 2 days to figure this out.

[@lalbabusingh4815]

Thanks Chester, helpful!!

[@souravtewari4597]

Superb trick 👌
Thank you 😊

[@JaspreetSingh-it2ny]

thanks buddy, finally found the video i was searching :)

[@saleemabbas3573]

Thanks you save lot of time

[@deepagrawal9304]

Nice Trick!Thanku

[@dananjaya3784]

Great video, thank you Sir :)

[@khengratha3264]

Thank for video, How? If I suppose to copy only data from original cell which calculate by formula?

[@anidia88]

omg, It took me so long to understand for this issue, way around but it worked. Thanks a lot.

[@noushadmadathil9715]

Thank you sir really helpful

[@akashlakhani9069]

Sort option are great, thank you

[@miqueenmattox2225]

This was great. Thank you.

[@dieu-donneamoussouga3970]

Fantastic!

[@ubaidillahmuhammad20]

loved it

[@resumezak3188]

Genius is an understatement mate .. Saved my life with the yellow sort trick 🙏👍

[@pardawala_Bhiwandi]

Yes this is exactly i want to do....many thanks...iam from india

[@limbikaningulube1795]

Question is how do i put back the rows according to the order it was in ?

[@cameronhampton1315]

Thank you Sir!

[@alfredgan3911]

Thanks, make life more easier.

[@noora974]

Ok but for the 2nd part of video how do we resort the cell to how they were before after we copy pasted?

[@renonsuerte8275]

what i want to fill using the values but not the formula? (technically filling using paste special)

[@daynacox1439]

sooooo helpful!

[@deividaspelenis7124]

Thank You!

[@dmitryisanov8511]

Great guidance! Saved me tons of time!
Thanks a lot!

[@saintsxyz]

Amazing video !!!

[@amlanbeharidey8408]

Is there a way to paste let say 10 values copied from an Unfiltered column into a filtered column (of course the visible number of rows are 10 to fit the copied data perfectly..)
filtered to filtered copy is not an issue.
i am talking about unfiltered to filtered copy-paste of same size space

[@cikhikmahabu]

thanks for guidance its help me so much! i have subscribed ur chanel =)

[@lisa5451]

Thank you!

[@sunainagul1]

Thank you so much Dear for the perfect solution.

[@ZahidaParveen-hb5je]

Ma Sha Allah, very nicely explained

[@danielaacomo]

Thanks a lot!

[@maravarmanmanoharan3300]

Thank you very much

[@katharinasauber1]

Saving the day!

[@yashvaja2898]

what to do if i have to copy multiple columns and to shift all that Columnssimultaneously

[@KingOTheHill33]

Cell color "trick" ftw! Thanks!

[@ChesterTugwell]

👍

[@joestatham7106]

My saviour, thanks for the vid

[@ChesterTugwell]

Glad I could help

[@putriululazmi5898]

great! thank you so much😀

[@vnarayan1]

we can use column also right? can you pls show us that.

[@furkankilicaslan]

Great content! I just have a question. After the pasting, how do you remove this sorting? My data has to become to its orijinal format which is before the sorting.

[@cyrilhui5645]

you can try adding a new column with accending #, proceed with the pasting, and sort the index # to return to its original order

[@phamkhoa8371]

thank you so much

[@utekevin]

Genius!! +++

[@jumokeolantunadeyemi2425]

Found it useful

[@gurvindersran4602]

Thank you

[@pardawala_Bhiwandi]

It's amezing

[@wesleyharper3253]

Thanks

[@saivinodattili7776]

Awesome

[@happydong8086]

brilliant

[@missinglink2416]

thanks

[@minamishail_Tech2024]

I have filtered values which I want to copy to another filtered cells ( same count of cells)

[@Steve-bc2cl]

THANK YOU OMG you just earned a sub

[@Sindhu-qy1gd]

How to put those top sorted 3 rows back to their original places?

[@IanBillJustineCabarles]

how to go back to where it used to be after sorting by color?

[@pardawala_Bhiwandi]

Wow Sir

[@newenglandlibraryassociati3446]

This isn't working for me for some reason😩 I selected a blank column first because I want to paste into that blank column, then I highlighted the column that I want to copy from, and did fill, and it filled with values from another column in my spreadsheet that was not highlighted. I also ideally want to copy and paste a column that has a formula in it and paste just the values. Why the heck did Excel make this so complicated!?

[@yuniszahr937]

But I don't want to disrupt the filtering, especially when sorted alphabetically. Is there another way that you can past in filtered cels without getting rid of the filter?

[@soulcrash6763]

yes its not in there

[@gan13166]

What.. it changes the row order ..need to paste in to only visible cells without changing the row order

[@ckcng]

I can't sort the list, how can i do it?

[@contactkvce]

Thank a lot

[@viviennefung11]

謝謝！

[@ChesterTugwell]

Many thanks

[@mjawadhaidermjawadhaider9109]

How to paste into other sheet!

[@amitshukla7461]

thanks cell colour is working

[@HeySay3]

what if the items are not side by side?

[@martingallegogomez1223]

What happens if in column C you have formulas and in column B you want to paste only the values? I tried the method but I get NA? How can I paste only the values?

[@japneetsingh014]

Did you find this?