Exceljet

Quick, clean, and to the point

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.
This video shows how to stop Excel from changing cell references when you want an exact copy of a formula in a different cell.
In this video, we show you how to use drag and drop, which can be surprisingly useful.
In this video, we'll look at a simple way to use VLOOKUP to group data into specific categories.
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.
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Shortcuts Video Course
Excel Charts video training course
Video training for Excel Tables