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.

Creating a case-sensitive data validation list in Excel is useful in a variety of situations where you need to distinguish between upper and lower case letters.

1. 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.

2. Video: Create Data Validation List with Case Sensitive

In tutorial video, we will provide an example using Data Validation feature to implement a case-sensitive data validation list in Excel 2013/2016/2019/365.

3. SAMPLE FIlES

Below are sample files in Microsoft Excel that you can download for reference if you wish.