Drag and insert

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

Excel - Excel Functions - Excel Formulas
Logo