I have created a sheet for entering data into some cells by useres. I want to protect the whole sheet to keep all formats (colors, validations, etc.) on the sheet. I want to enable only the entering data without any other modify of cells.
The problem is if I lock a cell the user can not enter the data but if I unlock a cell the user can modify anything (even the validation as well) in this cell.
Hot restrict all the modifications on the sheet except to enter data into some cells?
The problem is if I lock a cell the user can not enter the data but if I unlock a cell the user can modify anything (even the validation as well) in this cell.
Hot restrict all the modifications on the sheet except to enter data into some cells?