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 🙂

[@tanveerahmed5747]

Superb video, I logged in to RUclips 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!

[@simbarashenindi2233]

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

[@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!!

[@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!

[@UncleAL2006]

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

[@hillaryjones3106]

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

[@ernestchieke900]

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

[@templeexecutivecoaching7384]

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

[@kingsleyemeka2136]

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

[@user-wq2cg8su8p]

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

[@yusubali1116]

Very clearly spoken and easily understandable. Thanks.

[@SimonPedersen1]

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

[@lilibeth.llamadoavena6088]

well explained. Thank you.

[@attiarauf9383]

Overall your way of teaching is very nice

[@sowmyasankar4471]

You are a great teacher. Very useful video

[@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.

[@mohammedyusuf4358]

I really liked the way you explained in a very simple manner... 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!

[@nevilgunatunga]

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

[@pmarie25]

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

[@jaylehyeh2441]

Best video of all time

[@Shannonishere]

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

[@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!

[@ryanlalonde4895]

Very concise description of the feature, thank you!

[@PaulCecchettiMusic1]

So helpful- quick and to the point. Thanks!

[@neruismite]

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

[@abhijitnayak9408]

It's truly informative & very easy to understand

[@chalkie247]

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

[@gyanendrapradhan9823]

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

[@MonkeyPuzzlePWADTeam]

Great explanation, thank you!

[@trumpexcel]

Glad you found it useful!

[@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.

[@jju2131]

Thank you very well explained.

[@sunlifescarletemerald6319]

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

[@c1zacc324]

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

[@dpkoli]

Very simple but very usefull. Thanks a lot.

[@christophergill9239]

GREAT VIDEO!!!!!!

[@trumpexcel]

Thanks.. Glad you found it useful :)

[@jiriblazek3920]

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

[@DiscJokeyDarkSigns]

Thank you for this great video!

[@josiahpaul4238]

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

[@michaelmueller2949]

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

[@wiprovsnl]

Wow super thank you sir it works perfectly

[@ankitjbp0761]

VERY HELPFUL THANKS

[@hamzaabdirizak5646]

That’s so useful thank you 🙏

[@aliav7137]

thank a lot man this was very helpful

[@mikepalmer2709]

Very well explained, most useful, thank you

[@reynald7267]

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

[@ProStreetFalcon1]

It REALLY WORKED ! Thank you.

[@sarahmelton6294]

Thank you - this video was incredibly helpful!

[@Saifullah-yy6ul]

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

[@MARWAN-ABDELFATTAH]

Thank you for your efforts

[@nicollettegyles6859]

Very helpful!

[@1066sgp]

Just what I was looking for...thanks

[@JohnSmithessexfiresafety]

Brililant thankyou - well explained.

[@carolopiyo2487]

Your instruction was excellent. I finally got it!

[@302maaz]

your teaching skill is awesome

[@US-mx6se]

Wonderful beyond limits👌👌👌

[@lopi9560]

Awesome! Thank you!

[@LiaqatAli-bc5mv]

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

[@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?

[@mohamednoorullahyunusansar749]

Very well explained super nice

[@mc-ti5uq]

great explanation. thank you :)

[@cliffnetto]

Simply explained, super easy to understand

[@justchill2436]

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

[@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!

[@sanjayshrestha1935]

Thank you!! I was really searching for this

[@donaldtait5755]

Nice, a really clear how-to. Many thanks!

[@anonymousproxy131]

Thank you - great vid

[@skipdeedon9939]

Thanks so much!

[@finalruner]

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

[@viralvyas9946]

nice video sir , greatly explained

[@twes619]

Thank you! Thumbs up and subbed.

[@fokhrulabedin]

Thank you!

[@prashantjadhav007]

Excellent technique. Thanks for this video

[@marciawright8908]

Thank you 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

[@jsingle76]

This was super helpful! Thanks :)

[@Pratapbrazil]

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

[@judydistrito4026]

Thank you very much

[@cedricagion8249]

Thank you. This video is very helpful.

[@shubhinagpal2657]

Very useful video for me,

[@angmingzhen]

Amazing. Thank you!

[@smitamodi9632]

Perfect explanation and very useful

[@mkgvip]

Very nice and simple way explained, Thanks!

[@sggy8939]

THANK U FOR YOUR GOOD INFORMATION

[@hoteldinameugorje7326]

Thank you, this was the best explanation I have found on youtube ;)

[@angshumanchowdhury5685]

Excellent sir 🙏🙏🙏

[@jiajiaphotography]

Thank you 😊

[@paigequeenb8257]

Perfect. This is exactly what I needed. This would have helped a lot last semester...

[@shihtzufan]

Thanks so much :)

[@stanefreesolutionsptyltd2590]

you are a champion mate thank you

[@gppowis]

Thank you.

[@lindagomes94]

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

[@ericahinwood]

Such a great tutorial, thank you so much!!

[@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.

[@skillsforchildren]

Thanks!

[@tpc2008]

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

[@jenoaj3902]

Thanks a lot

[@nirmalmaharjan1748]

exactly what i was looking for. thanks mate

[@ConstructionEntrepreneurs]

Keep up the great work. This is exactly what I was looking for.