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
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 🙂
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!!
Wow... clear and straight to the point. You are undisputedly one of the world's best. Hats off to you
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!
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!
Clear and concise - others just seem to babble on and on. Thank you for making this so clear.
You are a great tutor. I now understand the concept of Locked and protected cell. Thank you.
I like that you quickly go over the concept within excel as well as the steps. Thank you!
Very clearly spoken and easily understandable. Thanks.
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.
Sir, God bless you... You're truly a wonderful teacher... Your explanation are very clear...
So helpful- quick and to the point. Thanks!
love the tip about selecting all formulas, you saved me a coffee break :-)
This tutorial was created two years ago, and it's still awesome!
Spot on. Very useful. Clear and concise language. Many thanks!
Overall your way of teaching is very nice
You are a great teacher. Very useful video
Keep up the great work. This is exactly what I was looking for.
Excellent video sir, thank you so much. Clear and thorough.
Just what I was looking for...thanks
Your a beast! Thanks, this just saved me tons of re-occurring work with finding and selecting cells with formulas.
@trumpexcel
5 жыл бұрын
Glad you found it useful!
Wow super thank you sir it works perfectly
Thank you - this video was incredibly helpful!
Thank you so much for this! Super clear and very helpful! Love the short handcuts!!!
Superb Yaaaaar Thanks Yaaar Very Much Thank you Thank you Thank you
Best video of all time
Thank you very well explained.
It REALLY WORKED ! Thank you.
it was very clear to understand. thanks to the publisher.
Wonderful beyond limits👌👌👌
Great explanation, thank you!
@trumpexcel
6 ай бұрын
Glad you found it useful!
Your instruction was excellent. I finally got it!
Very well explained, most useful, thank you
Very concise description of the feature, thank you!
Great video that allowed me to figure out what I needed to know. Thank you
Just what I was looking for. Thank you!!!
Brililant thankyou - well explained.
GREAT VIDEO!!!!!!
@trumpexcel
Жыл бұрын
Thanks.. Glad you found it useful :)
VERY HELPFUL THANKS
Simply explained, super easy to understand
Such a great tutorial, thank you so much!!
Excellent technique. Thanks for this video
I really liked the way you explained in a very simple manner... Very helpful
I found this video VERY useful...thank you very much!
Thank you for this great video!
Thank you for your efforts
Very helpful!
Very nice and simple way explained, Thanks!
That’s so useful thank you 🙏
Perfect. This is exactly what I needed. This would have helped a lot last semester...
Thank you!! I was really searching for this
Exellent, just what I was looking for. Many thanks.
Awesome! Thank you!
I have been looking of this since long. Amazing Explanation. Keep the good work
It's truly informative & very easy to understand
thank a lot man this was very helpful
Great video! Thank you for explaining it so clearly! Appreciate the tip to select all cells with formulas. Saved me a ton of time!
This was exactly what I was looking for...thanks a ton
great explanation. thank you :)
Thank you !! I’m tired of other co-workers changing shared reports!
Very simple but very usefull. Thanks a lot.
nice video sir , greatly explained
Very Helpful to me... Thank you so much!!!!
Thank you. This video is very helpful.
Huge help. Thank you!
Thank you! Thumbs up and subbed.
Thank you - great vid
Thank you so much. It was super useful.
very helpful just what you need to know to the point shot and precise thank you !!
Very well explained super nice
Amazing.......deserve like.....
Thank you so much my friend 👍
Thanks so much!
Very useful video for me,
you are a champion mate thank you
Thank you so much man!
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
4 жыл бұрын
Thanks for commenting Maarit... Glad you found the video useful!
found this quite helpful and useful. thanks a lot ;)
Great.. Great... Great...Awesome...found what I wanted..Thanks
Thank you!
Thank you so much.
Such a useful video ..so well explained !!!! Thanks a ton (y)
Thank you very much It is very useful for me
Excellent sir 🙏🙏🙏
that's really helpful. Thanks
Thank you, this was the best explanation I have found on youtube ;)
Nice, a really clear how-to. Many thanks!
Love the video thank you buddy
Thank you very much
Thank you. This video actually helped compared to the other ones. The lock property is weird
Extremely useful for me
This was super helpful! Thanks :)
Amazing. Thank you!
GREAT TIP DEAR.
super thanks sir
exactly what i was looking for. thanks mate
Perfect explanation and very useful
A big help. Thanks.
your teaching skill is awesome
i was doing it wrong all the while and was yelling as to why excel was so complicated lol! GREAT HELP BRUH!