The values are presented to the user as a dropdown menu control. List – only values from a predefined list are allowed. For example, with the Decimal option configured to allow values between 0 and 3, values like. For example, you can require a whole number between 1 and 10.ĭecimal – works like the whole number option, but allows decimal values. Once we select the whole number option, other options become available to further limit input. Whole Number – only whole numbers are allowed. Even when we select Any Value, the message will still display when the cell is selected. Note: For when we previously applied the data validation with a set Input Message. When we create a data validation rule, there are eight available options to validate user input:Īny Value – the user does not perform any validation. Data validation is a feature in Excel that helps to control what a user can enter into a cell.
0 Comments
Leave a Reply. |