Data Validation.

Copper Contributor

Hi,

I want to make data validation in Column E for that I have made a dynamic named range.

 

The dynamic named range has been given in data validation pop-up menu Source.

As required it is appearing the pull down menu.. but still the cell is allowing to key in information.

 

I wish the user to use the pull-down menu only and should not allow to key in information manually.

How can this be done? Can anybody helpme to understand where I had gone wrong.

 

Regards & thanks in advance 

Sreekanth Pillai

1 Reply
Please ensure that Error Alert Style is Stop, as discussed here:
https://exceljet.net/excel-data-validation-guide