Dragging the contents of a cell in MS excel 2007 not working (autocomplete)
Disabled fill handle and cell drag-and-drop check box are not checked from the Excel options. Cell handle is not shown draggable as shown in the following image :
To enable this please follow these steps :
Step 1 :
Click on excel options as :
Step 2 :
Go to Advanced tab and then click on check box (enable fill handle and cell drag-and-drop) as :
Advanced > enable fill handle and cell drag-and-drop
Now the drag will be enabled.