Apr 03 2018 10:28 AM
Apr 16 2018 02:38 AM
After you drag down check/change autofill option expanding the icon at right bottom
Nov 11 2018 05:33 PM
I have the same problem with Office 2016. Whatever letters I put in keep repeating. Fill Series does not appear as a choice on my dropdown menu. See picture.
Nov 12 2018 12:15 AM
Alphabetical is not the default list for Fill Series, you need to add it first at File->Options->Advanced->General. See https://excelribbon.tips.net/T007803_AutoFilling_with_the_Alphabet
Jan 29 2020 04:31 AM
Hi, I have a similar problem just in my case the selection of prefill options is not even there. It always used to work but suddenly a couple of days ago ist started showing the quick data analysis instead. See attached screenshots.
This is what happens when I drag the corner:
And these are then my options:
If you had any idea how to fix it it would be greatly appreciated..
Apr 01 2020 07:17 AM
In case you need to get Excel AutoFill not working, you can switch it off by doing the following:
Click on File in Excel 2010-2013 or on the Office button in version 2007.
Go to Options -> Advanced and untick the checkbox Enable fill handle and cell drag-and-drop.
Apr 02 2020 09:06 AM
@Vu_Tran Thanks for the advice. It was all correct in the settings but eventually I found out that the different pre-fill options are not available when one uses filters (when some of the rows are hidden). So I guess it had nothing to do with the settings, just the fact that this is for some reason not possible with filters on..
Jun 02 2020 03:20 PM
Thank you@adaso16 for your comment. You saved me a lot of time searching for a solution. It sure would be nice if Microsoft would add this "exception" to the fill handle instructions in their support.microsoft.com website.
Jun 03 2020 09:59 AM
You are most welcome @balboamom :)
I completely agree, it would have saved me a lot of trouble and time too had that been the case...
Jun 09 2020 02:29 PM
@adaso16 After about a hour of trying different solution, your answer was spot on for me. Thanks so much for putting it out there.
Jul 09 2020 04:36 AM
@adaso16Thanks for your suggestion because I was facing same problem but when i switched Filter then it works normally. Thank you
Jul 14 2020 08:01 AM
Hello @Sergei Baklan,
I have and issue but with the numbers with autofill. Say I type 5, followed by 10.If I select 5 and then 10(with control button pressed ) then I am supposed to get a black plus sign on bottom right corner , which I am not. No filters are active in this case.
Jul 14 2020 08:20 AM
Yes, selecting them you have only Quick Analysis button.
But after you drag selection down you shall see black "plus" (not visible on screenshot) and autofill icon
Is that something different in your case?
Jul 14 2020 08:22 AM
I am not getting the Quick analysis button,instead a white cross shows upon the bottom right corner
Jul 14 2020 09:29 AM
Sorry , I am getting neither the white cross or the dark plussign, just the quick analysis button.