Forum Discussion
Not Allowing Entries to be blank
I have a cell that is formatted for a date that will get updated by the user (F4 Below). And then column A is just copying that value all the way down. I want to prevent the information in column A...
Select your whole sheet (by clicking into the top left corner) > Right click menu: Format Cells > Protection: Deselect Locked > OK
Highlight the cells in question > Right click menu: Format Cells > Protection: Select Locked
Main menu ribbon > Review > Protect sheet >
Enter a password.
Now in it’s protected state, all of the sheet is editable but the chosen cells are not.
You can if you wish leave the default for the sheet cells to be locked and instead you select specific ranges that can remain editable.