Forum Discussion
BradD6629
Mar 21, 2023Copper Contributor
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 to suggestions.
- Thanh_Nguyen_Copper Contributor
I suddenly am having the same issue. We're you able to resolve your this issue. Thank you in advance.
- SCenter2018Copper ContributorHaving 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.
- rodduart88Copper Contributor
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.
- SCenter2018Copper Contributor
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.
- NikolinoDEGold Contributor
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!
- JKPieterseSilver Contributor
NikolinoDE The screen-shot that was posted clearly shows both boxes are checked.
- NikolinoDEGold ContributorIt'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 🙂
- JKPieterseSilver ContributorIs the worksheet protected?