How to set up Excel drop-down menu

This chapter explains the specific steps for creating a table drop-down menu in Excel. If you are interested, please go to the following section to learn more.

Recommended tutorial: excel graphic tutorial

I will enter men and women as an example, open an Excel, we want to Set a drop-down menu in the gender column with the content "Male" and "Female";

Select the "Gender" cell facing the name;

Open "Data" - "Validity" in sequence;

In the new dialog box, open "Settings" tab, select "Sequence" in "Allow", enter "Male, Female" in "Source", note here that the commas between "Male, Female" are English commas. Then check "Ignore vacancies" and "Provide" Drop-down arrow". Click OK;

After confirmation, you can see that under the "Gender" column, the "Male, Female" drop-down appears. menu;

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