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.
If you have added filters then this makes the fill handle cause an issue. So that remove any filters applied in the sheet (not clear filters, remove filtering option) and try to drag & down the cell. This will show the fill handle option again.
You are a genius - this helped.