How To Lock And Protect Formulas In Excel
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.
-------------------------------------------------------------------------------------------------------------
Support Us: / excel10tutorial
-------------------------------------------------------------------------------------------------------------
If you like this tutorial, please subscribe:
https://goo.gl/uL8fqQ
Checkout our Advance Excel Tutorial Playlist:
https://goo.gl/ExYy7v
Checkout the Excel tutorial for dummies playlist: https://goo.gl/UDrDcA
Checkout the Excel Case playlist:
https://goo.gl/xiP3tv
If you need any specific tutorial you can request that here: https://goo.gl/jM78fA
Connect us on social media
Facebook: https://goo.gl/hdJ7rN
Google Plus: https://goo.gl/Yk4DQc
Watch video How To Lock And Protect Formulas In Excel online without registration, duration hours minute second in high quality. This video was added by user Excel 10 tutorial 08 November 2017, don't forget to share it with your friends and acquaintances, it has been viewed on our site 202,698 once and liked it 2.2 thousand people.