Forum Discussion
Excel 2016 Series fill not properly working
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
- sujit36Jul 14, 2020Copper Contributor
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.
- SergeiBaklanJul 14, 2020Diamond Contributor
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?
- md_ashraf1135Feb 10, 2021Copper Contributorsomething is different in my excel there is no show right side down option
- Jan KlapetzkyNov 12, 2018Copper Contributor
Nice! Thanks.