Predictive Text

Hi all,

I was wondering if there is a feature that will allow predictive text. I have a list of records over 100, I dont want users to scroll down all 100 records, so is there a way of creating predictive text..

Excel version 2007 is what im using

Basically, I have a list of records for Location, I went to data mangement and selected List and selected the range (of location). I then have a dropdown list. But I have soo many records in this, what I would like to do is when the user types in Lo...it predicates the text for them, jus like when you select Filter on a column and then type in a word it auto predicts the words