Forum Discussion
Bashir Malekzada
Apr 03, 2018Copper Contributor
Excel 2016 Series fill not properly working
hi, in excel 2016 when i try autofill in series the two numbers i enter to create a pattern keeps repeating.
SergeiBaklan
Nov 12, 2018MVP
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
sujit36
Jul 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, 2020MVP
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
- Craig_RaisigFeb 11, 2021Copper Contributor
Following introductions shown in your "help" I have followed but I cannot get the series working Often I want to series by the month. I cannoyt do it 2016 excell
- md_ashraf1135Feb 10, 2021Copper Contributorsame problem is my excel,
- sujit36Jul 14, 2020Copper Contributor
I am not getting the Quick analysis button,instead a white cross shows upon the bottom right corner
- sujit36Jul 14, 2020Copper Contributor
Sorry , I am getting neither the white cross or the dark plussign, just the quick analysis button.