Drag-and-Drop editing

1)Click the Tools menu and then select Options.                        

2)Click the Edit tab.

3)Look for Settings and then check or uncheck the option Allow cell drag and drop.

4)Also, click the option Alert before overwriting cells under it if you want to be warned before any data is overwritten.

5)Click the OK button.