China Naming Network - Ziwei Dou Shu - How does Excel set the drop-down option exc set the drop-down option?

How does Excel set the drop-down option exc set the drop-down option?

Excel set the drop-down option method is actually very simple:

Demonstration version of excel20 19

1. First open the excel table, select the table that needs to set the drop-down option, and then select the data, as shown in the following figure:

2. Then select the drop-down list as shown in the figure below:

3. Then enter options in the input box, click+and enter other options as shown in the figure below:

4. Finally, click OK, as shown in the following figure:

5, set up successfully as shown in the figure below: