Drag and insert

Keyboard shortcut options for this action in excel: drag and insert

Sponsored Link

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.

Sponsored Link

0 votes. 0 / 5