how to show the full name without typing all the name

[ziad]

how can I type the first letter of the name and the full name show up ?

 

[Bob I]

This is a group for Excel. the full name of what show up?

 

[Lauranator]

One little trick I do is to make it part of your AutoCorrect words. Go into
Options, then Proofing, then AutoCorrect Options. Then in the Replace: field
type in the first two or three letters of the name, and in the With: field,
type in the full name, then click the Add button to save. Then when you're
working in your document, you would simply type those first two or three
letters and then space bar, and it will automatically put in the full name.

Hope this helps.

 

[muddan madhu]

excel 2007
click office button | excel option | proofing | Auto correct options
|
Use Replace and with | add | ok

excel 2003
On the Tools menu, click AutoCorrect Options.

 

[Gord Dibben]

If you have a pre-existing list of the names in a contiguous range above or
below where you are typing, autocomplete will kick in.


Gord Dibben MS Excel MVP