Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autocomplete for cell values
I have enabled this in excel 2007 but it is not working. I'm typing a list
of emails where the @etc is the same. help thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autocomplete for cell values
Dolores,
Autocomplete only works if the entire string matches from the beginning to the point where you are typing. If the ending is the same (the @etc part), you could use a column of formulas to add that part to the beginning part of the address: With firstname.lastname in cell A2, the formula =A2 & "@etc" will return firstname.lastname@etc And then copy that formula down to match your list. HTH, Bernie MS Excel MVP "dolores" wrote in message ... I have enabled this in excel 2007 but it is not working. I'm typing a list of emails where the @etc is the same. help thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Turning off autocomplete for one cell only | Excel Discussion (Misc queries) | |||
Clearing the autocomplete list in a cell | Excel Discussion (Misc queries) | |||
How do I enable autocomplete numbers in cell ? | Excel Discussion (Misc queries) | |||
AutoComplete | Excel Discussion (Misc queries) | |||
autocomplete? | Excel Discussion (Misc queries) |