Stefi,

The closest you can come to that easily is to put a copy of the validation list into the cells
immediately above your data entry area. Then, if you have a contiguous block, Autocomplete will
offer up the first unique item....

HTH,
Bernie
MS Excel MVP


"Stefi" wrote in message
...
If I have a cell (say A1) with a validation list and I have values in other
cells of the same column (A), when typing a letter into A1 Excel (2003)
offers the first value in column A beginning with the letter just typed in
cell A1, as is the case in normal inputting.
In my opinion it should be more useful, if in the case of inputting into
cells with a validation list (A1) Excel would take the value offered for
input not from column A, but from the source of the validation list. E.g.
typing letter "B" int cell A1 should result in offering the first value of
the source beginning with "B", simultaneously displaying the validation drop
down list positioned on the value offered.

Regards,
Stefi