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?

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

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

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

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!