Excel Data Validation

Excel Data Validation

 
The Excel Data Validation feature allows to set up rules that determine what can be entered into a cell. A custom message can also be displayed when the entered value doesn't satisfy the set conditions.

Evaluation of Formula
The example below limits the data entry in cell E4 to whole numbers between 1 and 100. If the user makes an invalid entry, a custom message, such as the one shown below will pop-up.
 
Stacks Image 98
 
Setting-up the Data Validation
Select the cell or cells that you want to limit the data entry then access the data validation feature via Data > Data Validation. A small window will come out to set the rules and customized message can be defined when the entered data is invalid.
 
Excel Data Validation Function 2
 
Excel Data Validation Function 3
Excel Data Validation Function 4
 
 
Show Comments
 

About Us

Excelcrib was founded in November 2017 by Garry, a Microsoft® Office Excel® (MS Excel) enthusiast with background in engineering. He's been using MS Excel for more than 15 years in practice with specialty in VBA.

© Copyright 2021 Excelcrib | Privacy Policy

We use cookies to improve your browsing experience.
Continuing to use this site means you agree to our use of cookies.
Tell me more!