Selecting the autocomplete cell name? How do I do it?

[doctorevii2001]

I am writing formulas that reference cells with defined names (for Example "First_Exterior_Wall_LF") and when I start typing the cell name into the formula window it drops down a little autocomplete (so I type "First_E" and the proper cell is listed right below), but I can't seem to select or click on it to auto complete (I just have to type the whole thing out).




This is getting a little tedious. Surely there's a way to select it rather than type it every time? Is this possible?

I've tried hitting enter, space, clicking on it, right clicking on it... Hoping for a keyboard shortcut, though, so I can keep typing the formulas.

I appreciate the help!

 

[philwojo]

I double click on it and it works for me.

 

[Rick Rothstein]

I double click on it and it works for me.

I just hit the Tab key and that also seems to work.

 

[doctorevii2001]

I just hit the Tab key and that also seems to work.

Tab was the trick! Of course the one button that makes perfect sense that I didn't try, lol.

Thank you for your help!