Excel's drag-and-drop UI feature enables you to freely drag objects that reside on the drawing layer to change their position. Pressing Ctrl while dragging duplicates the selected objects.
Excel also allows drag-and-drop actions on cells and ranges: You can easily drag a cell or range to a different position. Pressing Ctrl while dragging copies the selected range.
Drag-and-drop is optional;you can disable it in the Edit tab of the Options dialog box.
You can also drag a range to the Windows desktop, thus creating a "scrap" object. You can then drag this object to another workbook (or to another application) and insert it as an Object Linking and Embedding (OLE) object.
Was this article helpful?