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!