Method of inserting radio control in excel table

When creating a questionnaire in EXCEL, radio buttons are often used. Maybe some friends don't know how to plug in the radio control. If you don't know, welcome to study and discuss together. The following is the method I shared to insert radio controls into excel tables for everyone to read and learn.

Method of inserting radio control into excel table:

Insert radio box step 1: Open the excel Options dialog box and check? Show it on a ribbon? Develop tools? Tab？ , click OK button, as shown in the figure below:

Insert radio box Step 2: After the first step is completed, you can see the tab of the development tool in the function area of excel, click Insert, and find the function menus such as radio box, check box and grouping box we need under this option, as shown in the following figure:

Insert radio box Step 3: Insert multiple groups of options, as shown in the figure below. At this time, we can find that only one option can be selected at a time among the 12 radio buttons. So how to select multiple radio buttons in the same excel table at the same time? We consider using grouping boxes for management.

Insert the radio box Step 4: Insert the grouping box, as shown in the figure below. At this time, each group can choose one option: