Home  >  Article  >  Topics  >  How to set excel male and female gender selection

How to set excel male and female gender selection

藏色散人
藏色散人Original
2020-05-26 09:58:2535284browse

How to set excel male and female gender selection

How to set the gender selection for men and women in excel?

First select the cell where you want to fill in the gender

Recommend "Excel Tutorial"

How to set excel male and female gender selection

Select :Data--Data Verification--Data Verification

How to set excel male and female gender selection

The data verification dialog box pops up, select: Allow--Sequence

How to set excel male and female gender selection

Fill in "Source": male, female, and finally click OK

How to set excel male and female gender selection

Move the mouse to the cell where you want to fill in the gender, and a drop-down sign will appear

How to set excel male and female gender selection

Click the drop-down icon and you will see the male and female options

How to set excel male and female gender selection

Finally fill in all the options

How to set excel male and female gender selection

The above is the detailed content of How to set excel male and female gender selection. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn