OK, I am having a sheet here which calculate the age when birth date is provided. I need to protect the sheet before giving it to users. So none of them change the structure or formula. But I also need to make some cells unprotected to make the user enter necessary data. I have colored those cells yellow which I will left unprotected.
So for that select those specific cells and right click on them. Then click on Format Cells. Select Protection tab where you can see the Locked option is already selected. By default Locked option is always selected for any cell. But this has effect only when you have protected the sheet. You have to deselect the Locked option for these specific cells only.
Now right click on sheet tab and click on Protect Sheet and then put a password and re-enter password and OK.
That’s how it is done. Now only those three yellow cells are left unprotected for users.