Get instant live expert help on I need help with 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

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
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 do I lock into a cell in an excel formula
Solved by F. H. in 19 mins
I am trying to lock or protect cells that have data validation, formatting and /or formulas in a cell. my dad selects the entire row and deletes the data but when he does it also deletes the formatting, data validation info, and the formulas. Is there a way to lock that info but still be able to add the data to a cell?
Solved by V. U. in 17 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