Excel DRAG AND INSERT COPY Keyboard Shortcut

Using the Drag and Insert Copy Shortcut

Windows keyboard shortcut

 
Mac keyboard shortcut

Use this shortcut to copy values and inserts them in the new location. Works with rows and columns.
Other useful Drag & Drop keyboard shortcuts