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!”
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