Lock Formulas

This post will show you how to quickly lock a selected formula in your current worksheet. How do I lock a formula or all formulas in a worksheet to protect them from being deleted or modified by other uses in Excel. If you do not want other users to modify or delete the formulas, you can use the protect feature to lock the cells that contain formulas in your worksheet.

Lock formulas in Excel


The below steps will demonstrate that how you can only lock a selected formula on a given worksheet.

#1 select the entire worksheet by pressing Ctrl +A, and right click on it, then select Format cells from the pop-up menu list.

lock formulas1

#2 switch to Protection tab in the Formula cells dialog box. And uncheck the Locked option, and click OK button. Then all of cells in your worksheet are unlocked (by default, all cells are locked, so if you want to lock all cells on the worksheet, then you can skip the first two steps)

lock formulas2

#3 Go to the HOME tab, click Find &Select command under Editing group, and select Go To Special from the drop down menu list.

lock formulas3

#4 check Formulas radio button from the Select section in the Go to Special dialog box.

lock formulas4

#5 then all cells with formulas on the worksheet are selected.

lock formulas5

#6 right click on the selected cells, and choose Format Cells, switch to Protection tab, then check the Locked checkbox.

lock formulas6

#7 go to the REVIEW tab, click Protect Sheet command under Changes group. The protect Sheet dialog box will appear.

lock formulas7

#8 type a password in Password to unprotect sheet text box. Click Ok, then reenter your password to confirm it. Click Ok. Then the cell with formulas are now locked and protected.when you try to edit that formula, you will get one warning message.

lock formulas8

lock formulas9

Leave a Reply