Office Settings & Configuration

Restore Formula Suggestions in Microsoft Excel When Typing

Maira MehtabMaira Mehtab Nov 18, 2026 870 views

Question details

The user wants Excel to show formula suggestions while entering a formula.

Restore Formula Suggestions in Microsoft Excel
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.
Before you start

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.

Solution 1Recommended

Enable Formula AutoComplete in Excel

Use this setting to restore the list of matching functions while you type.

1
Open Excel options

In Excel, select File > Options.

2
Enable suggestions

Select Formulas, check Formula AutoComplete, and select OK.

3
Test a formula

Select a worksheet cell and type = followed by a few function letters, such as SUM. Check for a list of matching functions.

Enable Formula AutoComplete in Excel
Suggestions while typing: A list may not appear from an equals sign alone. Continue typing a function name to test autocomplete.
Free Microsoft Office alternative

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.

Enter and edit spreadsheet formulas in WPS SpreadsheetCompatible with Microsoft Excel formats, including XLSX and XLSFamiliar spreadsheet interface for an easier transitionFree and lightweight office suite
microsoft office alternative - wps office

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.