Next, in the Allow field of the Data Validation dialog box, select "List." Finally, activate the "Source" field, and select the cells containing the values that you want to appear in the drop-down ...