The use of controls in Excel2010 and the hidden combo box

Operation method

① first enter the question, and then click the menu Bar-development tool-insert--activex control-check box.

② Click the check box, draw a check box below the question, right-click, check box Object-Edit.

③ Modify the text in the check box, using the copy and paste method, complete the remaining options.

④ then click the menu Bar-development tool-insert-combo box.

⑤ combines the following four options into one whole and uses a combo box to delimit them.

⑥ sometimes in order to beautify the layout, you need to hide some of these components, we click the menu bar-start-Find and Replace-select the pane.

⑦ the right side of the selection and visibility pane, click on the component of the corresponding "eye" button can be hidden.

Classification:

• Excel Tutorials