Hi there,

When I am typing in a formula (using Excel 2010), a drop down box appears with suggestions as I type. For instance, when typing =median, by the time I've typed =me, I see that median is the only choice left. I can double click my mouse on the drop down to choose that, but what I am wondering is - "is there a keystroke I can hit to select this choice?" That way, I'm not moving my hand over to the mouse and back again. I tried "enter", and "tab", but these don't seem to work. I'd like to take advantage of saving a few keystrokes if excel is offering that.

Many thanks!

Janet