Data validation circumnevted by pick from drop-down list

U

ukedude

If I use data validation, I can restrict the entry of data in cells. This
works fine when using normal input techniques such as typing.

However, using the right-click context menu option "Pick from drop-down
list" allows me to choose any text value from the column I am in. Entry of
this data is not validated.

I can also circumvent validation by using Paste Special-->Values (thus
preserving the validation rule).

Is this a known bug or limitation?
 

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

How to make repeating drop-down lists? 2
Drop down list control value in vba 2
How can I give customized drop down in Ms Forms online or refer dropdown from excel list 0
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Data Validation List (conditional) 2
Drop down list from index/match formula 1
Combo box 0
get Data Validation to stop, list supplied, duplicate data entries 1

Top