Select A1 or a range. Move the mouse pointer to an edge of the selected cell or the range until the pointer changes to an arrowhead.
Press and hold the mouse button and Ctrl key. Drag the selection to the new location, and then release the mouse button and Ctrl key.