When you purchase through links on our site, we may earn an affiliate commission. Here’s how it works.

Microsoft adds AutoComplete for dropdown lists to Excel's Android, iOS, and Mac apps


AutoComplete is a feature in many writing and math apps that we sometimes take for granted. The AI-powered feature can figure out, with some degree of accuracy, what the next word or number in a sentence or math problem we might type out ahead of us.

For Excel users in Windows, AutoComplete features while using dropdown lists has been around for a while. Today, the Microsoft 365 Insider blog has announced it's being added to the Excel apps for iOS, Android, and Mac.

The blog post states:

The feature’s algorithm can match text from anywhere in the list item—the start, the middle, or the end of the text string. The algorithm also automatically excludes blank items from the validation list.

With AutoComplete, you can fill forms and other types of content faster and more efficiently. You’ll spend less time scrolling through lists, dealing with data validation errors, or writing complex code to handle this task.

Microsoft excel dropdown lists

All Excel users have to do is open those supported apps and create a dropdown list. Then they can just start putting text in a cell that matches one of the list items. They can choose one of those list items or simply hit the Enter key or icon.

Microsoft 365 Insiders can access Excel with the new AutoComplete dropdown list feature in the following app versions:

  • Android: Build 16.0.16816.10000 or later
  • iOS: Version 2.77 (Build 23090704) or later
  • Mac: Version 16.77 (Build 23091003) or later

There is no word on when these features will reach general availability.

Microsoft recently added support for the Python coding language inside Excel for Microsoft 365 Insiders. It also plans to put in support for the company's generative AI assistant Copilot in Excel specifically for editing and adding Python code. That feature will be added in a preview program later this year and will enter general availably in 2024.

Report a problem with article
A Windows 11 Moment 4 update banner
Next Article

Microsoft releases Windows 11 (KB5030310) build 22621.2361 "Moment 4" update

A picutre with a Windows 11 wallpaper and a big M4 sign
Previous Article

Windows 11 Moment 4 Update is now available for download

Join the conversation!

Login or Sign Up to read and post a comment.

1 Comment - Add comment