Turn drag-and-drop editing on or off
By default, drag-and-drop editing is turned on so you can drag the mouse
to move and copy cells. This option can be turned off.
On the Tools menu, click Options.
On the Edit tab, do one of the following:
To turn off drag-and-drop editing, clear the Allow cell drag and drop
check box.
To turn on drag-and-drop editing, select the Allow cell drag and drop
check box.
Tip To avoid replacing existing data in other cells when you drag
cells, make sure that the Alert before overwriting cells check box is
selected