Quick, clean, and to the point

Drag and insert copy

Windows shortcut 
Mac shortcut 

By default, drag and drop "cuts" cells like Edit > Cut, and overwrites values at the new location. Use this shortcut to copy values and to insert cells at the new location. This also works when dragging entire rows or columns. This is a good way to duplicate a row in an Excel Table, since Tables do not allow you to copy and insert paste entire rows.

Related videos

The videos below demonstrate this shortcut.
In this video, we'll look at how to create a 100% stacked column chart, which shows the proportional breakdown of multiple data series in stacked columns.
In this lesson, we cover shortcuts you can use for drag and drop in Excel.
In this lesson, we cover shortcuts you can use to cut, copy, and paste. We also cover drag and drop options.

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.