Office Settings & Configuration

How to Fix Excel Data Validation List Autocomplete Not Working

Algirdas JasaitisAlgirdas Jasaitis Nov 13, 2026 868 views

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.

How to Fix Excel Data Validation List Autocomplete Not Working
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 you start

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.

Solution 1Recommended

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.

1
Open Excel Update Options

Click File > Account > Update Options > Update Now.

2
Install available updates

Let Microsoft 365 check for and install available updates, then restart Excel.

3
Test the validation list

Type the first few characters in a cell that uses a data validation list and check whether matching values appear.

4
Check the Microsoft feature discussion

If the issue continues, review the Microsoft Tech Community autocomplete discussion to see whether your build or update channel is affected.

Install the latest Microsoft 365 Excel updates and verify the autocomplete feature build
Autocomplete restored after update: After installing the current build, many users regain validation-list autocomplete.
Free Microsoft Office alternative

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. 1. Download WPS Office: Go to the official WPS Office download page and click Download WPS Office Free.
  2. 2. Install and open the Excel workbook: Install WPS Office, then open the .xlsx workbook that contains the data validation list.
  3. 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.
Opens and edits Microsoft Excel .xlsx workbooks with data validation lists and formulas.Free, lightweight Office suite that does not require a Microsoft 365 subscription.Familiar ribbon interface reduces the learning curve when switching from Excel.Preserves .xlsx formatting and supports seamless file sharing with Excel users.
microsoft office alternative - wps office

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.