Just double-click on the function you want from the list.

Key combination I don't about.

Would be nice to find out.


Gord Dibben MS Excel MVP

On Fri, 12 Feb 2010 10:29:01 -0800, 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??