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 ...

To apply data validation ... the type of validation you want from the Allow drop-down list. For example, you can select Whole Number to restrict the input to integers, or List to create a drop ...