If you click the "fx" function button instead, then you can follow prompting
that guides you through completing the formula.

If you're typing a formula normally (not using the "fx" function button),
then when the available functions start to show, use your down arrow to get
to the right one and then the tab key to select it.
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"DoctorG" wrote:

As we enter a formula in a cell, Excel finds matches of what is being written
comparing it to (all) formulas and ranges of the current workbook and
displays them in a drop down box just beneath the cell.
Can someone please tell me if there is a key combination that inserts the
currently selected list item in the formula being written and save me the
trouble of writing the whole thing by hand??