Forum Discussion
Data Validation - Excel not suggesting values based on letters typed
I created a list of values for a column of my spreadsheet and I want Excel to suggest a value based on the first letter or letters I type. No matter what settings I try, nothing works. I either get...
Data validation doesn't provide this feature.
One option is to place the list of values immediately above the cell where you want to enter a value:
It's also possible to use a combo box in combination with some VBA: see Data Validation Combo box