Follow the steps below to create a drop-down list using data validation in Excel. If you want to add a message pop up, you can click the Input Message tab and check the checkbox for “Show input ...

Validation applies rules to input data. If the data does not follow the rules it is rejected, reducing the risk that incorrectly input data may crash a program. A programmer can build various types of ...