Excel 2007 Level 100 question

[Ron de Bruin]

hi WSR

You can use the Tab key

 

[WSR]

Typing in an "=" sign with some letters and Excel suggests a few funtions or
in my case some pre-named ranges.

Yet when I arrow down to the name that I want and press "Enter" I get a
#NAME? error so I need to use my mouse to double-click on that function in
order to select it.

Any way to select a named range after entering an equal sign without using
my mouse?

Thanks.

8^>