Chapter-8: Input Message in Data Validation

We can show a message while select an excel cell that which type of value is allowed to enter in this cell. Input Message feature of Data Validation is used to do so.

Below are the steps to apply Input Message in Data Validation:

  • Select the range.
  • Go to Data tab>>Data Validation>>Click on Data Validation.
Data Validation Option
Data Validation Option
  • Below given window will be opened.
  • Put the your data validation in Setting tab like in below image Whole Number Validation has been taken to enter the less than 100 only.
  • Click on Input Message Tab.
Setting Tab in Data Validation Window
Setting Tab in Data Validation Window
  • Tick the “Show input message when cell is selected“, however it is by default selected.
  • Put the Title of the input message.
  • Put the text of message in Input Message box.
Input Message Tab in Data Validation
Input Message Tab in Data Validation

Input message will look like below image.

Input Message in Data Validation
Input Message in Data Validation

Next ChapterPrevious Chapter