| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to show the full name without typing all the name
how can I type the first letter of the name and the full name show up ?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to show the full name without typing all the name
This is a group for Excel. the full name of what show up?
ziad wrote: how can I type the first letter of the name and the full name show up ? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to show the full name without typing all the name
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. -- --Laura - MS Office 2007 Professional user on Windows XP - SP3 "ziad" wrote: how can I type the first letter of the name and the full name show up ? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to show the full name without typing all the name
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. On Oct 21, 11:51*pm, ziad wrote: how can I type the first letter of the name and the full name show up ? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to show the full name without typing all the name
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 On Wed, 21 Oct 2009 11:51:02 -0700, ziad wrote: how can I type the first letter of the name and the full name show up ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to show a list of words by typing a few letters | Excel Discussion (Misc queries) | |||
| How do I get Office 2007 to show me the full path of a file? | New Users to Excel | |||
| why won't my typing in a cell show up????????? | Excel Discussion (Misc queries) | |||
| only the macro name and not the full path to show in the run box | Excel Discussion (Misc queries) | |||
| Show full path of files being saved | Excel Discussion (Misc queries) | |||
Linear Mode
