Question: how to make a data validation rule on excel?
Answer: Select one or more cells to validate. On the Data tab, in the Data Tools group, click Data Validation. On the Settings tab, in the Allow box, select List. In the Source box, type your list values, separated by commas. ...  Make sure that the In-cell dropdown check box is selected.