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


We’ve heard from many of you that you’d love the ability to use AutoComplete for dropdown lists to make data entry and validation faster and easier. We’re excited to announce that this capability is finally here in Excel for Windows!


Entering data in Excel can sometimes be a slow and painful task. Dropdown lists are one way to speed up this process, but scrolling through long lists is no fun either. So we’ve enabled AutoComplete for dropdown lists in Excel. Now, the app automatically compares the text you type in a cell against all items in the list, then displays only the items that match.




Read all about it, right here.  



Office Insider Community Manager

Become an Office Insider and gaining exclusive access to new features and help shape the future of Office. Join Now: Windows | Mac | iOS | Android

1 Reply


I just downloaded Microsoft 365 and excel doesn't have the AutoComplete for dropdown lists. Is it still not offered in all versions?  My info is below.