Forum Discussion
Protecting cells in EXCEL
I have created a spreadsheet for others to use with complicated manipulation and formulae. My desire is to protect the part of the cells so things can't be changed and leave the rest for user input. ...
The key for you is unlocking the user-input cells before protecting the worksheet.
The settings are on the Home Ribbon tab, Cells group, then either Lock Cells or Format Cells ...
The latter will allow you to hide the formulae as well as protecting them from change.