![how to lock certain cells in excel formulas how to lock certain cells in excel formulas](https://yagisanatode.com/ezoimgfmt/i0.wp.com/www.yagisanatode.com/wp-content/uploads/2017/11/Fruit-2-1.png)
Now, we need to protect the worksheet in order to protect formulas in excel.Now again, press Ctrl + 1 to open the Format Cell window, and this time makes only these cells as “Locked”.Ĭlick on “Ok” and only selected cells will be locked, and protection applies only for these cells.
![how to lock certain cells in excel formulas how to lock certain cells in excel formulas](https://cdn.wallstreetmojo.com/wp-content/uploads/2018/11/lock-formula-cntrl-A.gif)
Look, it has selected only the black font colored cells. Click on “Ok”, and all the cells which have formulas will be selected.From the above window, choose “Formula” as the option.This will take you to the “Got To Special” window like the below one.Select the entire worksheet and press the F5 key to open the “Go-To” window and press on the “Special” tab. Once all the cells are unlocked, we need to lock only formula cells because we need to protect only formula cells, so how do you know which cell has the formula in it?.
![how to lock certain cells in excel formulas how to lock certain cells in excel formulas](https://trumpexcel.com/wp-content/uploads/2017/03/How-to-Lock-Formulas-in-Excel-protect-worksheet-and-content.png)