PDA

View Full Version : Ignore blank in Data Validation



alok2007
06-07-2007, 10:10 PM
Can someone please explain me the significance / concept of "Ignore Blank" found in Data \Validation ? whwnever I have used the same, I never unchecked the same? Please elaborate. I think it might have some use.

geekgirlau
06-07-2007, 10:36 PM
If you remove the "Ignore Blank", when you start editing the cell Excel forces you to enter a value; you cannot leave it blank. However IMHO it's a bit useless, because you can still delete the contents of the cell without an error message appearing, and therefore end up with a blank cell.

Bob Phillips
06-08-2007, 01:54 AM
It actually does the opposite of what you would think (or at least wht I would think). If you have a list say, and you select a value, if Ignore Blank is unchecked, you cannot then clear the input.

alok2007
06-08-2007, 03:22 AM
When I tried to clear the input list, I succeed. The list cleared as usual