| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Data Validation
I am trying to use a Drop Down list for data validation and do not want a
blank cell to be accepted. I have unchecked to Ignore Blank Box, but there is no warning message. I have typed the list at the botton of my worksheet and used the cell range as the Source. There are no blank cells in the range. Does anyone know why Excel continues to allow a blank cell to be used? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data validation screen size | Excel Discussion (Misc queries) | |||
| data validation lists | Excel Discussion (Misc queries) | |||
| named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
| Using Validation List from Another Workbook with Dependent Data | Excel Worksheet Functions | |||
Threaded Mode
