SOLVED
Home

Autofill Options not available

%3CLINGO-SUB%20id%3D%22lingo-sub-842906%22%20slang%3D%22en-US%22%3EAutofill%20Options%20not%20available%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-842906%22%20slang%3D%22en-US%22%3E%3CP%3EI%20would%20like%20to%20fill%20in%20the%20sequence%3A%3C%2FP%3E%3CP%3EA%3C%2FP%3E%3CP%3EB%3C%2FP%3E%3CP%3EC%3C%2FP%3E%3CP%3E...%3C%2FP%3E%3CP%3EThis%20used%20to%20be%20easy%20in%20the%20old%20Excels%20(yes%2C%20going%20back%20decades).%20Now%20I%20see%20that%20I%20have%20to%20drag%2C%20then%20select%20the%20%22Autofill%20Box%22%20which%20magically%20appears%20and%20choose%20an%20option.%20Problem%20is%2C%20that%20box%20does%20not%20appear%20in%20my%20version%20of%20Excel%20-%20sorry%2C%20I%20can't%20find%20the%20version%2C%20so%20can't%20add%20that%20detail...%20I%20have%20done%20the%20File%2FOptions%2FAdvanced%20thing%20and%20enabled%20Autofill.%20As%20a%20matter%20of%20fact%2C%20I%20can%20complete%20the%20sequence%26nbsp%3B%3C%2FP%3E%3CP%3E1%3C%2FP%3E%3CP%3E2%3C%2FP%3E%3CP%3E3%3C%2FP%3E%3CP%3E...%3C%2FP%3E%3CP%3EBut%20no%20way%20to%20do%20the%20alphabet%20thing.%20Don't%20worry%2C%20I%20have%20done%20the%20deed%20manually%20and%20will%20get%20on%20with%20my%20work%2C%20but%20I'm%20not%20happy!%20Please%20give%20me%20a%20tip%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-842906%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Eautofill%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-843065%22%20slang%3D%22en-US%22%3ERe%3A%20Autofill%20Options%20not%20available%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-843065%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F405510%22%20target%3D%22_blank%22%3E%40sailho%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHave%20a%20look%20at%20%3CSTRONG%3EFile%20%26gt%3B%20Options%20%26gt%3B%20Advanced%3C%2FSTRONG%3Eand%20go%20down%20to%20%3CEM%3E%3CSTRONG%3EGeneral%3C%2FSTRONG%3E%3C%2FEM%3Eand%20click%20onto%20%3CSTRONG%3EEdit%20Custom%20Lists%3C%2FSTRONG%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20826px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F130646iD9BE2B9274A44F1E%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22capture20190909095846085.png%22%20title%3D%22capture20190909095846085.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20Custom%20Lists%2C%20you%20can%20see%20what%20is%20already%20programmed%20and%20you%20can%20even%20add%20your%20own%20sequences%20if%20you%20want.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20492px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F130647iDD919715E5C4BF68%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22capture20190909100029756.png%22%20title%3D%22capture20190909100029756.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou'll%20be%20able%20to%20see%20if%20A%2C%20B%2C%20C%2C%20etc%20is%20in%20the%20list%20(if%20it's%20not%20then%20this%20is%20likely%20why%20your%20autofill%20isn't%20working).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%20and%20best%20wishes%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-843239%22%20slang%3D%22en-US%22%3ERe%3A%20Autofill%20Options%20not%20available%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-843239%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F89704%22%20target%3D%22_blank%22%3E%40Damien%20Rosario%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks%20for%20the%20prompt%20response.%20I%20imported%20my%20sequence%20as%20suggested%20and%20checked%20the%20functionality%20-%20it%20worked!%3C%2FP%3E%3CP%3EI%20hope%20sometime%20I%20will%20need%20this%20sequence%20again%20so%20that%20the%20result%20is%20worth%20time%20spent%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-846089%22%20slang%3D%22en-US%22%3ERe%3A%20Autofill%20Options%20not%20available%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-846089%22%20slang%3D%22en-US%22%3E%3CP%3EGlad%20to%20help%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F405510%22%20target%3D%22_blank%22%3E%40sailho%3C%2FA%3E.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20wishes%20to%20you!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3EDamien%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
sailho
New Contributor

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 appears and choose an option. Problem is, that box does not appear in my version of Excel - sorry, I can't find the version, so can't add that detail... I have done the File/Options/Advanced thing and enabled Autofill. As a matter of fact, I can complete the sequence 

1

2

3

...

But no way to do the alphabet thing. Don't worry, I have done the deed manually and will get on with my work, but I'm not happy! Please give me a tip

3 Replies
Solution

Hi @sailho 

 

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

 

capture20190909095846085.png

 

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

 

capture20190909100029756.png

 

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

@Damien Rosario 

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

Glad to help @sailho

 

Best wishes to you!

 

Cheers

Damien 

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies