Forum Discussion
Excel auto fill just doesn't seem to work!
Click on the “File” tab (from 2010) and then on “(Excel) Options”.
Switch to the “Advanced” category, activateor 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.
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.
Hi, I have mark all this correct and it doesn't work. this problem I have from time to time, completely randomly. Usually I can auto fill cells, but like i.ex now, it fills with first number in first column and I have no even option of "cell filling" just formatting options. Restart of Office or computer doesn't solve, it change itself when it want. I don't have update pending. What should be the solution here? I use excel daily and this situations are taking my day of work or more,
out.
- Awesome solution thanks Nikolino
- You are welcome
I was pleased to be able to help you.
Nikolino
I know I don't know anything (Socrates)
