+ Reply to Thread
Results 1 to 2 of 2

Drop down list that will autofill when you start typing

  1. #1
    Forum Contributor
    Join Date
    05-16-2007
    Location
    USA
    MS-Off Ver
    MS Office 2016, Excel 2016
    Posts
    216

    Drop down list that will autofill when you start typing

    Hey guys!

    I have a list of over 600 words that I would like to populate into a cell when you start typing the first letter.

    They are in alphabetical order, so if you type the letter "M", I would like the list to show the words starting with "M".

    Currently I tried the List Option under Data Validation, but it does not appear to work that way. It will only show the entire list starting at "A".

    If you start typing a letter, such as "M" and then proceed to hit the drop-down arrow, you get an error, because "M" is not a word in the list. I was hoping it would show the words starting with "M".

    If you click the drop-down arrow first, with no words in the cell, it will start at the beginning, which I would expect. But if I try to type a letter, such as "M", nothing happens; it does not move to the words beginning with "M" as I was hoping for.

    So, is there an easy way to accomplish this task?

    Mike

  2. #2
    Forum Expert
    Join Date
    06-26-2010
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    1,673

    Re: Drop down list that will autofill when you start typing

    This may not be an exact match of what you are trying to do, or it may be too much, but check out this thread as I think it is strongly related:
    http://www.excelforum.com/excel-prog...ml#post3965038
    Pauley
    --------
    If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] start typing in a cell with a drop down box and have it display matching results
    By gnagystrap in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-02-2013, 03:21 PM
  2. [SOLVED] Instead of Typing - Select from Drop down list
    By thilag in forum Excel General
    Replies: 2
    Last Post: 02-17-2013, 02:55 PM
  3. Autofill when typing in a cell with a drop down list
    By smcduffi in forum Excel General
    Replies: 2
    Last Post: 12-31-2010, 09:25 AM
  4. predictive typing:Drop Down List
    By Laura in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-17-2006, 10:55 PM
  5. Replies: 2
    Last Post: 05-16-2006, 07:33 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1