Forum Discussion
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 the data input cells so that these cells cannot be moved. On the web it says the 20067 and 2010 excell versions had an option where there was an "Object positioning" and "Don't move or size cells" option but I cannot find it on the excel version I am using. Any help would be greatly appreciated.
Kind regards
- 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.
3 Replies
- 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.Frank13 Hello! By updating this in the options, it looks like it is changing for me, but not too sure if changing for other users unless they do the same thing. Is there a way to tie this to the workbook or is it already tied to the workbook? Thanks!
I went and confirmed this myself. The setting that Frank is referring to does NOT save to the individual workbook. Those are environment settings which only apply to the local client. I saved this setting to a workbook and sent it to a friend who was still able to click and drag the cell to a new cell.
