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.