Forum Discussion

BradD6629's avatar
BradD6629
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 to suggestions. 

 

 

  • SCenter2018's avatar
    SCenter2018
    Copper Contributor
    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's avatar
      rodduart88
      Copper 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. 

       

      • SCenter2018's avatar
        SCenter2018
        Copper 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. 

  • chas707's avatar
    chas707
    Copper Contributor

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

     

    This is bad and painful. Help please Microsoft

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor

    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!

      • NikolinoDE's avatar
        NikolinoDE
        Gold Contributor
        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 🙂

Resources