Forum Discussion
Auto fill notworking despite Enable fill handle and cell drag and drop being checked.
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 ...
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!
NikolinoDE The screen-shot that was posted clearly shows both boxes are checked.
- 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 🙂