+ Reply to Thread
Results 1 to 8 of 8

Excel 2007 : Autocomplete in Drop Down List Excel2007

  1. #1
    Registered User
    Join Date
    02-10-2012
    Location
    Selangor, Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    39

    Autocomplete in Drop Down List Excel2007

    Hi all

    I have cells containing large drop down lists (offering many possible entries). Is it possible to get excel to "jump" in the list or complete the entry automatically? If i start typing "aut", it should the drop down entry "automation". For your information, I just use Define Name and Data Validation to create the drop down list. Can anybody expert here to tell me how to do it? Is it must be using VBA code or I just can use Define Name and Data Validation which has been I created?

    Thanks you!

    Regard
    st3vi3

  2. #2
    Forum Expert DGagnon's Avatar
    Join Date
    02-23-2012
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2003, 2007
    Posts
    1,645

    Re: Autocomplete in Drop Down List Excel2007

    Im not sure if this will exactly help you, but it is something i have used in the past. What i have done is use a "Filter" box to narrow down the options in the drop down. this does require an extra click over what i think you are asking for, but it can make looking at a very large list easier. i use this by having a dynamic named range in a seperate sheet that is calculated by a filter cell on the front end. take a look at the attached example, i hope this can help you.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    05-04-2013
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    1

    Re: Excel 2007 : Autocomplete in Drop Down List Excel2007

    that's a great fix! I don't know VBA so this is really helpful, thanks alot.

  4. #4
    Registered User
    Join Date
    12-11-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2007,2010 and 2013
    Posts
    1

    Re: Excel 2007 : Autocomplete in Drop Down List Excel2007

    Dear All,

    i didn't get the filtered drop down list, can some please explain it more easier.

  5. #5
    Registered User
    Join Date
    07-07-2014
    Location
    Weesp
    MS-Off Ver
    Office Mac 2011
    Posts
    2

    Thumbs down Re: Excel 2007 : Autocomplete in Drop Down List Excel2007

    Funny thing is that example file does not even work with my Mac Office 2011 version :-(
    So still looking for a solution.

  6. #6
    Forum Contributor
    Join Date
    11-30-2012
    Location
    Seattle, WA
    MS-Off Ver
    Office 2007
    Posts
    212

    Re: Excel 2007 : Autocomplete in Drop Down List Excel2007

    The sample worked for me (excel 2007 for PC). I plan on using this myself! Thanks!!
    "Laugh? I thought I'd die!"

    Jimbo?

  7. #7
    Registered User
    Join Date
    08-28-2014
    Location
    Indonesia
    MS-Off Ver
    2007
    Posts
    1

    Re: Excel 2007 : Autocomplete in Drop Down List Excel2007

    thank you..i find this for a month.

  8. #8
    Registered User
    Join Date
    07-10-2014
    Location
    Los Angeles, CA
    MS-Off Ver
    Office 2010 for Windows
    Posts
    1

    Re: Excel 2007 : Autocomplete in Drop Down List Excel2007

    This sounds like the solution that I am seeking...but the 'Filtered Drop Down.xlsx' file posted by DGagnon does not work for me (Windows 7, Excel 2010). Any assistance would be appreciated!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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