Learn How to Drag and Insert Copy With Shortcut in Microsoft Excel

Drag and Insert Copy With Shortcut in Microsoft Excel

Here we will show you how to Drag and Insert Copy in Microsoft Excel. Like many other programs Microsoft Excel also uses similar key combinations while using shortcuts.

You can use the key combinations given below to Drag and Insert Copy using the shortcut. By default, drag and drop “cuts” cells like Edit > Cut, and overwrites values at the new location. This shortcut is used to copy values and to insert cells at the new location. This also works while dragging the entire rows or columns. It’s is a fine method to copy a row in an Excel Table, since Tables do not allow you to copy and insert paste entire rows. So, here we go:

How to Drag and Insert Copy With Shortcut in Microsoft Excel?

By default, drag and drop “cuts” cells like Edit > Cut, and overwrites values at the new location. This shortcut is used to copy values and to insert cells at the new location. This also works while dragging the entire rows or columns. It’s is a fine method to copy a row in an Excel Table, since Tables do not allow you to copy and insert paste entire rows. This way you can easily Drag and Insert Copy using this shortcut.