Quick Find in long drop down list

  • Thread starter Thread starter Candyman
  • Start date Start date
C

Candyman

I would like to be able to type the first few letters in a cell that uses a
long drop down list and quickly go to the full name in the list without
having to start at the top of the list and scrolling down every time.
 
That one I know as one of the good guys answered for me before :
get a COMBO BOX from the control box toolbar, give the properties of the cell
with the dv and move it on top of it.
 
Sorry, I failed to say I use Excel 2007. I am unfamiliar with combo boxes and
could use more detailed instruction. Also my drop down boxes are data
validation lists if that makes a difference.
 

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

Drop Down Lists 4
Drop down list quicker selection 5
excel drop down list 4
How can I select an item in a drop down ? 1
Movement of cursor within a drop down list 1
drop down list 3
Excel Excel: How do I put a formula in a drop down list 11
Drop Down List Quicker Selection 4

Back
Top