Forum Discussion

Copper Contributor

Mar 21, 2023

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 ...

excel

SCenter2018

Copper Contributor

Sep 13, 2023

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.

rodduart88

Copper Contributor

Sep 20, 2023

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.

SCenter2018
Copper Contributor
Oct 16, 2023
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.
- Thanh_Nguyen_
  Copper Contributor
  Oct 18, 2023
  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.
  - elizabar1
    Copper Contributor
    Oct 18, 2023
    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.