Forum Discussion
Solved
Formula components missing when I type in formula
Hello, 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 ...
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.
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?
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.
Riny_van_Eekelen This worked! I was having the same problem. Thank you!
