Data Validation in Excel

Under Data, select the Data Validation option.

In the pop-up window, you can limit the types of values that will be valid in a particular field. You can also define a list of options or values which will show up as drop-down options for cells in that field.

Visit Microsoft Office’s “Apply data validation to cells” article to learn more about data validation options.