Auto fill notworking despite Enable fill handle and cell drag and drop being checked.

[BradD6629]

See image below.  I can not get the plus sign to appear in the bottom right hand corner of the cell, therefore can't drag a formula.  I followed the directions on help to resolve, but no luck.  Open to suggestions. 

[#2]

Is the worksheet protected?

[#3]

@BradD6629 

You can try changing your AutoFill settings to make sure they’re configured correctly by going to File > Options > Advanced and scrolling down to the Editing options section. 

Make sure the Enable fill handle and cell drag-and-drop option is selected. 

You can also try selecting all values before dragging Fill Handle or removing gaps between columns. 

If none of these solutions work, you can try checking out other possible solutions from this page.

Maybe its helps!

[#4]

@NikolinoDE The screen-shot that was posted clearly shows both boxes are checked.

[#5]

It's just one of the suggestions and this is just to indicate that sometimes it helps to hack it in and out again.
Don't think this harms the user 🙂

[#6]

@BradD6629 I have the same issue and have tried numerous solutions.

This is bad and painful. Help please Microsoft

[#7]

Having the same issue, with all these options enabled. Did disable and re-enable as one user suggested but did not resolve. My only fix has been to literally close the workbook and reopen it, then it works again until it decides to stop again.

[#8]

@SCenter2018 having the same issue. All boxes checked, autofill should be working, but i can't see the little cross to drag down/double click. 

[#9]

@BradD6629 

I suddenly am having the same issue. We're you able to resolve your this issue. Thank you in advance.

[#10]

I was able to semi work around ~ i have to zoom in to like, 50% so that the intersection of cells is so big that the cursor cannot "ignore" it. It works 90% of the time, the other 10% i still have to save my workbook, close and reopen. 

[#11]

@SCenter2018   I tried that too and it didn't work. I'm so frustrated with this. I have tried everything and seen almost all the YouTube videos as well.

[#12]

@Thanh_Nguyen_ This was also happening to me all of a sudden..... I went through countless threads with "fixes" that didn't work for me... What did work.... My computer just needed an update. Immediate fix! Check and see if you need an update.