Forum Discussion

sailho's avatar
sailho
Copper Contributor
Sep 08, 2019
Solved

Autofill Options not available

I would like to fill in the sequence: A B C ... This used to be easy in the old Excels (yes, going back decades). Now I see that I have to drag, then select the "Autofill Box" which magically ap...
  • Damien_Rosario's avatar
    Sep 09, 2019

    Hi sailho 

     

    Have a look at File > Options > Advanced and go down to General and click onto Edit Custom Lists.

     

     

    In Custom Lists, you can see what is already programmed and you can even add your own sequences if you want.

     

     

    You'll be able to see if A, B, C, etc is in the list (if it's not then this is likely why your autofill isn't working).

     

    Cheers and best wishes

    Damien

Resources