You can use data validation in Excel to restrict the type of data that users can enter into a cell. For example, you can use data validation to make sure a value is a number between 1 and 10, or that a date occurs in the future. When you set up data validation, you can also specify an input message that will appear when a user selects the cell. The input message can explain what type of data is allowed in the cell, and it can also include a default value.
To set an input message for data validation in Excel:
----- OR -----
Note:: To specify that only certain values are allowed (for example, whole numbers between 1 and 10), under Allow, click Whole number or Decimal, and then enter the minimum and maximum values that you want to allow.