Validate only uppercase in data validation

In this article, we will learn how to validate only uppercase text entries in Excel 2016. Problem: Here we have a task where only uppercase ...

Prevent Duplicate Entries in a Range with Excel Data Validation

In this article, we will learn how to prevent duplicate entries in a range with Data Validation. We will learn how helpful and useful this feature is...

How to Create Dynamic Drop Down List in Excel Using 4 Different Methods

In this article, we will learn how to create dynamic drop down list in Microsoft Excel. As we know Data Validation feature improves the efficiency of...

How to create Drop Down list with Data Validation in Excel

In this article, we will learn how to create drop down list using data validation in Microsoft Excel. Data Validation feature improves the efficiency...

How to Create Dependent (Cascading) Drop Down List in Excel Using 5 Different Techniques

So far in this Data Validation series, we have learnt to create normal drop down list and dynamic drop down list using different techniques with data ...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.