This is an excellent feature that will give you full control over your work.
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 #1kcreator