Restore Formula Suggestions in Microsoft Excel When Typing
Question details
The user wants Excel to show formula suggestions while entering a formula.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user types an equals sign and begins entering a function in a worksheet cell.
- Observed behavior
- The expected formula autocomplete menu does not appear.
Open a workbook in desktop Excel and select a cell. Type = followed by the first few letters of a function, such as =SUM, to check whether suggestions appear.
Enable Formula AutoComplete in Excel
Use this setting to restore the list of matching functions while you type.
In Excel, select File > Options.
Select Formulas, check Formula AutoComplete, and select OK.
Select a worksheet cell and type = followed by a few function letters, such as SUM. Check for a list of matching functions.

Check the formula bar and function ScreenTips
Use these display settings if the formula bar or function argument hints are also missing.
Check whether an Excel add-in is interfering
Try this if Formula AutoComplete is enabled but suggestions still do not appear.
Work with Spreadsheet Formulas in WPS Office
WPS Office is a free, lightweight alternative for working with spreadsheets in a familiar interface. Open compatible Excel files in WPS Spreadsheet to continue working with formulas and make the transition between office suites easier.

Frequently Asked Questions
Where is the Formula AutoComplete setting in Excel?
In desktop Excel, select File > Options > Formulas and check Formula AutoComplete. Select OK to apply the setting.
Why do no suggestions appear when I type only an equals sign?
Excel may need more of the function name before it displays matching suggestions. Type a few letters after the equals sign, such as =SUM, to test it.
Is the formula bar the same as formula autocomplete?
No. The formula bar displays and lets you edit cell contents; Formula AutoComplete suggests functions and other formula elements while you type. You can show the bar from the View tab or File > Options > Advanced.
How do I restore the hints showing a function's arguments?
Select File > Options > Advanced and check Show function ScreenTips under Display. These hints are separate from the autocomplete list.




