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.

NikolinoDE's avatar
NikolinoDE
Platinum Contributor
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.

MDB_2000's avatar
MDB_2000
Copper Contributor
Nov 30, 2020
Awesome solution thanks Nikolino
  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor
    Nov 30, 2020
    You are welcome
    I was pleased to be able to help you.

    Nikolino
    I know I don't know anything (Socrates)

Resources