Z
ziad
how can I type the first letter of the name and the full name show up ?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob I
This is a group for Excel. the full name of what show up?
L
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.
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.
M
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.
click office button | excel option | proofing | Auto correct options
|
Use Replace and with | add | ok
excel 2003
On the Tools menu, click AutoCorrect Options.
G
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
below where you are typing, autocomplete will kick in.
Gord Dibben MS Excel MVP