How to create a drop-down menu in excel

Let me enter men and women as an example, open an Excel, we need to set a drop-down menu in the gender column, the content is "Male" and "Female"

Select the "Gender" cell behind the name

Open "Data" - "Validity" "

In the new dialog box, open the "Settings" tab, select "Sequence" in "Allow", and enter "Male" in "Source" ,Female", note here that the comma between "Male, Female" is an English comma. Then check "Ignore vacancies" and "Provide drop-down arrows". Click OK

After confirmation, you can see that under the "Gender" column, there is a "Male, Female" drop-down menu

Recommended Tutorial: excel tutorial

The above is the detailed content of How to create a drop-down menu in excel. For more information, please follow other related articles on the PHP Chinese website!