How to Lock and Protect Formula || Excel Malayalam
In this session we can learn how to lock and protect cells that contain formula in an Excel worksheet and you just need to follow the below steps :
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 2019. Now your formula is protected but you can allow input.
#FormulaLocking #ExcelMalayalam #SkillstoSucceedbyAlfan
Download file used in the video : https://www.rowscolumns.com/free-exce...
To learn Excel in English Click on: • FREE Excel Course (Basic to Advanced)
View my comprehensive courses: https://laurelss.com/instructor/952
Let’s connect on social media:
Facebook: / skill2succced.alfan
LinkedIn: / mohammed-alfan-23a94b30
Instagram: / z_one_clt
Twitter: / toalfan