Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
Data Validation - List - keeping the format of the list - shading | Excel Discussion (Misc queries) | |||
Remove empty cells from named list / validation list | Excel Worksheet Functions | |||
validation list--list depends on the selection of first list | New Users to Excel |