Create Data Validation List with Case Sensitive

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.

create data validation list with case sensitive1

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

create data validation list with case sensitive2

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

create data validation list with case sensitive3

Comments

So empty here ... leave a comment!

Leave a Reply

Your email address will not be published. Required fields are marked *

Sidebar