How to Fix Excel Data Validation List Autocomplete Not Working
Question details
The user's Excel data validation dropdown previously auto-completed typed values but now only shows the list or requires the full entry, and the standard AutoComplete setting does not control this validation-list autocomplete feature.

- Product
- Microsoft 365 Excel
- Device & OS
- not provided
- Scenario
- A user relies on a data-validation list for faster, consistent data entry in Excel and wants to restore autocomplete behavior after it stopped working.
- Observed behavior
- Excel no longer completes matching values from the data validation list while typing and only displays the dropdown or requires the full value.
Before troubleshooting, confirm that the worksheet still contains a data validation list and note your current Microsoft 365 Excel build from File > Account > About Excel. Validation-list autocomplete is separate from the general AutoComplete option, so checking that setting alone is not enough.
Install the latest Microsoft 365 Excel updates and verify the autocomplete feature build
Use this when Excel data validation list autocomplete stops after an update, because Microsoft has changed this feature by build and rollout.
Validation-list autocomplete in Excel is not controlled by the general AutoComplete setting. Microsoft has documented this as a separate feature that can vary by update channel and build.
Click File > Account > Update Options > Update Now.
Let Microsoft 365 check for and install available updates, then restart Excel.
Type the first few characters in a cell that uses a data validation list and check whether matching values appear.
If the issue continues, review the Microsoft Tech Community autocomplete discussion to see whether your build or update channel is affected.

Use the validation dropdown or a searchable helper control as a temporary workaround
Use this while waiting for the Microsoft update or if your Excel build no longer supports the old in-cell autocomplete behavior.
Use WPS Office for Stable Excel File Editing and Data Validation Lists
WPS Office is a free, lightweight Office alternative that opens, edits, and saves Microsoft Excel .xlsx workbooks with data validation lists, formulas, and formatting. Its familiar ribbon interface makes migration easy while avoiding Microsoft 365 feature rollouts that temporarily break autocomplete.
- 1. Download WPS Office: Go to the official WPS Office download page and click Download WPS Office Free.
- 2. Install and open the Excel workbook: Install WPS Office, then open the .xlsx workbook that contains the data validation list.
- 3. Use or edit the validation list: Click the data validation cell and use the dropdown arrow to select a value, or edit the list through Data > Validation in WPS Spreadsheets.

Frequently Asked Questions
Why does Excel data validation list no longer autocomplete even though AutoComplete is enabled?
Validation-list autocomplete is a separate feature from the general AutoComplete setting. It depends on the Microsoft 365 Excel build and update channel, so check for updates via File > Account > Update Options > Update Now.
How do I check my Excel build for the autocomplete feature?
Open Excel, go to File > Account, and view the version/build under About Excel. Compare it with the Microsoft Tech Community announcement or install the latest updates to see if the feature is available in your build.
What temporary workaround can I use until autocomplete returns?
Use the validation dropdown arrow to select a value, type the full value exactly as it appears in the source list, or add an ActiveX Combo Box from the Developer tab as a searchable helper control.
Can WPS Office open Excel workbooks that contain data validation lists?
Yes, WPS Office supports .xlsx files and preserves data validation dropdowns, formulas, and formatting, making it a free alternative for opening and editing Excel workbooks.




