Auto-Complete

  • Thread starter Thread starter BillJunior
  • Start date Start date
B

BillJunior

I am creating a excel sheet that has a list of about 800
names on it. I want to be able to have a seperate sheet
that I can start to type in the name and it will auto-
complete it. Is there any way that this can be
accomplished?

Thanks,

BillJunior
 
Well, let me start by saying that is a great site. But
the data validation wont work either. It is close, but
the thing is that with about 800 possible choices it
becomes difficult to find the specific name you are
looking for.

I must say I am quite shocked that it doesn't auto-
complete, but ultimately, auto-complete is the option I
am looking for. If I am unable to resolve the auto-
complete problem I will still use the data validation as
it would still be easier.

Thank you,

Bill Collyns Jr.
 
Bill

Auto-complete operates only in the column in which the previous data is
listed.

Gord Dibben Excel MVP
 
Back
Top