Excel Data Validation allows you to do all these things in all versions of Microsoft Excel 2016, 20013, 2010 and lower.Excel Data Validation is a feature that restricts (validates) user input to a worksheet.For example, to restrict users to entering dates after today's date, enter the box, which will have the same effect.In situations when it's not possible to define a desired validation criteria based on a value or cell reference, you can express it using a formula.If the user types something different, Excel will show an error alert explaining what they have done wrong: To add data validation in Excel, perform the following steps.Select one or more cells to validate, go to the As soon as the user selects the validated cell, the following message will show up: In addition to the input message, you can show one of the following error alerts when invalid data is entered in a cell.
To enter a cell reference, either type it in the box preceded by an equal sign, or click the arrow next to the box, and then select the cell using the mouse.
Here's how: Now that you know the basics of data validation in Excel, let me share a few tips that can make your rules a whole lot more effective.
Instead of typing values directly in the criteria boxes, you can enter them in some cells, and then refer to those cells.
Technically, you create a validation rule that controls what kind of data can be entered into a certain cell.
Here are just a few examples of what Excel's data validation can do: For instance, you can set up a rule that limits data entry to 4-digit numbers between 10.
Search for validating spreadsheets:
Among other things, you may want to allow only particular data type such as numbers or dates in a cell, or limit numbers to a certain range and text to a given length.