Note: This article is for reference only.
1. Insert the office control and select. leave it blank.
Office Excel version: Office 2013
Solution: to implement this function, open the "development tool" in Excel"
650) This. width = 650; "src =" http://s3.51cto.com/wyfs02/M01/4C/D4/wKiom1RF_Q6TnH-wAAbc57Wq64w239.jpg "Title =" 1.jpg" alt = "wKiom1RF_Q6TnH-wAAbc57Wq64w239.jpg"/>
Open Method: Select "file", "option", "Custom functional area", and select "development tools.
650) This. width = 650; "src =" http://s3.51cto.com/wyfs02/M02/4C/D5/wKioL1RF_W_jLmYmAAGHEs_e_RA893.jpg "Title =" 2.jpg" alt = "wkiol1rf_w_jlmymaaghes_e_ra893.jpg"/>
2. How to set a drop-down menu in Excel
Switch the Excel functional area to "data", "data verification", and "Verification condition" to allow "sequence". When "Source" is selected, you can select the options required by the list in the blank space, such as 1, 2, and 3 (in three tables respectively). select these tables as the source.
This article from the "Flying Pig" blog, please be sure to keep this source http://thinkpig007.blog.51cto.com/971471/1566282
Summary of common office software usage functions