Office Settings & Configuration

How to Remove the Function Drop-Down List in an Excel Cell

Kushani NimanthikaKushani Nimanthika Nov 13, 2026 870 views

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.

How to Remove the Function Drop-Down List in an Excel Cell
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.
Before you start

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.

Solution 1Recommended

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.

1
Open Options from the File or Menu tab

In Microsoft Excel, click File > Options. In WPS Office Spreadsheets, click the Menu button in the top-left corner and choose Options.

2
Locate the AutoComplete setting

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.

3
Clear Enable AutoComplete for cell values

Clear the checkbox named Enable AutoComplete for cell values or AutoComplete for cell values, then click OK.

4
Test formula entry

Type = or the first letters of a function in a cell again and confirm the function suggestion list no longer appears.

Turn Off Formula AutoComplete in Excel or WPS Spreadsheets
AutoComplete disabled: Formula AutoComplete is turned off without changing any existing formulas or cell data.
WPS Spreadsheets

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. 1. Open the workbook in WPS Spreadsheets: Launch WPS Office Spreadsheets and open the workbook where the function dropdown appears.
  2. 2. Open Options: Click the Menu button in the top-left corner, then click Options.
  3. 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. 4. Disable AutoComplete: Clear the checkbox for Enable AutoComplete for cell values and click OK.
  5. 5. Test a cell: Type = or a function name and verify the dropdown no longer appears.
Stops the function suggestion list during formula entry without altering cell contents.Reads and saves Microsoft Excel formats such as .xlsx, .xls, and .xlsm.Familiar ribbon and settings path make the AutoComplete option quick to find.Free download for everyday spreadsheet editing without a subscription.
microsoft office alternative - wps office

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.