Get instant live expert help on how to lock formulas in excel

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

how do I lock into a cell in an excel formula
Solved by F. H. in 19 mins
I'm wondering whether there is a way to partially lock a workbook. I've created an excel file with a drop down list containing formulas, and was trying to figure out whether there is a way to partially lock the workbook so that respondents can still edit/fill in every cell EXCEPT for the ones containing formulas.
Solved by O. J. in 13 mins
I need to know how to lock a particular formula that way I can insert data into excel and use these formula's the data is always different the way I have my formulas set up is fine I just need to lock them to certain cells that are always changing
Solved by D. D. in 14 mins
good Morning I wanted to lock certain cell and rows I want to ptotect the formulas can you help me?
Solved by I. A. in 20 mins
how to use formula to determine which cell to lock or unlock?
Solved by O. L. in 21 mins