About This Shortcut
Drag and Copy – The default behaviour for drag and drop is to cut data in cells, but you can also copy cells during drag and drop. Use this shortcut before or after you start to drag the selection to copy cells. Excel will display a small plus (+) symbol to indicate the copy operation.
Keybord Shortcut key
- Window: Ctrl + Drag
- Mac: Alt + Drag
Example:
