How to use fx autocomplete in Excel w/o mouse

Question

When you type a formula into Excel 2007, it brings up hints for functions. For example, type =L into the fx field and a bunch of functions will appear in a drop down menu (Large, LCM, Left, etc).

Using the up and down keys, you can select a function. But I cannot figure out how to select that function without using the mouse! The enter key, space bar, insert key all don't work. But double clicking the function will place it into the formula bar. Is there a key to do that?

Answer 1

Select the function you want using the arrow keys as your doing now, then press the TAB key to auto-complete to that function.