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.
In case you need to get Excel AutoFill not working, you can switch it off by doing the following:
Click on File in Excel 2010-2013 or on the Office button in version 2007.
Go to Options -> Advanced and untick the checkbox Enable fill handle and cell drag-and-drop.