Forum Discussion

MDB_2000's avatar
MDB_2000
Copper Contributor
Nov 30, 2020
Solved

Excel auto fill just doesn't seem to work!

Hi anyone who can assist,   I am trying to do a basic Autofill as here: But it just doesn't allow me to drag into the blanks cells based on the date sequence. There is no 'crosshairs' cursor...
Charting
excel
Formulas and Functions
  • NikolinoDE's avatar
    NikolinoDE
    Nov 30, 2020

    MDB_2000 

    Click on the “File” tab (from 2010) and then on “(Excel) Options”.
    Switch to the “Advanced” category, activate

    or deactivate the “Enable fill box

    and drag & drop cells” option in the “Editing options” section (from 2010)

    and click “OK” to confirm.

     

    I would be happy to know if I could help.

     

    Nikolino

    I know I don't know anything (Socrates)

     

    * Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Nov 30, 2020

MDB_2000 Noticed the "missing drag indicator" as well in Excel for Windows (not on Excel for Mac, though). Can still drag and fill down by hovering the cursor over the bottom right-hand corner of the cell and right-click.

MDB_2000's avatar
MDB_2000
Copper Contributor
Nov 30, 2020

Riny_van_Eekelen Hmmm that just didn't work for me. But perhaps the settings aren't on properly. (although I have followed all the actions from Help)

 

Resources