Home

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
joana_ads
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?

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies