Excel auto fill just doesn't seem to work!

[MDB_2000]

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, just a solid white cross.

What am not doing right?

[#2]

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

[#3 · Accepted solution]

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

[#4]

@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)

[#5]

Awesome solution thanks Nikolino

[#6]

You are welcome
I was pleased to be able to help you.

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