dimanche 19 avril 2015

Excel validation list allowing invalid inputs

I have a worksheet with several different validation lists using named ranges on a different sheet. I realized that the cells using the ranges with blanks in them still allow the user to type in whatever they want. If there's no blank in that defined range, then the normal Excel error message pops up. Anyone know why this happens?

Ex:enter image description here

Both types of validation lists are the default settings with "Ignore blank", "In-cell dropdown", and the Error Alert checked.

Some of my lists have spaces in between them but I would still like to restrict users to selecting only the choices provided by the dropdown.

Aucun commentaire:

Enregistrer un commentaire