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: