Drag and copy
Windows shortcut
Ctrldrag
Mac shortcut
⌥drag
The default behavior for drag and drop is to cut data in cells, but you can also copy cells during drag and drop. To copy cells, use this shortcut before or after you start to drag the selection. Excel will display a small plus (+) symbol to indicate the copy operation.
Related videos
The videos below demonstrate this shortcut.
In this video, we'll look at how to resize and copy charts, including a way to snap the chart to cells.
In this lesson, we cover shortcuts you can use to cut, copy, and paste. We also cover drag and drop options.
In this video, we show you how to use a custom list to sort your pivot table in a custom sequence.
In this video, we show you how to use drag and drop, which can be surprisingly useful.
In this lesson, we cover shortcuts you can use for drag and drop in Excel.
Download 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.