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 show how this shortcut can be used.
In this video, we'll look at how to resize and copy charts, including a way to snap the chart to cells.
In this video, we'll look at a simple way to use VLOOKUP to group data into specific categories.
In this video, we'll look at how to copy and lock structured references in a formula. Structured references are a special syntax used by Excel Tables.
In this lesson, we cover shortcuts you can use for drag and drop in Excel.
In this video, we'll look at how to extend a conditional formatting formula so that so that it checks more than just one condition.
