Looking for a way to use a drop down menu to change cell references in a formula

%3CLINGO-SUB%20id%3D%22lingo-sub-332881%22%20slang%3D%22en-US%22%3ELooking%20for%20a%20way%20to%20use%20a%20drop%20down%20menu%20to%20change%20cell%20references%20in%20a%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-332881%22%20slang%3D%22en-US%22%3E%3CP%3EI%20created%20a%20drop%20down%20list%20in%20excel.%20But%20now%20I%20want%20to%20type%20the%20first%20letter%20and%20have%20instant%20access%20to%20the%20item%20on%20the%20list%20instead%20of%20having%20to%20open%20the%20drop-down%20menu%20and%20choose%20from%20a%20big%20list.%20Can%20someone%20help%20me%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-332881%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

I created a drop down list in excel. But now I want to type the first letter and have instant access to the item on the list instead of having to open the drop-down​ menu and choose from a big list. Can someone help me?

0 Replies