How to Remove the Function Drop-Down List in an Excel Cell
Question details
The user wants to remove a function suggestion list that appears while typing in an Excel cell and needs to disable Formula AutoComplete.

- Product
- WPS Office Spreadsheets / Microsoft Excel
- Device & OS
- not provided
- Scenario
- While typing a formula or value in a spreadsheet cell, a dropdown list of function suggestions appears and the user wants it to stop.
- Observed behavior
- The dropdown is Formula AutoComplete, so Data Validation is unavailable for that cell and the list continues to appear during formula entry.
Confirm whether the list appears only when you type formula-related text. If it appears when you click the cell or select a value, check Data Validation first.
Turn Off Formula AutoComplete in Excel or WPS Spreadsheets
Use this solution when the dropdown appears only while typing a formula and the cell has no Data Validation rule.
The dropdown that appears during typing is usually Formula AutoComplete, not a Data Validation list. Disabling this setting stops formula suggestions without affecting the worksheet data.
In Microsoft Excel, click File > Options. In WPS Office Spreadsheets, click the Menu button in the top-left corner and choose Options.
In Excel, select Formulas. In WPS Office, select Formulas or Calculation depending on your version. If it is not there, check the Advanced or Edit tab.
Clear the checkbox named Enable AutoComplete for cell values or AutoComplete for cell values, then click OK.
Type = or the first letters of a function in a cell again and confirm the function suggestion list no longer appears.

Remove an Actual Data Validation Drop-Down List
Use this if the cell contains a Data Validation list and you want to delete the dropdown itself.
Turn Off Formula AutoComplete with WPS Office Spreadsheets
WPS Office Spreadsheets includes an AutoComplete option similar to Excel, so you can remove the function dropdown and keep working in a familiar spreadsheet interface.
- 1. Open the workbook in WPS Spreadsheets: Launch WPS Office Spreadsheets and open the workbook where the function dropdown appears.
- 2. Open Options: Click the Menu button in the top-left corner, then click Options.
- 3. Go to Formulas or Calculation settings: In the Options dialog, select the Formulas or Calculation tab. If your version stores AutoComplete under Edit or Advanced, open that tab instead.
- 4. Disable AutoComplete: Clear the checkbox for Enable AutoComplete for cell values and click OK.
- 5. Test a cell: Type = or a function name and verify the dropdown no longer appears.

Frequently Asked Questions
Why can’t I use Data Validation to remove the function list in an Excel cell?
Because the list is Formula AutoComplete, not a Data Validation dropdown. You need to change the AutoComplete setting under File > Options > Formulas in Excel, or under Menu > Options in WPS Spreadsheets.
How do I turn off formula suggestions in WPS Spreadsheets?
Click the Menu button in the top-left corner, choose Options, go to the Formulas or Calculation tab, clear Enable AutoComplete for cell values, and click OK.
Does disabling Formula AutoComplete delete my existing cell data?
No. It only stops the suggestion list from appearing while you type. Existing formulas, values, and formatting remain unchanged.
Can I turn off the function dropdown for only one cell?
AutoComplete is an application-level setting, so it affects formula entry across the workbook. For a single-cell dropdown, remove the Data Validation rule from that specific cell instead.
Where is the AutoComplete setting in Excel?
In most Excel versions, go to File > Options > Formulas and clear Enable AutoComplete for cell values. In some versions, the setting is under File > Options > Advanced in the Editing options section.




