Office Settings & Configuration

Check If Autocomplete Is Available for Excel Data-Validation Drop-Down Lists

John Wilson Nov 13, 2026 869 views

Question details

The user wants to know whether Excel data-validation drop-down lists support autocomplete and how to check availability in the current Microsoft 365 build.

Check If Autocomplete Is Available for Excel Data-Validation Drop-Down Lists

Product: Microsoft Excel
Device & OS: not provided
Scenario: A user is working in Excel and wants to type partial entries in cells with data-validation drop-down lists to speed up data entry.
Observed behavior: Autocomplete has appeared in some Microsoft 365 Current Channel builds but was temporarily withdrawn because of bugs, so it is not available in all Excel desktop builds.

Before you start

Check your Microsoft 365 update channel and build number in File > Account > About Excel, and sign in with the Microsoft account associated with your Microsoft 365 subscription before testing.

Solution 1Recommended

Update Excel and Verify Autocomplete in Data-Validation Drop-Down Lists

Use this first to make sure you are running the latest Microsoft 365 build where the autocomplete feature may be re-enabled.

Check your update channel and build

Open Excel, select File > Account, and view the version and build shown under About Excel.

Install pending Office updates

In File > Account, choose Update Options > Update Now, then allow Office to download and install available updates.

Test the drop-down autocomplete behavior

Select a cell that has a data-validation list, type the first few letters of an entry, and see whether Excel suggests matching items.

Update Excel and Verify Autocomplete in Data-Validation Drop-Down Lists

Feature availability varies by update channel: If the option still does not appear after updating, Microsoft may not have re-released it for your channel and build yet.

Solution 2

Check Excel for the Web for Autocomplete Availability

Use this when the desktop build still does not show autocomplete; Excel for the web sometimes receives the feature earlier.

Free Microsoft Office alternative

Use WPS Office as a Free Microsoft Excel Alternative While Microsoft Restores Data-Validation Autocomplete

WPS Office is a free, lightweight Microsoft Office alternative that opens .xlsx workbooks, preserves Excel data-validation drop-down lists, and offers a familiar interface for editing and sharing spreadsheets without waiting for a specific Microsoft 365 build.

Edit .xlsx workbooks with Excel data-validation drop-down lists in a familiar spreadsheet interfaceFull Microsoft Excel .xlsx format compatibility for opening, editing, and savingFree to download and use, with no Microsoft 365 subscription requiredLightweight and easy to use while Microsoft resolves the autocomplete rollout

microsoft office alternative - wps office

Frequently Asked Questions

Why is autocomplete missing from my Excel data-validation drop-down list?

The feature was rolled out in some Microsoft 365 Current Channel builds but was temporarily withdrawn because of bugs. Availability depends on your Excel update channel and build.

How do I check my Microsoft 365 update channel and version in Excel?

Open Excel, go to File > Account, and look under About Excel to see your version number, build, and update channel.

Can I use Excel for the web to get autocomplete in data-validation lists?

Yes. Excel for the web may have the feature even when desktop Excel does not. Open the workbook from OneDrive or SharePoint at office.com and test a data-validation cell.

Does updating Excel guarantee that data-validation autocomplete will appear?

No. Updating ensures you have the latest available build, but Microsoft may not have re-released the feature for every channel yet.

Can WPS Office open Excel files that contain data-validation drop-down lists?

Yes. WPS Office Spreadsheets supports .xlsx files and can open, edit, and save workbooks that contain Excel data-validation drop-down lists.

Office App Problems