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. I did lock the desired cells and then protect the sheet but then all cells are unavailable for user input, rendering the complete sheet useless. Please direct me toward leaving the user input portion available.
Just an extra tip to the excellent replies already mentioned,
The concept of protection in Excel is reversed, which means, when you click on Protect Sheet on the Review Tab (read the wording) it says "Protect Sheet and content of locked Cells."
By default the 17,179,869 cells in any sheet are locked >> so all of them become protected.
So when I said the concept is reversed, I mean in Excel you specify what Not to protect by going to the Format Cell dialog Box CTRL + 1 >> Protection Tab >> uncheck Locked for the cell where you want to enable editing.