Drop Down/Manual Entry

[hbendillo]

I have created drop down list using the Data/Validation feature throughout my spreadsheet. When I try to input data manually into one of the cells, even if it is one of the valid data values, I get the "Invalid Data" Message. Can't this be fixed?

 

[nancyo]

Can only enter data by selecting one of the items in the drop down list - when the cell is selected, the arrow appears in the right part of the cell. From here, select your choice.

 

[inarbeth]

nancyo, not sure that is right - you can input valid data manually. hbendillo, are you using the same case, upper or lower?

 

[MT_Shanachie]

On 2002-05-02 13:00, hbendillo wrote:
I have created drop down list using the Data/Validation feature throughout my spreadsheet. When I try to input data manually into one of the cells, even if it is one of the valid data values, I get the "Invalid Data" Message. Can't this be fixed?

I'm not sure if you're validating numbers or text. One thing I've noticed with data validation of text is that, if you list the valid items in the Source box in the data validation window, the valid entries are case sensitive. If you use a cell or range reference in the box, the valid entries are not case sensitive.

 

[excelqueen]

can we create a custom drop down list in cell?