how to add validation in excel sheet

data validation excel

Data Validation in Excel: How to use it,8 awesome uses of excel data validation

Data Validation in Excel

Data validation in excel is a very useful tool. Its main functionality is to create constraints while data entry in excel. For example, we could put a constraint that no duplicate value should enter in a cell or column or the value entered in a cell should be between 5 to 25. It also reflects a message about the condition required to enter the data in that cell, when we put a wrong entry.

How to add data validation in excel sheet

To apply data validation in excel first we will go to Data Data Validation Data Validation. After that we will click on Data Validation then we will get an input box as illustrated … Continue Reading

dependent data validation list excel

How to create multiple level dropdown list in excel

How to create multiple level dropdown list in excel

Data validation in excel is one of the useful methods to put validation in cells of excel. In this article, we will learn how to create multiple level dropdown list. Multiple level dropdown list also known as dynamic data validation or multiple level data validations. It helps in putting validation in the second cell based on the selection of the first cell. By using this if we select a particular value in the first cell then the second cell will reflect values related to the first cell.

Let us start with an example of how to create multiple dependent drop down list in excel. We have a data set with two … Continue Reading