Exceljet

Quick, clean, and to the point

Drag and insert

Windows shortcut 
Shiftdrag
Mac shortcut 
⇧drag

By default, when you drag a selection to a new location, the values in the selection will overwrite cells at the new location. Use this shortcut to insert cells at the new location. This also works when dragging entire rows or columns.

See all shortcuts

Related videos

The videos below demonstrate this shortcut.
Shortcuts to cut copy paste
In this lesson, we cover shortcuts you can use to cut, copy, and paste. We also cover drag and drop options.
How to look things up with INDEX and MATCH
In this video we're going to combine INDEX and MATCH together to look things up. This is the core of all INDEX and MATCH formulas.
Shortcuts for drag and drop
In this lesson, we cover shortcuts you can use for drag and drop in Excel.
How to create a multi level axis
In this video, we'll look at how to build a chart with multi-level axis labels. A multi-level axis allows you to group related information together.

Download 200+ Excel Shortcuts

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