Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation - Ignore Blank
I have noticed the "Ignore blank" check box in my Data Validation
window (XL2003), but i cannot figure out what it does. Nor can i find an answer in the Help files. Just what does this option do? Thanks, Tonso |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation - Ignore Blank
Ignore Blank: If checked, blank entries are allowed.
-- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "Tonso" wrote: I have noticed the "Ignore blank" check box in my Data Validation window (XL2003), but i cannot figure out what it does. Nor can i find an answer in the Help files. Just what does this option do? Thanks, Tonso . |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation - Ignore Blank
If the source list is a named range that contains blank cells, users may be
able to type any entry, without receiving an error message. To prevent this: Select the cell that contains a data validation list Choose Data|Validation On the Settings tab, remove the check mark from the Ignore blank box. Click OK Note: If the source list contains blank cells, and is a range address, e.g. $A$1:$A$10, it will block invalid entries with Ignore blank on or off. Second.......................................... If your list is directly entered as a comma de-limited list you can add a blank entry by adding a comma <space i.e. NA,dog,cat,fish,<space Gord Dibben MS Excel MVP On Fri, 19 Mar 2010 05:18:00 -0700 (PDT), Tonso wrote: I have noticed the "Ignore blank" check box in my Data Validation window (XL2003), but i cannot figure out what it does. Nor can i find an answer in the Help files. Just what does this option do? Thanks, Tonso |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation - Ignore Blank
On Mar 19, 11:13*am, Gord Dibben <gorddibbATshawDOTca wrote:
If the source list is a named range that contains blank cells, users may be able to type any entry, without receiving an error message. To prevent this: Select the cell that contains a data validation list Choose Data|Validation On the Settings tab, remove the check mark from the Ignore blank box. Click OK Note: If the source list contains blank cells, and is a range address, e.g. $A$1:$A$10, it will block invalid entries with Ignore blank on or off. Second.......................................... If your list is directly entered as a comma de-limited list you can add a blank entry by adding a comma <space i.e. *NA,dog,cat,fish,<space Gord Dibben *MS Excel MVP On Fri, 19 Mar 2010 05:18:00 -0700 (PDT), Tonso wrote: I have noticed the "Ignore blank" check box in my Data Validation window (XL2003), but i cannot figure out what it does. Nor can i find an answer in the Help files. Just what does this option do? Thanks, Tonso- Hide quoted text - - Show quoted text - Thanks! I am now clear on the function. Tonso |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ignore blank checkbox-Data Validation | Excel Discussion (Misc queries) | |||
Ignore Blank in Validation not working | Excel Worksheet Functions | |||
DATA Validation (Ignore Blanks) | Excel Discussion (Misc queries) | |||
What is the point of Data-Validation-Ignore Blank? | Excel Discussion (Misc queries) | |||
How do I set up a drop down validation to ignore any blank cells? | Excel Discussion (Misc queries) |