Drag and insert

Keyboard shortcut options for this action in excel: 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.

0 votes. 0 / 5