Formula Autocomplete - How to select via keyboard?

[gsjan1]

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

[jeffreybrown]

Hi Janet,

Selecting the tab key works for me

[gsjan1]

That's it! Thought I'd tried that - sorry. Many thanks and Happy Day to you!

[Cutter]

Tab works for me.

[jeffreybrown]

And same to you Janet.

Thanks for the feedback and glad you have it working