This post will guide you how to create a data validation list with case sensitive in Excel. How do I make a data validation list case-sensitive in excel. When you create a data validation in your current worksheet, it is case-insensitive by default.
Create Data Validation List with Case Sensitive
If you want to create a data validation list with case sensitive in excel, you just need to do the following steps:
#1 select a cell and go to DATA tab, click Data Validation command under Data Tools group. The Data Validation dialog will appear.
#2 select List value from the Allow drop down list. And type the values separated by comma character as the choices of data validation list.
#3 click OK button.
#4 when you try to type a value that does not match case-sensitive, you will see a warning dialog will popup.