Forum Discussion

Bashir Malekzada's avatar
Bashir Malekzada
Copper Contributor
Apr 03, 2018

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.  
excel
Bashir Malekzada's avatar
Bashir Malekzada
Copper Contributor
Apr 03, 2018
yes i tried holding down ctrl and still the same issue
    • adaso16's avatar
      adaso16
      Copper Contributor
      Jan 29, 2020

      SergeiBaklan 

       

      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..

      • Reach2Kv's avatar
        Reach2Kv
        Copper Contributor
        Feb 09, 2022
        Fill Series will work only up to 14 digits no or alphanumeric...
    • Jan Klapetzky's avatar
      Jan Klapetzky
      Copper Contributor
      Nov 12, 2018

      I have the same problem with Office 2016. Whatever letters I put in keep repeating. Fill Series does not appear as a choice on my dropdown menu. See picture.

Resources