Ask a Computer Question, Get an Answer ASAP!
You can set up data validation to select preset names from a list.
Is that what you mean?
Ok, let me check with the other experts on this...
it is not possible for you to have excel do this. WHat you want to do is type "george" in the first row, "grange", then type "g" in the 3rd rwow and have it determine you want one of the previous g names. But this is only possible on a per column Basis, like if you have all the names in column Q then this will only work in column Q and will only work for previous typed names in the same column