Making excel functions display arguement list

Question

Hi all&nbsp;I use a lot of functions in excel, and until recently excel always displayed the arguements that needed to be completed in a function as I type. For example, as I type =VLOOKUP(&nbsp;Excel would produce a box underneath showing&nbsp;VLOOKUP(Lookup Value, Range, Column Number, Exact Match) or words to that effect, with the arguement I am currently completing in bold. This was very helpful when inputting nested functions etc&nbsp;&nbsp;However, recently excel has ceased to show those details. I am provided with a list of functions as I type the function name in, but once I have opened the initial bracket the 'help' box listing the order of arguements does not appear. Does anyone know how to instruct this box to appear again?&nbsp;The same is true whether editing in the cell or the formula box. Using Office 365, Excel is fully up to date.&nbsp;&nbsp;&nbsp;&nbsp;

detlef_lewin · Answer

David920&nbsp;It happened to me and took me ages to find the solution.&nbsp;https://support.microsoft.com/en-us/office/use-formula-autocomplete-6d13daa5-e003-4431-abab-9edef51fae6b&nbsp;&nbsp;You probably accidentally pressed ALT-DOWN-ARROW in the formula bar.

sergeibaklan · Answer

David920&nbsp;
Perhaps a bug on concrete build for your channel. On

it works

sergeibaklan · Answer

David920&nbsp;
and

david920 · Answer

SergeiBaklan&nbsp;thanks for that, possibly an issue with the build (I have version 2111)

david920 · Answer

Thanks very much for that - it definitely looks like formula autocomplete is the functionality that is only partially turned on, unfortunately the alt+down arrow only seems to turn on/off the drop down list of functions for me without turning on the list of arguements of the function but a good place to start!

Forum Discussion

Making excel functions display arguement list

5 Replies

Resources