I want to create a very large validation list (approx 685 records). How can I get it so that when people using the spreadsheet start to type a word from the validation list ir automatically fills in for you (such as in IE when your typing a web address you have already visited).....Any guidance would be great as my customers are fussing about looking through a list so long and manually picking out what they need.