By default, all formula cells are not locked unless you lock it. When you are working with workbook or template file, you may enter many formulas. Sometimes, you may change formulas unknowingly. Also if your workbook is not password protected, someone can open file and edit formulas. To avoid these problems, you have option to lock formula cell in Excel 2010 workbook.
If someone is very new to Excel, you might lock formula cell to ensure that formulas are not modified or deleted. When workbook template is protected, by default, all formula cells are locked. You can’t change formula cells without changing setting.
Lock Formula Cell in Excel 2010
Do the following steps to lock formula cell in excel 2010:
Step 1: Choose Home ➪ Editing ➪ Find & Select ➪ Go to Special to display Go to Special dialog box.
Step 2: Select Constants and click OK on Go to Special dialog box. This function will select all nonformula cells.
Step 3: Press Ctrl+1 to display Format Cells dialog box.
Step 4: Click on Protection tab on Format Cells dialog box and remove check mark from Locked check box.
Step 5: Click OK to close Format Cells dialog box.
Step 6: Choose Review ➪ Changes ➪ Protect Sheet to display Protect Sheet dialog box.
Step 7: Specify a password if you want and click OK.
Now you have successfully locked all formulas in workbook. You can’t modify any formula cells unless you unprotect them from ribbon. If you click on any protected or locked formula cells, you will see following message:
This is the simple way to lock formula cell in Excel 2010 workbook or template.
If you want to unprotect formula, Choose Review ➪ Changes ➪ Unprotect Sheet. If you sheet is password protected, you have to enter password.