How to set up the drop-down box in excel

How to set the excel drop-down box: first click "Data" and "Data Validity" in the ribbon; then click to select "Sequence" under "Settings" and "Allow"; then click to select the data source Select the button; finally click the "OK" button in the settings dialog box.

The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

How to set the excel drop-down box:

1. For example, we complete the following form and enter the text to set the drop-down box option in the blank space "Male, female". Then select the area where you want to set the drop-down box options.

#2. Click "Data" - "Data Validity" in the ribbon.

#3. Click in the drop-down box of data validity and select "Settings" - "Sequence" under "Allow".

4. Then, behind "Source", click the button to select the data source.

5. As shown below, drag the mouse to select "Male, Female" and click the data source button above again to return to the settings dialog box.

#6. Click the "OK" button in the settings dialog box. When we click on the input area again, we can see the drop-down box options.

Related learning recommendations: excel tutorial

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