The AutoComplete menu doesn't appear

Cause: The AutoComplete menu has been disabled.

Solution:    Turn on AutoComplete

  1. On the Excel menu, click Preferences.

  2. Under Formulas and Lists, click AutoComplete  Knappen Indstillinger for Autofuldførelse i Excel .

  3. Select the Show the AutoComplete menu for functions, named ranges check box.

Cause: The AutoComplete menu is set to appear only after letters have been entered.

Solution:    Show the AutoComplete menu after an equals sign (=) is entered.

  1. On the Excel menu, click Preferences.

  2. Under Formulas and Lists, click AutoComplete  Knappen Indstillinger for Autofuldførelse i Excel .

  3. In the Show the menu only after I've typed box, change the value to 0.

See also

Use AutoComplete when entering formulas

Using structured references in your formulas

Del Facebook Facebook Twitter Twitter Mail Mail

Var disse oplysninger nyttige?

Fantastisk! Har du mere feedback?

Hvordan kan vi forbedre det?

Tak for din feedback!

×