There is one cool trick I included in this Family Budget Excel dashboard.
It has a lot of formulas and I didn't want the client unintentionally deleting those formula cells. I wanted him to be able to edit only the cells that required his entry/update.
And in this post I will show you just how I did that.
I do CTRL + A twice to select the entire sheet
I rightclick anywhere, and select Format Cells.
I go to Protection Tab, and tick Locked. Leave Hidden unticked. Don't forget to click OK.
Now I select only the Cells I want the Client to edit/update.
Again, I rightclick and select Format Cells.
I go to the Protection tab, and untick Locked.
I do CTRL + A twice to reselect the entire sheet (not necessary, just too lazy to remake the screenshots). And I click on the Review Menu and Select Protect Sheet.
Now it's done.
When the client tries to edit a part he is not meant to, he gets an error notification.