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!