Office Settings & Configuration

Fix Excel AutoComplete for Cell Values Not Working

Adam DavisAdam Davis Nov 18, 2026 869 views

Question details

The user needs to restore predictive text or AutoComplete in an existing Excel workbook.

Fix Excel AutoComplete for Cell Values Not Working
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.
Before you start

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.

Solution 1Recommended

Enable Excel AutoComplete for cell values

Use this check when Excel has stopped suggesting existing text entries as you type.

1
Open Excel options

In desktop Excel for Windows, select File > Options > Advanced.

2
Enable AutoComplete

Under Editing options, select Enable AutoComplete for cell values, then click OK.

3
Test an existing entry

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.

Enable Excel AutoComplete for cell values
AutoComplete and AutoFill are different: AutoComplete suggests existing text entries in a column. AutoFill uses the fill handle to copy values or extend a series.
Free Microsoft Office alternative

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.

Edit spreadsheet data in a familiar interfaceOpen and save Microsoft Excel formats such as XLSX and XLSUse a free, lightweight office suiteMove existing spreadsheets into WPS without starting from scratch
microsoft office alternative - wps office

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.