Keyboard shortcut

[ElvisSteel]

Hi,

Hopefully a straightforward question.

When editing a formula, Excel automatically provides a drop-down list of Range Names that match the characters you have typed.
Is there a key you can press to use the highlighted name. I've tried all sorts of variations, but with no luck, so I'm having to double-click the required name.

Thanks

Steve

 

[GlennUK]

Press Tab

 

[ElvisSteel]

Thanks very much.

That was about the only key I hadn't tried!

 

[GlennUK]

Glad to help