How do I set the Excel2010 data validation sequence?

Depending on the topic requirements, you need to set the value of the Drop-down list option for the B2:b15 area, as shown in the figure

Open the topic indicator file as shown in the picture

Select the "B2:b15" area, as shown in the figure

Open the top toolbar data, click Data validation, as shown in the figure

Click on "Data Validation", as shown in the picture

In the Setup interface, select "sequence" under "Allow (A)" Drop-down list, as shown in the figure

In the "Source (S)" In order to fill in the title of the choice of the value of the option, in English input method under the comma separated (special reminder: must be in English input bit to enter a comma), input complete Click Confirmation, as shown in the picture

Back to the table, you can see the effect! As shown in the picture

Attention matters

Be sure to enter a comma under the English input bit

Remember to save after the operation