Formula components missing when I type in formula

Copper Contributor



I just started using a MacBook for Excel. From my previous work with a Microsoft computer, I know that if you start typing in a formula, you get the components of it shown. This does not work for my Mac. I have a picture attached. I am talking about the yellow highlighted part which is not displayed on my Mac.  I have the newest version of Excel. How can I activate this on the Mac?


Thanks in advance and kind regards


  1. IMG_2219.jpg
5 Replies


Click on Excel (top left), then Preferences...

In the Formulas and Lists group, select AutoComplete.

Make sure the options for functions and named ranges are checked.

Hello, thank you for your answer! Everything is activated regarding the auto complete and it also was before. I even installed everything new and changed the account I am using but there is nothing that helped so far. It shows me the formulas I can choose from when I start typing it in, but when I click on one, it does not show the components of the formula. I am not missing the auto complete. Do you have an idea how I can solve this?
best response confirmed by Goethestudent (Copper Contributor)

@Goethestudent Ooops, Misread your question. To show the function arguments, make sure the Function Screen Tips are enabled in the Preferences..., View settings. That should fix it.


Screenshot 2023-09-25 at 07.06.53.png


When you are typing a formula and components are missing or not functioning as expected, it could be due to several reasons. Here are some common issues and solutions:

  1. Typographical Errors: Double-check your formula for typos, misspellings, or incorrect syntax. Even a small mistake can cause the formula to not work.

  2. Mismatched Parentheses: Ensure that you have matching parentheses in your formula. If you open a parenthesis, you must close it. Mismatched parentheses can cause errors.

  3. Function Names: Verify that you are using the correct function names. Different software and tools may have variations in function names. Check the documentation for your specific software to confirm.

@Riny_van_Eekelen This worked! I was having the same problem. Thank you!