I have a 'Task spreadsheet' in my company, where employees fill in certain Google spreadsheet cells the time they finished a task. This worked very well for years, but lately, more and more young millennials come, who didn't grow up with computers, but tablets/smartphones, resulting in a cluttered spreadsheet because cells get dragged and dropped everywhere. I tried to protect cells, but that prevent others to enter data.

Is there a way to disable the drag and drop function in Google Sheets?


Unfortunately, there isn't such option to disable drag&drop future in Google Sheets. Your option remains to protect ranges which shouldn't be filled by data. Also, you could set up multiple slave sheets/spreadsheets (which will act like some sort of template) and have 1 master sheet/spreadsheet which will hunt down required data.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.