insert defined name

Hi John -

The command doesn't have a kybd shortcut assigned to it (at least not prior
to 2008 - I'm not sure if it was added) but you can do either of at least 2
things:

1- On the Mac you can use Insert> Name> Paste from the Excel menu bar to
bring up the list of range names, or

2- Go to the Customize Keyboard dialog box, locate the Paste... Command (in
the Insert category) and assign a keystrok of your choice.

If this sounds like the same answer I gave you last September it's because
this is the same question - AFAIK, nothing has changed:-)

Regards |:>)
Bob Jones
[MVP] Office:Mac


"john.e.palmer@gmail.com" wrote:

> in win Excel, when using the vlookup function, I could hit F3 to bring
> up a list of defined names to choose from for the 'table_array'
> portion of the formula.
> What's the equivalent keystroke for Mac Excel 2004 and 2008?
> Thanks.
>