Data validation is a feature, which is used to control what a user can enter in a cell of an excel sheet . We can create a customized message which will appear if the user inserts any incorrect value or an incorrect format
Data validation is used in Excel to make sure that users enter certain values into a cell.