XLSX - Use AutoComplete when entering formulas

Turn on AutoComplete

  1. On the Excel menu, click Preferences.

  2. Under Formulas and Lists, click AutoComplete.

  3. Select the Show AutoComplete options for functions and named ranges check box.

When the AutoComplete menu appears, you can use the UP ARROW and DOWN ARROW keys to select an item from the list. Press the TAB key to insert the selected item.


  • You can also press the RETURN key to insert an item from the AutoComplete menu in Excel for Mac.Using the TAB key is recommended for compatibility with Windows versions of Excel.

  • After you enter an item from the AutoComplete menu, don't forget to type the closing parenthesis for a function, closing bracket for a table reference, or closing quotation mark for a text string if it hasn't been inserted automatically.

ORIGIN LINK: https://support.microsoft.com