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.  

 

Best,
Iqra

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