excel list of values selections to be reduced as you type

This has been asked before (no accepted answer yet, though). A data validation drop down can't do this for you. You need to use an active X control, like a Combo box. This requires a bit of programming.