Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation
Hello! Friends:
Appreciate if anyone could help on the followings (EXCEL 2003): My data are stored in Col A (say, A1.A10) Under Data/Validation/Setting/Allow List/Source, I give a range of A1.A50 to cater for future data expansion. That is A11.A50 are blanks at this time. Question: Even after checking both boxes "Ignore Blank" and "In-cell dropdown", I still get the blank cells in the drop-down list. Why is it so? And how to remove the blanks from the drop-down list? Many Thanks. Lee CC |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
Data Validation Update Validation Selection | Excel Worksheet Functions | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) |