STOP Overwriting Your Drop Lists … Excel In A Capsule (Episode 14)

This is a Bite-Size Excel Tutorial Series targeting anyone on the globe who uses Excel, since I broke the barrier of language and I explain the topic fully in graphics.
In this tutorial I show you how to prevent changes to your Data Validation in Excel whether by Typing or even by Copying and Pasting… No one will be able to copy and Paste in the cells having Drop Lists But Pasting outside the Data Validation works as usual.
You get lots of FREE benefits when you become a member (Totally Free).
To Book a Corporate Training (at client Site in Canada or Remotely anywhere in the World) visit my website:
Finally, if you find value in my tutorials, you can support my Channel by hitting the Like button, Sharing, dropping a comment and subscribe, to be notified when new tutorials are released… The Best Is Yet To Come.
Now let’s explore How To Prevent Any unwanted Changes to our Drop Lists

[IvanCortinas_ES]

Wowwww. Every day a new surprise. Thank you Nabil!

[GodWillIncreaseNitzborn]

Wow, I can't wait to build in this restriction on my trackers my staff are using... It has been the most frtmustrating thing for me when they could CopyPaste over dropdown lists... PRAISE BE TO THE LORD for this tutorial!!!

[newlifenew]

Wow! it is very helpful. I have been searching for more than a week, but this video satisfied my need! Thank you!

[sunnybaggu]

Background score is soothing... artistic way

[zaighamuddinfarooqui]

Awesome, I was so disturbed due to the problem you have just solved. You are so nice Nabil.

[sudeepmodak]

Amazing. A new learning and a technique from the master. Solves my problem of employee using options other than the ones in the drop down.

[orassiam]

Thank you so much for the amazing explanation.

[davidatayureatazona]

This video has been extremely amazing and very useful to me. My only challenge however is with regards to replicating this action for multiple columns in the same worksheet

[richardbalboa]

Exactly what I was searching for, thank you!

[lilyhong]

Very help and exactly what I am looking for. Great stuff. Thanks.

[kennethdrennon]

Nice production! This video was very helpful to me.

[sakthivel]

My problem..now solved..thanks our helping video...

[jamesrosicky]

If this is going to work, you are my master!!

[arunarrow]

Fine it will work for only on that sheet itself, if user copy paste data from other sheet or workbook it will take at that time
So, please add dynamic VBA code

[santisisma]

fantastic! clear and precise. Thanks very much..

[DPete]

Be aware that you can still copy paste content into these cells if you start your paste outside the range. ie, if a user copies cells A5:D5, they can paste that range into A6:D6.

[malikastar]

Thank you, that's really interesting !

[chanti]

Hi how can I select multiple rows for blocking cut copy paste in this .. please guide

[SamehRSameh]

Marvelous code i was need it so much thanks alot

[khanabdussabur]

Dear Nabil, I am grateful that I have learned so much from Excel through you. This video of yours is awesome but can the work be done by formula or any other way? I would have benefited a lot if you had informed me if possible. Stay well, stay healthy, God bless you.