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.
- Nurudeen2000Copper Contributor1.Select the group of cells
2.On the Home pane,click on Auto fill for the drop down menu
3.Clock on Series... in the drop down menu
4.Select Autofill
5.Click on OK - VanQuiBuiCopper Contributor
- Chris_VTCopper ContributorThis is what fixed my issue. It was set to manually update the calculations on the sheet. Setting it to automatic did indeed correct the issue. I found it on my own by poking around and was coming in to post, and thought let me just check to see if someone else found this same fix and VanQuiBui did. Thanks!!
- Ninad555Copper Contributor
Hello!
The series function was working on my pc till yesterday. But today I want to autofill hundreds of cells with same equation and different inputs, but when I drag the 1st cell with + mark, all I get is the same answer in every cell. Equation is different in each cell, but not answer. I need to manually click on the equation in each cell to get right answer. What can I do?
Thank you!
- SavinPereraCopper Contributor
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.
- MiWernCopper ContributorYou are a genius - this helped.
- Ninad555Copper ContributorNever 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!- MGNationCopper ContributorYes 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.
- Lewis-HIron Contributor
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. - Bashir MalekzadaCopper Contributoryes i tried holding down ctrl and still the same issue
Hi Bashir,
After you drag down check/change autofill option expanding the icon at right bottom
- adaso16Brass Contributor
Hi, I have a similar problem just in my case the selection of prefill options is not even there. It always used to work but suddenly a couple of days ago ist started showing the quick data analysis instead. See attached screenshots.
This is what happens when I drag the corner:
And these are then my options:
If you had any idea how to fix it it would be greatly appreciated..
- Deleted
Have you tried holding down ctrl when dragging the fill handle?
- Craig_RaisigCopper ContributorNo but I will try.
- lgbvirusCopper Contributor
Craig_Raisig in dindt work try thisa: Don't know how to get it turned back on, but you can add it to the Quick Access Toolbar by right clicking on "Fill" from the home tab. Found it, finally. Hope this helps others. Under options, advanced, "show paste options button when content is pasted" - needs to be checked.