# Excel List Validation Question

**URL:** <https://boards.straightdope.com/t/excel-list-validation-question/593718>\
**Category:** Factual Questions\
**Created:** [August 22, 2011, 11:47pm UTC](https://boards.straightdope.com/t/excel-list-validation-question/593718 "2011-08-22T23:47:31Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Gangster\_Octopus](https://avatars.discourse-cdn.com/v4/letter/g/a8b319/32.png) [@Gangster\_Octopus](https://boards.straightdope.com/u/Gangster_Octopus)\
**Post date:** [August 22, 2011, 11:47pm UTC](https://boards.straightdope.com/t/excel-list-validation-question/593718/1 "2011-08-22T23:47:31Z")

</div>

Ok so I have this cell that uses a list as validation. So my list has maybe a 100 items in its and I would like it so that if I started typing in the cell options from the list start appearing. So for example, if I had a list:

Jackson  
Johnson  
Jones  
Williams  
Smith

and I started typing ‘J’ then the drop down list would shrink to just the first entries. And then when I typed an O it would just have Johnson and Jones and finally when I typed an H it would just show Johnson.

For an example look at this webpage

> **[NFL National Football League News, Video, Rumors, Scores, Stats, Standings -...](https://sports.yahoo.com/nfl/)**
>
> Sports News, Scores, Fantasy Games

and hover over Players in the bar above the main content. An entry box appears and if you start entering letters it gives you options.

Is this at all possible?