insert defined name

[john.e.palmer]

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.

 

[CyberTaz]

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]

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

oops. sorry for the brain fade.