Lock Cells that have Formulas in Excel (Easy Steps)

In this video, you will learn how to lock cells that have formulas in it in Excel.
Excel formulas are easy to create and edit in Excel.
You can easily edit a formula in a cell through the formula bar or directly in the cell.
While this makes it convenient to create formulas in Excel, it comes with a few disadvantages as well.
Consider this.
You are going through a worksheet full of formulas, and you accidentally hit the delete key or backspace key, or some other number/alphabet key.
Now you'll be lucky if you're able to spot the error and correct it. But if you don't. it may lead to some erroneous results.
And let me tell you this, errors in Excel have cost millions to companies (read this or this).
The chances of such errors increase multifold when you share a file with colleagues or managers, or clients.
One of the ways to prevent this to lock the worksheet, which in turn lock all the cells in the worksheet. However, doing this would prevent the user from making any changes to the worksheet. For example, if you're sending a workbook to your manager for review, you may want to allow him to add his comments or color code cells as his/her feedback.
A better workaround to this is to lock cells that have formulas in Excel.
In this video, you will learn how to lock cells that have formulas in it.
00:00 Intro
00:35 How Locking Cells Work in Excel
02:01 Protect Cells with Formulas
➡️ Read More: trumpexcel.com/lock-formulas-...
Also, I have made all of my Excel courses available for free. You can check these out using the below links:
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-c...
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course
Subscribe to get awesome Excel Tips every week: kzread.info...
#Excel #ExcelTips #ExcelTutorial

Пікірлер: 211

  • @bevhales6951
    @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

    @trumpexcel

    Жыл бұрын

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

  • @ab500a2
    @ab500a22 жыл бұрын

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

  • @simbarashenindi2233
    @simbarashenindi22334 жыл бұрын

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

  • @tanveerahmed5747
    @tanveerahmed57475 жыл бұрын

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

  • @Aggiemayson
    @Aggiemayson3 жыл бұрын

    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
    @UncleAL20064 жыл бұрын

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

  • @ernestchieke900
    @ernestchieke9003 жыл бұрын

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

  • @hillaryjones3106
    @hillaryjones31064 жыл бұрын

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

  • @yusubali1116
    @yusubali11162 жыл бұрын

    Very clearly spoken and easily understandable. Thanks.

  • @billowabdi6346
    @billowabdi63465 жыл бұрын

    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.

  • @kingsleyemeka2136
    @kingsleyemeka21364 жыл бұрын

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

  • @PaulCecchettiMusic1
    @PaulCecchettiMusic13 жыл бұрын

    So helpful- quick and to the point. Thanks!

  • @user-wq2cg8su8p
    @user-wq2cg8su8p4 жыл бұрын

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

  • @templeexecutivecoaching7384
    @templeexecutivecoaching73844 жыл бұрын

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

  • @SimonPedersen1
    @SimonPedersen111 ай бұрын

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

  • @attiarauf9383
    @attiarauf93834 жыл бұрын

    Overall your way of teaching is very nice

  • @sowmyasankar4471
    @sowmyasankar44712 жыл бұрын

    You are a great teacher. Very useful video

  • @ConstructionEntrepreneurs
    @ConstructionEntrepreneurs5 жыл бұрын

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

  • @sunlifescarletemerald6319
    @sunlifescarletemerald63195 жыл бұрын

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

  • @1066sgp
    @1066sgp Жыл бұрын

    Just what I was looking for...thanks

  • @DorothyGaleRoofingGroup
    @DorothyGaleRoofingGroup5 жыл бұрын

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

  • @trumpexcel

    @trumpexcel

    5 жыл бұрын

    Glad you found it useful!

  • @wiprovsnl
    @wiprovsnl4 жыл бұрын

    Wow super thank you sir it works perfectly

  • @sarahmelton6294
    @sarahmelton62944 жыл бұрын

    Thank you - this video was incredibly helpful!

  • @c1zacc324
    @c1zacc3246 жыл бұрын

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

  • @justchill2436
    @justchill24364 жыл бұрын

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

  • @jaylehyeh2441
    @jaylehyeh24412 жыл бұрын

    Best video of all time

  • @jju2131
    @jju21314 жыл бұрын

    Thank you very well explained.

  • @ProStreetFalcon1
    @ProStreetFalcon15 жыл бұрын

    It REALLY WORKED ! Thank you.

  • @nevilgunatunga
    @nevilgunatunga Жыл бұрын

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

  • @US-mx6se
    @US-mx6se Жыл бұрын

    Wonderful beyond limits👌👌👌

  • @MonkeyPuzzlePWADTeam
    @MonkeyPuzzlePWADTeam6 ай бұрын

    Great explanation, thank you!

  • @trumpexcel

    @trumpexcel

    6 ай бұрын

    Glad you found it useful!

  • @carolopiyo2487
    @carolopiyo24874 жыл бұрын

    Your instruction was excellent. I finally got it!

  • @mikepalmer2709
    @mikepalmer27095 жыл бұрын

    Very well explained, most useful, thank you

  • @ryanlalonde4895
    @ryanlalonde48953 жыл бұрын

    Very concise description of the feature, thank you!

  • @michaelmueller2949
    @michaelmueller29495 жыл бұрын

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

  • @Shannonishere
    @Shannonishere3 жыл бұрын

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

  • @JohnSmithessexfiresafety
    @JohnSmithessexfiresafety3 жыл бұрын

    Brililant thankyou - well explained.

  • @christophergill9239
    @christophergill9239 Жыл бұрын

    GREAT VIDEO!!!!!!

  • @trumpexcel

    @trumpexcel

    Жыл бұрын

    Thanks.. Glad you found it useful :)

  • @ankitjbp0761
    @ankitjbp07612 жыл бұрын

    VERY HELPFUL THANKS

  • @cliffnetto
    @cliffnetto6 жыл бұрын

    Simply explained, super easy to understand

  • @ericahinwood
    @ericahinwood4 жыл бұрын

    Such a great tutorial, thank you so much!!

  • @prashantjadhav007
    @prashantjadhav0075 жыл бұрын

    Excellent technique. Thanks for this video

  • @mohammedyusuf4358
    @mohammedyusuf43583 жыл бұрын

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

  • @chalkie247
    @chalkie2472 жыл бұрын

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

  • @DiscJokeyDarkSigns
    @DiscJokeyDarkSigns4 жыл бұрын

    Thank you for this great video!

  • @MARWAN-ABDELFATTAH
    @MARWAN-ABDELFATTAH5 жыл бұрын

    Thank you for your efforts

  • @nicollettegyles6859
    @nicollettegyles6859 Жыл бұрын

    Very helpful!

  • @mkgvip
    @mkgvip6 жыл бұрын

    Very nice and simple way explained, Thanks!

  • @hamzaabdirizak5646
    @hamzaabdirizak5646 Жыл бұрын

    That’s so useful thank you 🙏

  • @paigequeenb8257
    @paigequeenb82577 жыл бұрын

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

  • @sanjayshrestha1935
    @sanjayshrestha19354 жыл бұрын

    Thank you!! I was really searching for this

  • @jiriblazek3920
    @jiriblazek39203 жыл бұрын

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

  • @lopi9560
    @lopi95603 жыл бұрын

    Awesome! Thank you!

  • @neruismite
    @neruismite2 жыл бұрын

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

  • @abhijitnayak9408
    @abhijitnayak94082 жыл бұрын

    It's truly informative & very easy to understand

  • @aliav7137
    @aliav71373 жыл бұрын

    thank a lot man this was very helpful

  • @Abqscanner
    @Abqscanner2 жыл бұрын

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

  • @gyanendrapradhan9823
    @gyanendrapradhan9823 Жыл бұрын

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

  • @mc-ti5uq
    @mc-ti5uq2 жыл бұрын

    great explanation. thank you :)

  • @pmarie25
    @pmarie252 жыл бұрын

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

  • @dpkoli
    @dpkoli3 жыл бұрын

    Very simple but very usefull. Thanks a lot.

  • @viralvyas9946
    @viralvyas99464 жыл бұрын

    nice video sir , greatly explained

  • @reynald7267
    @reynald72673 жыл бұрын

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

  • @cedricagion8249
    @cedricagion82495 жыл бұрын

    Thank you. This video is very helpful.

  • @ActuallyCasual
    @ActuallyCasual7 жыл бұрын

    Huge help. Thank you!

  • @twes619
    @twes6193 жыл бұрын

    Thank you! Thumbs up and subbed.

  • @anonymousproxy131
    @anonymousproxy1313 жыл бұрын

    Thank you - great vid

  • @himanshudalai1028
    @himanshudalai10285 жыл бұрын

    Thank you so much. It was super useful.

  • @Saifullah-yy6ul
    @Saifullah-yy6ul2 жыл бұрын

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

  • @mohamednoorullahyunusansar749
    @mohamednoorullahyunusansar7495 жыл бұрын

    Very well explained super nice

  • @Pratapbrazil
    @Pratapbrazil6 жыл бұрын

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

  • @Lynx-vw5ml
    @Lynx-vw5ml6 жыл бұрын

    Thank you so much my friend 👍

  • @skipdeedon9939
    @skipdeedon99392 жыл бұрын

    Thanks so much!

  • @shubhinagpal2657
    @shubhinagpal26573 жыл бұрын

    Very useful video for me,

  • @stanefreesolutionsptyltd2590
    @stanefreesolutionsptyltd25906 жыл бұрын

    you are a champion mate thank you

  • @mudassirvahidy
    @mudassirvahidy6 жыл бұрын

    Thank you so much man!

  • @maaritvaga9456
    @maaritvaga94564 жыл бұрын

    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

    @trumpexcel

    4 жыл бұрын

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

  • @santangwatid
    @santangwatid5 жыл бұрын

    found this quite helpful and useful. thanks a lot ;)

  • @LiaqatAli-bc5mv
    @LiaqatAli-bc5mv4 жыл бұрын

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

  • @fokhrulabedin
    @fokhrulabedin Жыл бұрын

    Thank you!

  • @marciawright8908
    @marciawright89082 жыл бұрын

    Thank you so much.

  • @lindagomes94
    @lindagomes944 жыл бұрын

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

  • @shumbushojeanleon9795
    @shumbushojeanleon97955 жыл бұрын

    Thank you very much It is very useful for me

  • @angshumanchowdhury5685
    @angshumanchowdhury56854 жыл бұрын

    Excellent sir 🙏🙏🙏

  • @UnknownID.
    @UnknownID.6 жыл бұрын

    that's really helpful. Thanks

  • @hoteldinameugorje7326
    @hoteldinameugorje73266 жыл бұрын

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

  • @donaldtait5755
    @donaldtait57557 жыл бұрын

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

  • @Randygussan1112
    @Randygussan11126 жыл бұрын

    Love the video thank you buddy

  • @judydistrito4026
    @judydistrito40262 жыл бұрын

    Thank you very much

  • @finalruner
    @finalruner5 жыл бұрын

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

  • @zanelemofikoe2374
    @zanelemofikoe23745 жыл бұрын

    Extremely useful for me

  • @jsingle76
    @jsingle763 жыл бұрын

    This was super helpful! Thanks :)

  • @angmingzhen
    @angmingzhen3 жыл бұрын

    Amazing. Thank you!

  • @patilraosahebn
    @patilraosahebn5 жыл бұрын

    GREAT TIP DEAR.

  • @sachinkumar-kg4fu
    @sachinkumar-kg4fu Жыл бұрын

    super thanks sir

  • @nirmalmaharjan1748
    @nirmalmaharjan17486 жыл бұрын

    exactly what i was looking for. thanks mate

  • @smitamodi9632
    @smitamodi96327 жыл бұрын

    Perfect explanation and very useful

  • @janetnelson1210
    @janetnelson12107 жыл бұрын

    A big help. Thanks.

  • @302maaz
    @302maaz7 жыл бұрын

    your teaching skill is awesome

  • @josiahpaul4238
    @josiahpaul42385 жыл бұрын

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