brockangelo
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?
Does anyone know of a way to fix this so that it will suggest from the list?