Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

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

Microsoft

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.

 

AutoComplete-Data-Validation-GIF-Space.gif

 

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

1 Reply

@Iqra_Sharif 

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.

 

ethic78_0-1660779998287.png