Forum Discussion
sailho
Sep 08, 2019Copper Contributor
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...
- 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
sailho
Sep 09, 2019Copper Contributor
Many thanks for the prompt response. I imported my sequence as suggested and checked the functionality - it worked!
I hope sometime I will need this sequence again so that the result is worth time spent 🙂
Damien_Rosario
Sep 10, 2019Silver Contributor