Lock Cells that have Formulas in Excel (Easy Steps)

[@bevhales6951]

I've used Excel for years at a basic level but have never heard a clearer, better explanation than this about locking cells. I've constantly wondered why, if I have to lock the cell to protect it, the box was already ticked when I went to format. Now I finally understand and you've saved me so much confusion. Thank you so much for taking the time to make this video - I've subscribed as I know I'll learn far more from you as time goes on :)

[@trumpexcel]

Thank you so much for the kind words. Glad you found the video useful 🙂

[@simbarashenindi2233]

Wow... clear and straight to the point. You are undisputedly one of the world's best. Hats off to you

[@tanveerahmed5747]

Superb video, I logged in to UA-cam again just to like this video.
the unique thing about you is you stick to the point unlike beating about the bush as others.
Thank you very much!

[@ab500a2]

OMG, Thank you, thank you, thank you!!!!! I have been trying to figure out how to do this for MONTHS!! Couldn't find any useful videos or tutorials and then I just happen to come across your video and you explain it so perfectly!! Thank you so so so so much!!

[@UncleAL2006]

Clear and concise - others just seem to babble on and on. Thank you for making this so clear.

[@Aggiemayson]

the select-all-corner-arrow was one of the most useful tools I ever learned. You can do so much with it. I'm suuuuper glad someone has made a video using that tool. Excellent!

[@ernestchieke900]

You are a great tutor. I now understand the concept of Locked and protected cell. Thank you.

[@lilibeth.llamadoavena6088]

well explained. Thank you.

[@attiarauf9383]

Overall your way of teaching is very nice

[@yusubali1116]

Very clearly spoken and easily understandable. Thanks.

[@kingsleyemeka2136]

Sir, God bless you...
You're truly a wonderful teacher... Your explanation are very clear...

[@wiprovsnl]

Wow super thank you sir it works perfectly

[@sowmyasankar4471]

You are a great teacher. Very useful video

[@templeexecutivecoaching7384]

This tutorial was created two years ago, and it's still awesome!

[@user-wq2cg8su8p]

love the tip about selecting all formulas, you saved me a coffee break :-)

[@christophergill9239]

GREAT VIDEO!!!!!!

[@trumpexcel]

Thanks.. Glad you found it useful :)

[@SimonPedersen1]

Spot on. Very useful. Clear and concise language. Many thanks!

[@hillaryjones3106]

I like that you quickly go over the concept within excel as well as the steps. Thank you!

[@justchill2436]

Superb Yaaaaar Thanks Yaaar Very Much Thank you Thank you Thank you

[@jju2131]

Thank you very well explained.

[@jaylehyeh2441]

Best video of all time

[@nevilgunatunga]

it was very clear to understand. thanks to the publisher.

[@hamzaabdirizak5646]

That’s so useful thank you 🙏

[@aliav7137]

thank a lot man this was very helpful

[@mohammedyusuf4358]

I really liked the way you explained in a very simple manner... Very helpful

[@hmroque4382]

Thank you for a clear step by step instruction. Just a question: what if I want to insert a row between protected cells. For example, it is a list of resale items and I need to add a new item? Do I unprotect all first and redo protection all over again.

[@JohnSmithessexfiresafety]

Brililant thankyou - well explained.

[@pmarie25]

Thank you !! I’m tired of other co-workers changing shared reports!

[@MonkeyPuzzlePWADTeam]

Great explanation, thank you!

[@trumpexcel]

Glad you found it useful!

[@Shannonishere]

Just what I was looking for. Thank you!!!

[@ankitjbp0761]

VERY HELPFUL THANKS

[@lopi9560]

Awesome! Thank you!

[@ryanlalonde4895]

Very concise description of the feature, thank you!

[@US-mx6se]

Wonderful beyond limits👌👌👌

[@nicollettegyles6859]

Very helpful!

[@DorothyGaleRoofingGroup]

Your a beast! Thanks, this just saved me tons of re-occurring work with finding and selecting cells with formulas.

[@trumpexcel]

Glad you found it useful!

[@viralvyas9946]

nice video sir , greatly explained

[@abhijitnayak9408]

It's truly informative & very easy to understand

[@PaulCecchettiMusic1]

So helpful- quick and to the point. Thanks!

[@sunlifescarletemerald6319]

Excellent video sir, thank you so much. Clear and thorough.

[@neruismite]

I have been looking of this since long. Amazing Explanation. Keep the good work

[@mc-ti5uq]

great explanation. thank you :)

[@anonymousproxy131]

Thank you - great vid

[@chalkie247]

I found this video VERY useful...thank you very much!

[@gyanendrapradhan9823]

This was exactly what I was looking for...thanks a ton

[@twes619]

Thank you! Thumbs up and subbed.

[@billowabdi6346]

Thanks so much. I like your method of teaching especially how you explain concepts. I always feel bad when I don't find my search from among your videos. Kudos and keep on with the great work.

[@DiscJokeyDarkSigns]

Thank you for this great video!

[@michaelmueller2949]

Great video that allowed me to figure out what I needed to know. Thank you

[@dpkoli]

Very simple but very usefull. Thanks a lot.

[@skipdeedon9939]

Thanks so much!

[@jiriblazek3920]

Exellent, just what I was looking for. Many thanks.

[@LiaqatAli-bc5mv]

Great.. Great... Great...Awesome...found what I wanted..Thanks

[@fokhrulabedin]

Thank you!

[@reynald7267]

Very Helpful to me... Thank you so much!!!!

[@shubhinagpal2657]

Very useful video for me,

[@marciawright8908]

Thank you so much.

[@mohamednoorullahyunusansar749]

Very well explained super nice

[@Abqscanner]

Great video! Thank you for explaining it so clearly! Appreciate the tip to select all cells with formulas. Saved me a ton of time!

[@sarahmelton6294]

Thank you - this video was incredibly helpful!

[@1066sgp]

Just what I was looking for...thanks

[@mikepalmer2709]

Very well explained, most useful, thank you

[@Saifullah-yy6ul]

very helpful just what you need to know to the point shot and precise thank you !!

[@sachinkumar-kg4fu]

super thanks sir

[@ProStreetFalcon1]

It REALLY WORKED ! Thank you.

[@carolopiyo2487]

Your instruction was excellent. I finally got it!

[@angshumanchowdhury5685]

Excellent sir 🙏🙏🙏

[@judydistrito4026]

Thank you very much

[@MARWAN-ABDELFATTAH]

Thank you for your efforts

[@maaritvaga9456]

Thank You so much for your very helpful videos. I have been able to perform my work swiftly and accurately as a result. Deepest Thanks!!

[@trumpexcel]

Thanks for commenting Maarit... Glad you found the video useful!

[@josiahpaul4238]

i was doing it wrong all the while and was yelling as to why excel was so complicated lol!
GREAT HELP BRUH!

[@tpc2008]

Thank you so much for this! I wonder how to do the same with Google Sheet?

[@shihtzufan]

Thanks so much :)

[@hinanaz8060]

THANK YOU SO MUCH FOR REALLY INFORMATIVE VIDEO.. I HAVE ONE QUESTION. WHEN WE WILL GIVE THIS SHEET TO ANYBODY ELSE HE OR SHE CAN UNPROTECT THE SHEET?????

[@paultaylor2957]

protect the sheet by using a password and they cant unprotect it unless they know the password

[@jiajiaphotography]

Thank you 😊

[@cliffnetto]

Simply explained, super easy to understand

[@priyankakomreddiwar8641]

Thank u so much.. Can u pls tell me can we lock table formatting and how we can do that?

[@sanjayshrestha1935]

Thank you!! I was really searching for this

[@prashantjadhav007]

Excellent technique. Thanks for this video

[@ayklization]

Superb

[@DoraKage]

thank you for the info. it really helped. im just dissapointed at how user unfriendly the whole process is. i mean, uncheck a checkbox (labeled "lock") to lock a cell instead of the other way around? what the hell?

[@skillsforchildren]

Thanks!

[@gppowis]

Thank you.

[@c1zacc324]

Thank you so much for this! Super clear and very helpful! Love the short handcuts!!!

[@rajdeeprawal597]

Brilliant.

[@jenoaj3902]

Thanks a lot

[@Muslimah-Pakistani]

Thank You Sir...😇👌

[@Pratapbrazil]

Amazing.......deserve like.....

[@finalruner]

Thank you. This video actually helped compared to the other ones. The lock property is weird

[@cedricagion8249]

Thank you. This video is very helpful.

[@jsingle76]

This was super helpful! Thanks :)

[@abdelrahmanessam2484]

U are amazing guy 🥰😍

[@omprakashtiwari9492]

So nice sir thanks

[@mkgvip]

Very nice and simple way explained, Thanks!

[@angmingzhen]

Amazing. Thank you!

[@AbhishekThakur-uh6lc]

This trick is so helpfull...plz tell me one more thing...whenever i want to unprotect the sheet... By just one click on unprotect sheet it opens...i want passwrd evrytime,whenever i want to unprotect the sheet.

[@sggy8939]

THANK U FOR YOUR GOOD INFORMATION

[@lindagomes94]

Such a useful video ..so well explained !!!! Thanks a ton (y)

[@302maaz]

your teaching skill is awesome

[@stanefreesolutionsptyltd2590]

you are a champion mate thank you