Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Validation list behaving strangely in 2003
Hi folks,
I don't know if any of you have met this before....I have a validation list comprising for example blank, ford, mazda the blank cell recognised until I enter a non blank value...eg if I enter Mazda and then decide to change it back to blank the blank option has gone. Even more bizarre, I have another validation list in another part of the spreadsheet also with a blank cell that works perfectly. I have tried the usual work arounds of creating a non blank cell, making the validation list, and then deleting the contents of the non blank cell but it does not work. the ignore blank cell otion is not ticked. Any ideas? Thanks, Danny |
#2
|
|||
|
|||
I can't recreate the problem. Is the list a named range or a cell reference?
But why do you need a blank cell in the dropdown list? You can always delete the entry, and leave the cell blank. Danny J wrote: I don't know if any of you have met this before....I have a validation list comprising for example blank, ford, mazda the blank cell recognised until I enter a non blank value...eg if I enter Mazda and then decide to change it back to blank the blank option has gone. Even more bizarre, I have another validation list in another part of the spreadsheet also with a blank cell that works perfectly. I have tried the usual work arounds of creating a non blank cell, making the validation list, and then deleting the contents of the non blank cell but it does not work. the ignore blank cell otion is not ticked. Any ideas? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
You may not believe this but it never occurred to me to just delete the
entry...as for reproducing it, I have never seen it happen before so I am not surprised. Thank you for your help. Danny "Debra Dalgleish" wrote in message ... I can't recreate the problem. Is the list a named range or a cell reference? But why do you need a blank cell in the dropdown list? You can always delete the entry, and leave the cell blank. Danny J wrote: I don't know if any of you have met this before....I have a validation list comprising for example blank, ford, mazda the blank cell recognised until I enter a non blank value...eg if I enter Mazda and then decide to change it back to blank the blank option has gone. Even more bizarre, I have another validation list in another part of the spreadsheet also with a blank cell that works perfectly. I have tried the usual work arounds of creating a non blank cell, making the validation list, and then deleting the contents of the non blank cell but it does not work. the ignore blank cell otion is not ticked. Any ideas? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
List, Data Validation, unlocked cell, protected sheet..... | New Users to Excel | |||
Auto scroll down data validation list | Excel Discussion (Misc queries) | |||
Data Validation List =Name | Excel Discussion (Misc queries) | |||
Data Validation list selection question | Excel Worksheet Functions | |||
Validation - List - Separate Worksheet | Excel Worksheet Functions |