• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Autofill when Using Data Validation


New Member
I'm using Data Validation in Excel 2007 with a very large list (500+ items). If I start typing one of the items on the list, Excel doesn't autofill based off of items in the list; it only autofills from items I've typed into the box in the past.

Does anyone know of a way to fix this so that it will suggest from the list?


Not with Data Validation. It can be done with a combobox, but that is a less friendly control in other words, so my advice is regrettably to live with it.