I have a list of several hundred names which I linked to a column of cells
using validation

Does that mean it's a data validation drop down list?

You can use a combo box from the control toolbox. This type of combo box has
an "autocomplete" feature.


--
Biff
Microsoft Excel MVP


"Charlie7805" wrote in message
...
I have a list of several hundred names which I linked to a column of cells
using validation. Is there a way to begin typing a name and have auto
fill
search alphabetically making the section process quicker and easier?