Lock formula cell in Excel workbook

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.

lock formula cell in Excel 2010

Step 2: Select Constants and click OK on Go to Special dialog box. This function will select all nonformula cells.

How to lock formula cell in Excel

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.

 How to lock formula cell in Excel 2010

Step 5: Click OK to close Format Cells dialog box.

Step 6: Choose Review Changes Protect Sheet to display Protect Sheet dialog box.

lock and protect formula cell in excel 2010

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:

lock formula cell in excel workbook

 

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.

One Comment
  1. Shaun Hoobler
    | Reply

Add a Comment

Your email address will not be published. Required fields are marked *


+ 9 = fourteen

CommentLuv badge