Forum Discussion
Frank13
Jan 10, 2022Copper Contributor
How to lock cells so they cannot be moved but can still input data
I would like to protect my spreadsheet where there are locked and unlocked cells. I can do this but the unlocked cells can be moved which then causes the spreadsheet to fail. Is it possible to lock t...
- Jan 10, 2022I have just solved the problem myself. To lock the cells so they cannot be moved after protection activated but can still input data into the cell then do the following
“Review” – “Check accessibility” – “Options accessibility” – “Advanced” – remove “Enable fill handle and cell drag-and-drop” function.
Frank13
Jan 10, 2022Copper Contributor
I have just solved the problem myself. To lock the cells so they cannot be moved after protection activated but can still input data into the cell then do the following
“Review” – “Check accessibility” – “Options accessibility” – “Advanced” – remove “Enable fill handle and cell drag-and-drop” function.
“Review” – “Check accessibility” – “Options accessibility” – “Advanced” – remove “Enable fill handle and cell drag-and-drop” function.