Drop down list in excel

Create a drop down list in excel

Create a list of month (January to December)

Go to data tab

Go to data validation

Select data validation option

Select list option

Select the source of month list

The drop down list is created