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.
Have you tried holding down ctrl when dragging the fill handle?
- No but I will try.
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.
- Igbvirus : you genius! I was messing with mine for far too long, looking and trying everything. This was the magic piece. Muchas Gracias!
