Drag and insert

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

Windows shortcut 
Mac shortcut 

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