Speed up data entry and validation with AutoComplete for dropdown lists in Excel for Windows

Published Jan 31 2022 09:00 AM 8,129 Views
Microsoft

At Excel, customer focus is at the core of what we do. We appreciate your feedback on adding autocomplete to data validation dropdown lists in Excel for Windows. Your Excel Community votes ensured this was one of the next in line to release after smooth scrolling. Thank you for keeping us honest and we hope this meets your expectations.

Today, we are excited to announce that speeding up data entry and validation with AutoComplete for dropdown lists is now available in Excel for Windows in the Beta Channel!

 

What is AutoComplete for dropdown list?

AutoComplete algorithm for dropdown list matches the string you type in the dropdown list cell with words from items in the dropdown list and then shows only the matching list items. As you type more characters, the dropdown list contracts, and conversely, when you remove characters, it expands. Matching words can be from anywhere in the list item's string – at the start, middle, or end. Also, the dropdown list excludes blank items from the Data Validation dropdown list.

 

(Photos Courtesy of NASA)(Photos Courtesy of NASA)

 

 

AutoComplete for dropdown list helps speed-up discovery of the right Data Validation values  at first attempt, and in turn, reduces time spent scrolling through the dropdown list, dealing with Data Validation errors, or writing complex code to enable it.

 

Coming soon 

We plan to add excluding duplicates from the drop-down list before we roll this out to production.

 

Availability and Feedback

AutoComplete for Data Validation drop-down list is available in Beta Channel with version 2112, build 16.0.14818.10000 or later. Please keep in mind features are enabled gradually to more and more users over time as we build confidence in the success of a feature working properly. And so, this feature may or may not be enabled on your computer immediately. When you do see it enabled, please try it out! We’d love to hear from you whether this meets your expectations or not. Please send us feedback!

 

Also, do you have an idea to make Excel better? We'd love to hear about it. Go to the Excel forum in Microsoft Feedback to submit your idea or vote for other ideas. You can also click the Feedback button in Excel and choose "I have a suggestion".

 

Want to know more about Excel? See What's new in Excel and subscribe to our Excel Blog to get the latest updates. Stay connected with us and other Excel fans around the world – join our Excel Community and follow us on Twitter.

 

Thank you!

33 Comments
%3CLINGO-SUB%20id%3D%22lingo-sub-3072083%22%20slang%3D%22en-US%22%3ESpeed%20up%20data%20entry%20and%20validation%20with%20AutoComplete%20for%20dropdown%20lists%20in%20Excel%20for%20Windows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3072083%22%20slang%3D%22en-US%22%3E%3CP%3EAt%20Excel%2C%20customer%20focus%20is%20at%20the%20core%20of%20what%20we%20do.%20We%20appreciate%20your%20feedback%20on%20adding%20autocomplete%20to%20data%20validation%20dropdown%20lists%20in%20Excel%20for%20Windows.%20Your%20Excel%20Community%20votes%20ensured%20this%20was%20one%20of%20the%20next%20in%20line%20to%20release%20after%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel-blog%2Fsmooth-scrolling-comes-to-excel-for-windows%2Fba-p%2F2823555%22%20target%3D%22_blank%22%3Esmooth%20scrolling%3C%2FA%3E.%20Thank%20you%20for%20keeping%20us%20honest%20and%20we%20hope%20this%20meets%20your%20expectations.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%0A%3CP%3EToday%2C%20we%20are%20excited%20to%20announce%20that%20speeding%20up%20data%20entry%20and%20validation%20with%20AutoComplete%20for%20dropdown%20lists%20is%20now%20available%20in%20Excel%20for%20Windows%20in%20the%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fofficeupdates%2Fbeta-channel%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EBeta%20Channel%3C%2FA%3E!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId-336436307%22%20id%3D%22toc-hId-338320703%22%20id%3D%22toc-hId-338320703%22%20id%3D%22toc-hId-338320703%22%20id%3D%22toc-hId-338320703%22%20id%3D%22toc-hId-338320703%22%20id%3D%22toc-hId-338320703%22%20id%3D%22toc-hId-338320703%22%20id%3D%22toc-hId-338320703%22%20id%3D%22toc-hId-338320703%22%20id%3D%22toc-hId-338320703%22%20id%3D%22toc-hId-338320703%22%20id%3D%22toc-hId-338320703%22%20id%3D%22toc-hId-338320703%22%20id%3D%22toc-hId-338320703%22%20id%3D%22toc-hId-338320703%22%20id%3D%22toc-hId-338320703%22%20id%3D%22toc-hId-338320703%22%20id%3D%22toc-hId-338320703%22%20id%3D%22toc-hId-338320703%22%20id%3D%22toc-hId-338320703%22%20id%3D%22toc-hId-338320703%22%20id%3D%22toc-hId-338320703%22%20id%3D%22toc-hId-338320703%22%20id%3D%22toc-hId-338320703%22%20id%3D%22toc-hId-338320703%22%20id%3D%22toc-hId-338320703%22%20id%3D%22toc-hId-338320703%22%20id%3D%22toc-hId-338320703%22%20id%3D%22toc-hId-338320703%22%20id%3D%22toc-hId-338320703%22%20id%3D%22toc-hId-338320703%22%3EWhat%20is%20AutoComplete%20for%20dropdown%20list%3F%3C%2FH2%3E%0A%3CP%3EAutoComplete%20algorithm%20for%20dropdown%20list%20matches%20the%20string%20you%20type%20in%20the%20dropdown%20list%20cell%20with%20words%20from%20items%20in%20the%20dropdown%20list%20and%20then%20shows%20only%20the%20matching%20list%20items.%20As%20you%20type%20more%20characters%2C%20the%20dropdown%20list%20contracts%2C%20and%20conversely%2C%20when%20you%20remove%20characters%2C%20it%20expands.%20Matching%20words%20can%20be%20from%20anywhere%20in%20the%20list%20item's%20string%20%E2%80%93%20at%20the%20start%2C%20middle%2C%20or%20end.%20Also%2C%20the%20dropdown%20list%20excludes%20blank%20items%20from%20the%20Data%20Validation%20dropdown%20list.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22(Photos%20Courtesy%20of%20NASA)%22%20style%3D%22width%3A%20546px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22(Photos%20Courtesy%20of%20NASA)%22%20style%3D%22width%3A%20546px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22(Photos%20Courtesy%20of%20NASA)%22%20style%3D%22width%3A%20546px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22(Photos%20Courtesy%20of%20NASA)%22%20style%3D%22width%3A%20546px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F342439i888203972FB1339D%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22DVAutocompleteFinal.gif%22%20alt%3D%22(Photos%20Courtesy%20of%20NASA)%22%20%2F%3E%3Cspan%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3E(Photos%20Courtesy%20of%20NASA)%3C%2Fspan%3E%3C%2Fspan%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3E(Photos%20Courtesy%20of%20NASA)%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3E(Photos%20Courtesy%20of%20NASA)%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3E(Photos%20Courtesy%20of%20NASA)%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAutoComplete%20for%20dropdown%20list%20helps%20speed-up%20discovery%20of%20the%20right%20Data%20Validation%20values%26nbsp%3B%20at%20first%20attempt%2C%20and%20in%20turn%2C%20reduces%20time%20spent%20scrolling%20through%20the%20dropdown%20list%2C%20dealing%20with%20Data%20Validation%20errors%2C%20or%20writing%20complex%20code%20to%20enable%20it.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId--1471018156%22%20id%3D%22toc-hId--1469133760%22%20id%3D%22toc-hId--1469133760%22%20id%3D%22toc-hId--1469133760%22%20id%3D%22toc-hId--1469133760%22%20id%3D%22toc-hId--1469133760%22%20id%3D%22toc-hId--1469133760%22%20id%3D%22toc-hId--1469133760%22%20id%3D%22toc-hId--1469133760%22%20id%3D%22toc-hId--1469133760%22%20id%3D%22toc-hId--1469133760%22%20id%3D%22toc-hId--1469133760%22%20id%3D%22toc-hId--1469133760%22%20id%3D%22toc-hId--1469133760%22%20id%3D%22toc-hId--1469133760%22%20id%3D%22toc-hId--1469133760%22%20id%3D%22toc-hId--1469133760%22%20id%3D%22toc-hId--1469133760%22%20id%3D%22toc-hId--1469133760%22%20id%3D%22toc-hId--1469133760%22%20id%3D%22toc-hId--1469133760%22%20id%3D%22toc-hId--1469133760%22%20id%3D%22toc-hId--1469133760%22%20id%3D%22toc-hId--1469133760%22%20id%3D%22toc-hId--1469133760%22%20id%3D%22toc-hId--1469133760%22%20id%3D%22toc-hId--1469133760%22%20id%3D%22toc-hId--1469133760%22%20id%3D%22toc-hId--1469133760%22%20id%3D%22toc-hId--1469133760%22%20id%3D%22toc-hId--1469133760%22%20id%3D%22toc-hId--1469133760%22%3EComing%20soon%26nbsp%3B%3C%2FH2%3E%0A%3CP%3EWe%20plan%20to%20add%20excluding%20duplicates%20from%20the%20drop-down%20list%20before%20we%20roll%20this%20out%20to%20production.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId-1016494677%22%20id%3D%22toc-hId-1018379073%22%20id%3D%22toc-hId-1018379073%22%20id%3D%22toc-hId-1018379073%22%20id%3D%22toc-hId-1018379073%22%20id%3D%22toc-hId-1018379073%22%20id%3D%22toc-hId-1018379073%22%20id%3D%22toc-hId-1018379073%22%20id%3D%22toc-hId-1018379073%22%20id%3D%22toc-hId-1018379073%22%20id%3D%22toc-hId-1018379073%22%20id%3D%22toc-hId-1018379073%22%20id%3D%22toc-hId-1018379073%22%20id%3D%22toc-hId-1018379073%22%20id%3D%22toc-hId-1018379073%22%20id%3D%22toc-hId-1018379073%22%20id%3D%22toc-hId-1018379073%22%20id%3D%22toc-hId-1018379073%22%20id%3D%22toc-hId-1018379073%22%20id%3D%22toc-hId-1018379073%22%20id%3D%22toc-hId-1018379073%22%20id%3D%22toc-hId-1018379073%22%20id%3D%22toc-hId-1018379073%22%20id%3D%22toc-hId-1018379073%22%20id%3D%22toc-hId-1018379073%22%20id%3D%22toc-hId-1018379073%22%20id%3D%22toc-hId-1018379073%22%20id%3D%22toc-hId-1018379073%22%20id%3D%22toc-hId-1018379073%22%20id%3D%22toc-hId-1018379073%22%20id%3D%22toc-hId-1018379073%22%20id%3D%22toc-hId-1018379073%22%3EAvailability%20and%20Feedback%3C%2FH2%3E%0A%3CP%3EAutoComplete%20for%20Data%20Validation%20drop-down%20list%20is%20available%20in%20Beta%20Channel%20with%20version%202112%2C%20build%2016.0.14818.10000%20or%20later.%20Please%20keep%20in%20mind%20features%20are%20enabled%20gradually%20to%20more%20and%20more%20users%20over%20time%20as%20we%20build%20confidence%20in%20the%20success%20of%20a%20feature%20working%20properly.%20And%20so%2C%20this%20feature%20may%20or%20may%20not%20be%20enabled%20on%20your%20computer%20immediately.%20When%20you%20do%20see%20it%20enabled%2C%20please%20try%20it%20out!%20We%E2%80%99d%20love%20to%20hear%20from%20you%20whether%20this%20meets%20your%20expectations%20or%20not.%20Please%20%3CA%20href%3D%22https%3A%2F%2Finsider.office.com%2Fen-us%2Fblog%2Fyour-feedback-makes-office-better%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Esend%20us%20feedback%3C%2FA%3E!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAlso%2C%20do%20you%20have%20an%20idea%20to%20make%20Excel%20better%3F%20We'd%20love%20to%20hear%20about%20it.%20Go%20to%20the%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Ffeedbackportal.microsoft.com%252Ffeedback%252Fforum%252Fc23f3b77-f01b-ec11-b6e7-0022481f8472%26amp%3Bdata%3D04%257C01%257CCuong.Pham%2540microsoft.com%257C24462222b3ac45e18c8408d9d14c8064%257C72f988bf86f141af91ab2d7cd011db47%257C0%257C0%257C637770948771666865%257CUnknown%257CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%253D%257C3000%26amp%3Bsdata%3DmL%252B1tuCsMypotthguCvWFzZi9xY39FQ3dxCoz4FO3Ho%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EExcel%20forum%20in%20Microsoft%20Feedback%3C%2FA%3E%26nbsp%3Bto%20submit%20your%20idea%20or%20vote%20for%20other%20ideas.%20You%20can%20also%20click%20the%20Feedback%20button%20in%20Excel%20and%20choose%20%22I%20have%20a%20suggestion%22.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EWant%20to%20know%20more%20about%20Excel%3F%20See%20%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fwhat-s-new-in-excel-for-microsoft-365-5fdb9208-ff33-45b6-9e08-1f5cdb3a6c73%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%23Audience%3DWindows_Desktop_%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%3CSPAN%3EWhat's%20new%20in%20Excel%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%3E%20and%20subscribe%20to%20our%20%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Faka.ms%2Fxlblog%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%3CSPAN%3EExcel%20Blog%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%3E%20to%20get%20the%20latest%20updates.%20Stay%20connected%20with%20us%20and%20other%20Excel%20fans%20around%20the%20world%20%E2%80%93%20join%20our%20%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Faka.ms%2FExcelCommunity%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%3CSPAN%3EExcel%20Community%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%3E%20and%20follow%20us%20on%20%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Ftwitter.com%2Fmsexcel%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3E%3CSPAN%3ETwitter%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%3E.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-3072083%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22(Photos%20courtesy%20of%20NASA)%22%20style%3D%22width%3A%20200px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22(Photos%20courtesy%20of%20NASA)%22%20style%3D%22width%3A%20200px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22(Photos%20courtesy%20of%20NASA)%22%20style%3D%22width%3A%20200px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22(Photos%20courtesy%20of%20NASA)%22%20style%3D%22width%3A%20200px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F342436iA71C125D78949CE3%2Fimage-size%2Fsmall%3Fv%3Dv2%26amp%3Bpx%3D200%22%20role%3D%22button%22%20title%3D%22DVAutocompleteFinal.gif%22%20alt%3D%22(Photos%20courtesy%20of%20NASA)%22%20%2F%3E%3Cspan%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3E(Photos%20courtesy%20of%20NASA)%3C%2Fspan%3E%3C%2Fspan%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3E(Photos%20courtesy%20of%20NASA)%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3E(Photos%20courtesy%20of%20NASA)%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3E(Photos%20courtesy%20of%20NASA)%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EToday%2C%20we%20are%20excited%20to%20announce%20that%20speeding%20up%20data%20entry%20and%20validation%20with%20AutoComplete%20for%20dropdown%20lists%20is%20now%20available%20in%20Excel%20for%20Windows%20in%20the%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fofficeupdates%2Fbeta-channel%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EBeta%20Channel%3C%2FA%3E!%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3072083%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAutocomplete%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Edata%20validation%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDropdown%20Lists%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3093990%22%20slang%3D%22en-US%22%3ERe%3A%20Speed%20up%20data%20entry%20and%20validation%20with%20AutoComplete%20for%20dropdown%20lists%20in%20Excel%20for%20Windows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3093990%22%20slang%3D%22en-US%22%3E%3CP%3EThat's%20great%20improvement%2C%20thank%20you.%20To%20clean%20list%20in%20background%20that%20will%20be%20nice%20if%20with%20duplicates%20you%20remove%20blanks%20as%20well.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3099853%22%20slang%3D%22en-US%22%3ERe%3A%20Speed%20up%20data%20entry%20and%20validation%20with%20AutoComplete%20for%20dropdown%20lists%20in%20Excel%20for%20Windows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3099853%22%20slang%3D%22en-US%22%3E%3CP%3EWhat%20a%20relief!%26nbsp%3B%20Looking%20forward%20to%20using%20this.%26nbsp%3B%20Thank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3136241%22%20slang%3D%22en-US%22%3ERe%3A%20Speed%20up%20data%20entry%20and%20validation%20with%20AutoComplete%20for%20dropdown%20lists%20in%20Excel%20for%20Windows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3136241%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20for%20this%20feature%20!%3C%2FP%3E%3CP%3EI%20am%20on%20the%20beta%20channel%2C%20version%202022%20(build%2014934.20010)%20and%20I%20don't%20have%20it%20yet.%20I%20hope%20it%20will%20come%20soon%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-3155429%22%20slang%3D%22en-US%22%3ERe%3A%20Speed%20up%20data%20entry%20and%20validation%20with%20AutoComplete%20for%20dropdown%20lists%20in%20Excel%20for%20Windows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3155429%22%20slang%3D%22en-US%22%3E%3CP%3EInfo%3A%20Microsoft%20365%20Personal%20(CZ%2FEN)%2C%20Beta%20Channel%2C%20version%202203%2C%20not%20available...%3C%2FP%3E%3CP%3EWebpage%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fofficeupdates%2Fbeta-channel%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fofficeupdates%2Fbeta-channel%3C%2FA%3E%26nbsp%3Bdoes%20not%20mention%20any%20changes%20in%20Excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUpdate%2013.%202.%202022%3A%20Autocomplete%20is%20back.%20For%20Czech%20language%3A%20The%20search%20is%20performed%20only%20from%20left%20to%20right%20from%20the%20first%20character.%20Thanks%3C%2FP%3E%3CP%3EUpdate%2023.%202.%202022%3A%20I%20think%2C%20that%20searching%20could%20be%20the%20same%20as%20in%20Data%20%2F%20Filter%20textbox.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20please!%20Step%202%3A%20Stop%20rewritting%20Data%20%2F%20Validation%20with%20Ctrl%20%2B%20V.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3155669%22%20slang%3D%22en-US%22%3ERe%3A%20Speed%20up%20data%20entry%20and%20validation%20with%20AutoComplete%20for%20dropdown%20lists%20in%20Excel%20for%20Windows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3155669%22%20slang%3D%22en-US%22%3E%3CP%3EEstuvo%20funcionando%20bien%20pero%20desde%20la%20ultima%20actualizaci%C3%B3n%20no%20funciona%20en%20mi%20canal%20beta%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3166256%22%20slang%3D%22en-US%22%3ERe%3A%20Speed%20up%20data%20entry%20and%20validation%20with%20AutoComplete%20for%20dropdown%20lists%20in%20Excel%20for%20Windows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3166256%22%20slang%3D%22en-US%22%3E%3CP%3ESubstring%20match%20does%20not%20appear%20to%20be%20working%20for%20items%20that%20contain%20only%20one%20word%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3166463%22%20slang%3D%22en-US%22%3ERe%3A%20Speed%20up%20data%20entry%20and%20validation%20with%20AutoComplete%20for%20dropdown%20lists%20in%20Excel%20for%20Windows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3166463%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20my%20experience%2C%20the%20search%20results%20only%20include%20words%20that%20begin%20with%20the%20search%20string.%20One-word%20expressions%20appear%20first%20in%20the%20results%2C%20followed%20by%20multi-word%20expressions.%20From%20the%20point%20of%20view%20of%20regular%20expressions%2C%20it%20would%20be%20appropriate%20to%20search%20anywhere%20in%20the%20items.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3201023%22%20slang%3D%22en-US%22%3ERe%3A%20Speed%20up%20data%20entry%20and%20validation%20with%20AutoComplete%20for%20dropdown%20lists%20in%20Excel%20for%20Windows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3201023%22%20slang%3D%22en-US%22%3E%3CP%3EDoes%20anyone%20know%20how%20long%20this%20will%20take%20to%20make%20it%20to%20the%20Current%20Channel%3F%20I%20am%20in%20the%20process%20of%20building%20a%20tool%20and%20would%20rather%20not%20rely%20on%20ActiveX%20controls%20to%20get%20the%20autocomplete%20feature...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3257011%22%20slang%3D%22en-US%22%3ERe%3A%20Speed%20up%20data%20entry%20and%20validation%20with%20AutoComplete%20for%20dropdown%20lists%20in%20Excel%20for%20Windows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3257011%22%20slang%3D%22en-US%22%3E%3CP%3EYes%2C%20when%20will%20this%20be%20out%20of%20beta%3F%20I'm%20keeping%20a%20project%20on%20hold%20for%20this%20because%20I%20have%20a%20list%20of%20almost%203%2C000%20items%20for%20my%20drop-down%20cell.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3259972%22%20slang%3D%22en-US%22%3ERe%3A%20Speed%20up%20data%20entry%20and%20validation%20with%20AutoComplete%20for%20dropdown%20lists%20in%20Excel%20for%20Windows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3259972%22%20slang%3D%22en-US%22%3E%3CP%3EI%20also%20have%20a%20project%20on%20hold...%20Any%20update%20on%20availability%3F%20Thank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3268813%22%20slang%3D%22en-US%22%3ERe%3A%20Speed%20up%20data%20entry%20and%20validation%20with%20AutoComplete%20for%20dropdown%20lists%20in%20Excel%20for%20Windows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3268813%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1333168%22%20target%3D%22_blank%22%3E%40SKeeeches%3C%2FA%3E%26nbsp%3B%26amp%3B%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1335935%22%20target%3D%22_blank%22%3E%40RobCalc1997%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20try%20using%20a%20free%20Excel%20add-in.%3CBR%20%2F%3EJust%20google%20%22Excel%20add-in%20called%20Search%20deList%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3269910%22%20slang%3D%22en-US%22%3ERe%3A%20Speed%20up%20data%20entry%20and%20validation%20with%20AutoComplete%20for%20dropdown%20lists%20in%20Excel%20for%20Windows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3269910%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F15804%22%20target%3D%22_blank%22%3E%40Prash%20Shirolkar%3C%2FA%3E%26nbsp%3BI%20am%20new%20to%20Office%20Insider%20Program%20and%20I%20want%20to%20explore%20the%20new%20feature%20-%20Auto%20complete%20for%20Data%20Validation.%20But%20I%20could%20not%20see%20in%20my%20Excel%20Even%20though%20the%20Excel%20was%20updated%20with%20latest%20version%202204%20(Build%2015121.20000).%20Is%20this%20feature%20removed%20or%20changed%20in%20the%20latest%20Build%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENote%3A%20After%20the%20update%20I%20done%20restart%20my%20machine%20multiple%20times%20to%20check%20if%20the%20functionality%20enabled.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20Laptop%20is%20in%20Windows%2011.%20I%20haven't%20tried%20in%20Windows%2010%20yet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20assist.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3269921%22%20slang%3D%22en-US%22%3ERe%3A%20Speed%20up%20data%20entry%20and%20validation%20with%20AutoComplete%20for%20dropdown%20lists%20in%20Excel%20for%20Windows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3269921%22%20slang%3D%22en-US%22%3E%3CP%3EYes%20kpravin89%2C%20you%20are%20right.%20This%20functionality%20is%20missing%20in%20build%202204%20(Office%20365%20CZ%2FEN%2C%20Insider%2C%20Beta%20Channel).%20I%20don't%20know%20why.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3269951%22%20slang%3D%22en-US%22%3ERe%3A%20Speed%20up%20data%20entry%20and%20validation%20with%20AutoComplete%20for%20dropdown%20lists%20in%20Excel%20for%20Windows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3269951%22%20slang%3D%22en-US%22%3E%3CP%3EOn%20my%20side%20it%20is%20not%20working%20on%20my%20windows%2011%20desktop%20(last%20beta%20version)%3C%2FP%3E%3CP%3EBut%20it%20has%20never%20stopped%20working%20on%20my%20windows%2010%20laptop%20(%3CSPAN%3E2203%20(15028.20022))%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3270209%22%20slang%3D%22en-US%22%3ERe%3A%20Speed%20up%20data%20entry%20and%20validation%20with%20AutoComplete%20for%20dropdown%20lists%20in%20Excel%20for%20Windows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3270209%22%20slang%3D%22en-US%22%3E%3CP%3ENew%20functionality%20is%20deployed%20to%20insiders%20gradually.%20If%20you%20have%20latest%20Beta%20build%20that%20only%20means%20the%20code%20for%20the%20functionality%20is%20inside%20your%20build.%20If%20you%20don't%20see%20new%20functionality%20that%20means%20such%20code%20is%20not%20activated.%20Usually%20up%20to%20half%20of%20insiders%20have%20activation%20with%20first%20flight.%20The%20rest%20could%20receive%20it%20in%20few%20weeks%20or%20in%20few%20months%2C%20it%20very%20depends%20on%20stats%20collected%20from%20first%20flight.%20After%20full%20Beta%20coverage%20it%20goes%20to%20Current%20(Preview)%20channel%20and%20after%20that%20for%20GA%2C%20channel%20by%20channel.%3C%2FP%3E%0A%3CP%3EWhich%20Windows%20version%20usually%20doesn't%20matter.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat%20is%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Finsider.office.com%2Fen-gb%2Fblog%2Fspeed-up-data-entry-and-validation-with-autocomplete-for-dropdown-lists-in-excel-for-windows%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ESpeed%20up%20data%20entry%20and%20validation%20with%20AutoComplete%20for%20dropdown%20lists%20in%20Excel%20for%20Windows%20(office.com)%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F359558iDD8ECF4D8B54CADE%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3278330%22%20slang%3D%22en-US%22%3ERe%3A%20Speed%20up%20data%20entry%20and%20validation%20with%20AutoComplete%20for%20dropdown%20lists%20in%20Excel%20for%20Windows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3278330%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHas%20there%20been%20a%20recent%20change%20to%20this%3F%20You%20used%20to%20be%20able%20to%20type%20and%20the%20list%20would%20automatically%20show%20and%20search%20as%20you%20typed.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENow%2C%20it%20doesnt%20seem%20to%20work%20as%20it%20wont%20automatically%20show%20the%20list%20when%20you%20start%20typing%20in%20the%20cell.%20You%20have%20to%20click%20the%20list%20down%20arrow%2C%20to%20open%20the%20list%2C%20then%20start%20typing%20out%20the%20string%20to%20refine.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIts%20not%20much%20of%20a%20big%20deal%2C%20but%20its%20an%20extra%20click%20and%20a%20really%20frustrating%20change.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMatt%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3280873%22%20slang%3D%22en-US%22%3ERe%3A%20Speed%20up%20data%20entry%20and%20validation%20with%20AutoComplete%20for%20dropdown%20lists%20in%20Excel%20for%20Windows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3280873%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1330939%22%20target%3D%22_blank%22%3E%40MattH75%3C%2FA%3E%26nbsp%3B%2C%20as%20it%20is%20mentioned%20in%20previous%20post%20feature%20is%20deployed%20gradually%20and%20could%20be%20pulled%20out.%20That%20what%20happened%20here.%20Let%20assume%20initially%20it%20was%20distributed%20to%2050%25%20of%20insiders.%20For%20a%20while%20it%20was%20pulled%20out%2C%20thus%20nobody%20had%20it.%20After%20the%20fixing%20(I%20don't%20know%20what%20was%20actually%20done)%20it%20was%20again%20distributed%20to%2050%25%20of%20insiders.%20The%20point%20is%20first%2050%25%20and%20second%2050%25%20are%20not%20necessary%20the%20same%20people.%3C%2FP%3E%0A%3CP%3EIt%20looks%20like%20you%20didn't%20win%20the%20lottery%20second%20time.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3282276%22%20slang%3D%22en-US%22%3ERe%3A%20Speed%20up%20data%20entry%20and%20validation%20with%20AutoComplete%20for%20dropdown%20lists%20in%20Excel%20for%20Windows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3282276%22%20slang%3D%22en-US%22%3E%3CP%3EInteresting.%26nbsp%3B%20I%20have%20just%20tried%20this%20with%20species%20of%20pet.%26nbsp%3B%20Converting%20to%20a%20data%20type%20meant%20that%20the%20cat%20became%20'domestic%20cat'.%26nbsp%3B%20Looking%20for%20the%20animal%20beginning%20with%20'c'%20still%20worked%20however.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3285062%22%20slang%3D%22en-US%22%3ERe%3A%20Speed%20up%20data%20entry%20and%20validation%20with%20AutoComplete%20for%20dropdown%20lists%20in%20Excel%20for%20Windows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3285062%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3Ethanks%20for%20the%20explanation.%20My%20users%20are%20all%20grumbling%20because%20the%20feature%20has%20been%20removed.%20We%20are%20looking%20forward%20to%20this%20being%20re-implemented.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Co-Authors
Version history
Last update:
‎Jan 28 2022 02:11 PM
Updated by: