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:
- Open the Options dialog box by clicking the File tab, and then clicking Options. Alternatively, you can press
