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.
Download 200+ Excel Shortcuts
Love your tutorials, they've been awesome in helping me learn all that Excel can do.
