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.
Related videos
The videos below demonstrate this shortcut.
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're going to combine INDEX and MATCH together to look things up. This is the core of all INDEX and MATCH formulas.
In this lesson, we cover shortcuts you can use for drag and drop in Excel.
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.