The enable fill handle box is checked in excel options. I have also tried your suggestion by holding down the ctrl key (made 2 attempts, 1st by pressing/holding the ctrl before clicking on the autofill handle and dragging down the column and the 2nd by clicking and holding the autofill handle 1st then click/hold the ctrl key before dragging down the column). How To Fix Excel Fill Handle Not Working Issue Immediately, every formula in the file is updated. Excel autofill not working correctly . In case you need to get excel autofill not working, you can switch it off by doing the following: Now we’ll put excel’s power to use. Although this feature is by default comes enabled but may be due to your mistake somehow it got disabled. Autofill vlookup in excel with an advanced utility of kutools for excel if the formula is troublesome for you, you can try the super lookup group of kutools for excel , which contains several advanced lookup utilities, and all of them supports to au...