Forum Discussion
Excel 2016 Series fill not properly working
Hi Bashir,
After you drag down check/change autofill option expanding the icon at right bottom
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..
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.
Hi Jan,
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
Hello SergeiBaklan,
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.
.jpg){kind=link}