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.
![Move the mouse pointer to an edge of the selected cell or the range until the pointer changes to an arrowhead.](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Copy_Data_Using_Draganddrop___Move_Mouse_Pointer_To_Edge_Of_Selec.PNG)
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.
![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.](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Copy_Data_Using_Draganddrop___Press_And_Hold_Mouse_Button_And_Ctr.PNG)