How to make drop-down box in excel

How to make a drop-down box in Excel?

In daily work, sometimes we encounter some data that will be entered repeatedly. In order to reduce the probability of repetition and errors, we can make it into a drop-down menu, so that every time it is used, just Just select the corresponding item, which is convenient and fast. Here we need the data verification function in the data, which is called data validity in older versions of EXCEL.

Now we have the following data, implementing a drop-down menu in the gender column.

1. Select cell E2 and open [Data Verification] in the [Data] menu

Data Verification

2. Open the data verification window and select "Sequence" in the allow drop-down menu

Set the sequence

3. In the source box Enter "male, female" in English and separate it with "," in English

4. Confirm to return to the data table. The arrow of the drop-down menu is displayed in cell E2. Click to select.

5. In addition to manual input, you can also select a data source in the source. Click the arrow button on the right to select the data source cell.

#If there is a lot of data, we can use the method of selecting the data source, which is faster. The above is a simple method to create a drop-down menu in EXCEL2016, which is simple and effective.

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