Excel provides a number of options for disabling dragging and dropping. These options are available under the Edit tab on the Options dialog box.
Disable Drag and Drop
This option disables both dragging and dropping within the same worksheet. To disable drag and drop: