Auto complete text in a drop down list cell

%3CLINGO-SUB%20id%3D%22lingo-sub-2194654%22%20slang%3D%22en-US%22%3EAuto%20complete%20text%20in%20a%20drop%20down%20list%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2194654%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETrying%20to%20do%20a%20spreadsheet%20and%20figured%20out%20how%20to%20make%20the%20drop%20down%20list%20box%20(yay).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20I%20would%20like%20to%20have%20the%20option%20of%20auto%20completion%20of%20words%20when%20I%20type%20a%20few%20letters%20instead%20of%20scrolling%20down%20the%20list%20every%20single%20time%20(for%20the%20most%20frequent%20ones%20I%20use).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20I%20can%20do%20this%20please%3F%3C%2FP%3E%3CP%3EMy%20automatic%20cell%20completion%20is%20turned%20on%2C%20and%20works%20for%20non-list%20cells.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20to%20all%20the%20brains%20that%20can%20help%20me%20out%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-LABS%20id%3D%22lingo-labs-2194654%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2195192%22%20slang%3D%22en-US%22%3ERe%3A%20Auto%20complete%20text%20in%20a%20drop%20down%20list%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2195192%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F991170%22%20target%3D%22_blank%22%3E%40Heather_Hagart%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExcel%20doesn't%20allows%20the%20drop%20down%20to%20Autocomplete%2C%20generally%20we%20use%20for%20Data%20Validation.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETherefore%20you%20have%20to%20work%20with%20Combo%20box%2C%20is%20one%20of%20the%20Active%20X%20controls.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20check%20this%20link%2C%2C%2C%20I've%20shown%20how%20to%20do%20it%20all%20about%20Autocomplete.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%20data-unlink%3D%22true%22%3E%3CA%20href%3D%22https%3A%2F%2Fsuperuser.com%2Fquestions%2F1419626%2Fhow-can-i-add-autocomplete-to-an-excel-drop-down-validation%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EHit%20this%20link%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2195502%22%20slang%3D%22en-US%22%3ERe%3A%20Auto%20complete%20text%20in%20a%20drop%20down%20list%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2195502%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F93699%22%20target%3D%22_blank%22%3E%40Rajesh-S%3C%2FA%3E%26nbsp%3BI%20followed%20along%20well%20until%20it%20said%20%22reach%20to%20linked%20cell%20...%22%20sorry.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20my%20Data%20on%20one%20sheet%2C%20and%20the%20form%20on%20the%20other.%26nbsp%3B%20How%20do%20I%20link%20it%20from%20sheet%203%20(data)%20to%20be%20on%20the%20combo%20box%20on%20sheet%201%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOr%20no%20no%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2199160%22%20slang%3D%22en-US%22%3ERe%3A%20Auto%20complete%20text%20in%20a%20drop%20down%20list%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2199160%22%20slang%3D%22en-US%22%3EThe%20link%20I've%20show%20with%20my%20post%20has%20solution%2C%2C%2C%2C%20and%20it's%20properly%20elaborated%2C%2C%20unable%20to%20realize%20that%20where%20U%20got%20stuck%2C%2C%2C%20if%20possible%20better%20share%20the%20Workbook%20with%20me%20and%20let%20me%20examine%20it%20to%20Fix.%3C%2FLINGO-BODY%3E
New Contributor

Hi everyone, 

 

Trying to do a spreadsheet and figured out how to make the drop down list box (yay).

 

But I would like to have the option of auto completion of words when I type a few letters instead of scrolling down the list every single time (for the most frequent ones I use).

 

Is there a way I can do this please?

My automatic cell completion is turned on, and works for non-list cells.

 

Thanks to all the brains that can help me out

8 Replies

@Heather_Hagart 

Excel doesn't allows the drop down to Autocomplete, generally we use for Data Validation. 

 

Therefore you have to work with Combo box, is one of the Active X controls.

 

Please check this link,,, I've shown how to do it all about Autocomplete.

 

Hit this link 

@Rajesh-S I followed along well until it said "reach to linked cell ..." sorry.

 

I have my Data on one sheet, and the form on the other.  How do I link it from sheet 3 (data) to be on the combo box on sheet 1?

 

Or no no?

The link I've show with my post has solution,,,, and it's properly elaborated,, unable to realize that where U got stuck,,, if possible better share the Workbook with me and let me examine it to Fix.
If you really want to do it in DropDown, here is a video and examples to download, everything simply explained by Microsoft.

Create a drop-down list
https://support.microsoft.com/en-US/office/create-a-drop-down-list-7693307a-59ef-400a-b769-c5402dce4...

I would be happy to know if I could help.

Nikolino
I know I don't know anything (Socrates)

@Heather_Hagart 

 

Here dropdown with ComboBox where it reacts to the letter input.

 

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

@Rajesh-S 

 

Hi,

 

I am trying to use this, but the sheet I want it to autocomplete is a different sheet from the one where the list is.  So I have a column in August that I want to populate with employees names.  The list in in sheet settings under D2:D65.

I can't seem to make this work at all, and I need to be able to give me the employees quicker so I can do data entry on the August sheet. 

Can you make this work when I don't know VBA?

Thanks,

 

Liz

 

Without VBA this will hardly work,,, you do one thing,, upload the WB and mention in which column or cell you want to use it then I'll apply the VBA and send back the sheet to you ☺

@Rajesh-S   Great!  I will do that tomorrow.  Thanks!  Liz