Data Validation List

  • Thread starter Thread starter Des_2001
  • Start date Start date
D

Des_2001

I want my validation cells, when I hit a certain key, to automatically go to
everything on my list that starts with that particular letter. For example,
if I hit 'B' and the first word that starts with 'B' on my list is 'bat,' I
want the word 'bat' to automatically pop up in the cell. Is there a way to do
this?
 
You can get close to that. Sort your validation list and at the beginning
of the A's enter a single A, do the same for the beginning of the B's and
all the way through to the Z's.

Click in the cell that has the drop down validation and type in the letter
of the list you desire... say you type in an O. DO NOT hit enter... leave
the cell in the edit mode (still selected) and now hit your down arrow.

Should take you to the O which is the top of the O list of selections.

I believe there is an auto-complete using the drop down box from another
source in Excel, but it escapes me at the present. The above works for the
Data > Validation from the Forms tool bar.

HTH
Regards,
Howard
 
Back
Top