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.


You may also like...