Data Validation

G

Guest

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?
 
G

Guest

are you opening the cell and then moving.
the blank cell will be accepted until the cell is activiated.
 
G

Guest

Can you clarify what you mean by activated?

bj said:
are you opening the cell and then moving.
the blank cell will be accepted until the cell is activiated.
Click to expand...
 
D

Debra Dalgleish

No matter what data validation settings you've applied, users will be
able to leave the cell blank, or select the cell, and press the Delete
key, to clear the cell.

However, if the cursor is in the cell, or in the formula bar, they won't
be able to press the Delete key, to clear the cell, or press the Enter
key while the cell is blank.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Validation of blank cells 3
Remove blank cells from data validation drop down box 3
Data Validation drop-down width, with named range source (XL03 and 4
Data Validation With VLOOKUP & Names 3
Data Validation and Name Range 2
How do I require data entry in a cell before moving to the next ce 3
custom data validation on cells with data validation values 2
a data validation list that contains a list of named ranges - not alist from a named range 1

Top