Hi Amy,

Am Mon, 18 Nov 2013 02:07:16 +0000 schrieb amy chan:

name ID
==== ===
peter 123
mary 456
peter 452
tom 125
peter 544
john 524

kity 144
tom 524
vivi 521
peter 572

if you fill the name column without blank cells and Peter already exists
in the column you get the suggestion Peter while writing P and you can
confirm it with Enter.
For me this way is easier and faster than clicking on dropdown, looking
for the name in the list and select it.
If you want a dropdown then select the cells = Data = Data Validation
= List and put in your names as source


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2