When the cursor changes, you’re able to drag the selection to a new location.
With this method, drag and drop is equivalent to cut and paste.
The content of selected cells is moved, and the selection you drag will completely overwrite the destination cells.
it’s possible for you to hold down the shift key to drag and insert.
You’ll see the cursor change into a plus (+) symbol.
When you release the mouse, a copy of the cells will be placed at the destination.
Drag and drop is a really handy way to quickly reorganize rows and columns in a table.
Just hold down the shift key to insert.
Notice also that you might work with entire rows and columns.
In Windows, use Control + Shift, and on a Mac, use Option + Shift.
Finally, you’ve got the option to use drag and drop to copy entire worksheets.
On windows, click and drag a worksheet with the Control key down.
On a Mac, hold down the Option key.
