Question: how to copy and paste in excel by dragging?
Answer: Select the cell range.
Hold the Ctrl key down while you position the mouse pointer on an edge of the selection (that is, the expanded cell cursor). ... 
Drag the cell-selection outline to the place where you want the copy to appear and release the mouse button.