How To Lock And Protect Formulas In Excel

preview_player
Показать описание
How To Lock And Protect Formulas In Excel?

This is an excellent feature that will give you full control over your work. It feels really bad when an amateur plays around your workbook and tweaks your formulas without having slightest knowledge about it. Your hours of work ruins just within few minutes.

This is why we are going to lock and protect cells in Excel. Remember I am using Microsoft Excel 2010 for the demonstration. Follow the instruction below to protect formulas in Excel. Let’s get started.

1. Select the whole worksheet and right click
2. Select “Format Cells”.
3. Click on “Protection” and Uncheck “Locked”. (Excel locks sheet by default and you need to unlock it first)
4. Go to “Home” tab and click “Find and Select”.
5. Click “Go to special” and Click on “Formulas” and click “OK”.
6. Now lock and protect selected cells that contain formula by clicking “Review” tab and Clicking “Protect Sheet”
7. Type and password and confirm that password and it’s done
This is how you lock formulas in Excel 2010. Now your formula is protected but you can allow input.

#excel10tutorial #lockformula

Thanks for watching.

-------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------

If you like this tutorial, please subscribe:

Checkout our Advance Excel Tutorial Playlist:

Checkout the Excel Case playlist:

Connect us on social media

Рекомендации по теме
Комментарии
Автор

Fantastic video! Definitely the easiest video I've found. Thank you - you've saved me from giving up 😊

Samantha-cn
Автор

This was the best, easiest and simplest to follow lock cell video I've found. Tried several videos all morning and this was the only one that worked for me. Thanks a million!

sidior
Автор

finally, I have seen the easy to follow tutorial, , thank you sir God bless

highschooldepartment
Автор

Tried this today, after MANY attempts at finding what I needed. Thank you! One thing I noted, that I had to re-watch for clarification is that after you do the first part (select whole workbook, format, protection, unluck, ok)...you need to click somewhere on sheet to clear the select all on the whole workbook. I didn't do this the first time through and nothing worked correctly. Redid it with that little step and perfect. Just an FYI! But I have been looking at videos for weeks trying to find what I needed and this was FINALLY it! Thank you!

nicolefoley
Автор

Great video. Covered exactly what I was looking for. A few of the menu locations have changed since Excel 2010, but was still able to follow the instructions. thanks.

mattlachance
Автор

I have watched this video several times to help me set up worksheets! Thanks a bunch!!

christylindberg
Автор

thank you very much . this helps me to avoid the troubles that come from accidentally typing over the formulae cells..Just what i wanted and it was explained clearly.

mmganesh
Автор

Everything was simple and easy, It works! Great Instructor with good simple examples.

nicolesimpson
Автор

Thank you! I have been looking for a video like this and couldn't find one until I came across your video. Very straight and easy to follow.

jessicam
Автор

Simple instructions. Love it! Thank you!!!!

tickroane
Автор

Thanks, to the point & very helpful video.

decorousfashion
Автор

Hi there, this was a great and easy way to teach us on how to lock formulas. I would like to know how to write a formula as a text. For example, how can I write =Sum (B1:B6) in excel as a text? as soon as I write =sum (A1:A6) it becomes a mathematic formula.

vanderdossantos
Автор

Thank You so Much from the Philippines

jaranarturo
Автор

thanks from sri lanka.very easy to understand...

m.kgihansankalpahimaruwan
Автор

Easy to follow instructions! Really liked the “find formula” step...Other videos didn’t explain that.

stevecafaro
Автор

Thank you so much - very clear to follow and it works well.

captainkremen
Автор

hi, thank you very much for this video and it works good but:
cell not lock if we transfer a formula from other sheet
any solution please ?

microsecure
Автор

very good video you explained it so well

cathymanocchi
Автор

Excellent and easy method to protect formula in excel, , sir which cursor highlighter do you use ?

MA
Автор

This was very helpful. The next issue I’m having is I have a template sheet that I have locked. When I copy that template into a new sheet it doesn’t lock the formulas on the new sheet. How do I lock the formulas everytime I copy it to a new sheet without manually doing it each time?

jhard