Fix Excel AutoComplete for Cell Values Not Working
Question details
The user needs to restore predictive text or AutoComplete in an existing Excel workbook.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Entering repeated values in a column of an existing workbook.
- Observed behavior
- Excel no longer suggests or completes entries as expected, despite previous troubleshooting attempts.
Identify a column with existing text entries and check whether you can edit the cell where you want a suggestion. The menu paths below apply to desktop Excel for Windows; labels and locations may differ on other platforms.
Enable Excel AutoComplete for cell values
Use this check when Excel has stopped suggesting existing text entries as you type.
In desktop Excel for Windows, select File > Options > Advanced.
Under Editing options, select Enable AutoComplete for cell values, then click OK.
In a column containing text entries, click the next cell and type the first few characters of an earlier entry. Press Enter to accept a suggested completion.

Check the worksheet and column layout
Use these checks if AutoComplete is enabled but does not work in the affected workbook.
Test AutoComplete in a new workbook
Use a clean test to determine whether the behavior is specific to the existing workbook.
Work with Excel spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files in WPS Spreadsheet to continue working with your data and make the transition easier.

Frequently Asked Questions
Where is the AutoComplete setting in Excel?
In desktop Excel for Windows, select File > Options > Advanced. Under Editing options, select Enable AutoComplete for cell values and click OK.
Why does Excel suggest some entries but not others?
AutoComplete matches existing text entries in the same column. Check for blank rows between the entry cell and earlier values, and test with a continuous column of text.
Does formatting a cell as Text turn off AutoComplete?
No. Text formatting alone does not turn off AutoComplete. Check the setting under File > Options > Advanced and test with existing text entries in the same column.
Can worksheet protection prevent me from entering a value?
Yes. Protection can prevent editing in locked cells. Check the Review tab for Unprotect Sheet, and ask the sheet owner for permission or the password if needed.
What is the difference between AutoComplete and AutoFill?
AutoComplete suggests existing text as you type in a column. AutoFill uses the fill handle to copy cell contents or extend a series into adjacent cells.




