Forum Discussion
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.
Never mind, I found the solution. Go to File>Options>Formulas and set to Automatic.
I don't know how it changed in the first place though!
I don't know how it changed in the first place though!
Yes this was my issue as well. Thank you so much!! It can get changed if you are opening downloaded excel files im guessing. I opened another spreadsheet and pasted it and everything worked.