Excel lists

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I creasted a dropdown list with over 8000 items. The list works well but I
cannot search it by selecting an item then typing a letter eg 'm' should
allow me to see items begining with m etc. I overcame the problem by
creating an Entry Form and the list box works fine on that but I am curious
as to why this happened.
 
lizM

In xl2k you can sort your list "ascending" and at each change in the first
letter of your list, insert a cell and place the appropriate letter. In your
dropdown cell first just enter the first letter and then click the dropdown
arrow and you are at the beginning of that part of your list.

Does that help?

Mike Rogers
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Anyone Else Facing Public Folder Migration Errors in Exchange? 0
Validation list from Named Ranges 5
Data entered from list automatically enters number in another cell 4
Creating a dropdown list 4
Formula Count dates multiple criteria 3
Single formula to 'sort' a list onto a second sheet? 2
Postcode Area extract first alpha letters 6
Creating Serial Additions of Numbers Formatted "M-N" In Merged and Unmerged Cells 2

Back
Top