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 Current 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)
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. And includes excluding duplicates from the dropdown list.
We plan to expand our rollout to Excel Mac and Mobile endpoints next.
Availability and Feedback
AutoComplete for Data Validation drop-down list is available in Current Channel with version 2306, build 16.0.16501.20004 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".