excel2013 How to insert a form-radio box control

Source: Internet
Author: User

excel2013 Insert form a radio box control tutorial:

Insert form a Radio box control Step 1: Because the Radio box buttons generally appear in groups, we first add a "group box" to put together a number of single marquee, and linkage. In the following diagram, modify the name of the group box "student weekday performance evaluation".

Insert form a radio box control Step 2: As shown in the following illustration, insert a single selection box and modify the name.

Insert form a radio box control step 3: Insert two more radio boxes as above and rename them, as shown in the following figure:

Insert form a radio box control Step 4: Select a radio box, click the right mouse button, and select Format Control.

Insert form Radio Box control Step 5: Select cell link under the Control tab and select a cell (such as A1 cell) to store the options and press OK, as shown in the following figure:

Insert form a radio box control step 6: So, we select a different radio box, A1 cells reflect the selection of the different buttons represented by the value. This can be used in questionnaires and other record options and statistics, scoring situation.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.