Home>Article>Topics> How to make drop-down menu in excel table

How to make drop-down menu in excel table

王林
王林 Original
2020-06-13 09:55:04 7737browse

How to make drop-down menu in excel table

The specific method is as follows:

Now we have the following form. If we want to set a drop-down menu for gender, what should we do?

How to make drop-down menu in excel table

1. Select the first cell under gender, click the [Data] tab, and then click the [Data Validation] option under the [Data Validation] button

How to make drop-down menu in excel table

2. Set the validity conditions in the data validity window, check [Provide drop-down arrows], and select male or female as the source

How to make drop-down menu in excel table

3. Back to the excel sheet, we can see that there is a drop-down menu under the gender option.

How to make drop-down menu in excel table

Recommended tutorial:excel tutorial

The above is the detailed content of How to make drop-down menu in excel table. 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