Skip to main content

How to group multiple option / radio buttons in Excel?

When you insert multiple radio buttons in your worksheet, and you just can select only one of them in a worksheet. That’s because radio buttons are not designed to allow multiple selections. But if you want to insert multiple sets of option buttons and need to check one button from each group as following screenshots shown. How could you do in Excel?

Form Controls of group radio buttons ActiveX Controls of group radio buttons
doc-insert-group-radio-buttons1 doc-insert-group-radio-buttons2

Insert multiple sets of option buttons with Group Box (Form Controls)

Insert multiple sets of option buttons with naming new group name (ActiveX Controls)

Insert multiple option buttons in a range of cells with Kutools for Excel


If you want to insert some Form Controls radio buttons and group them, you can draw some Group Boxes first and then insert the radio buttons into them. You can deal with it as following steps:

1. Go to the Developer tab, and click Group Box under Insert, see screenshot:

doc-insert-group-radio-buttons1

2. Then drag and draw some group boxes as you need, see screenshot:

doc-insert-group-radio-buttons1

3. And then you can replace the group box name by selecting it and typing a new name.

doc-insert-group-radio-buttons1

4. Then you can insert the option buttons into the group boxes, please click Developer > Insert > Option Button(Form Control) and draw some radio buttons into the group boxes, see screenshots:

doc-insert-group-radio-buttons6 -2 doc-insert-group-radio-buttons6

5. After inserting the option buttons into the group boxes, you can change the name of the option buttons, right click one option button and choose Edit Text from the context menu, then enter your own option name as you need. Repeat this step to change all of the option buttons manually. See screenshots:

doc-insert-group-radio-buttons8 -2 doc-insert-group-radio-buttons9

And all your option buttons in one group box are treated as a group, and the option buttons can be selected from each group.



Except the Form Controls radio buttons, there is another type of radio button in Excel, it is ActiveX Controls radio button, and you can group this type radio button as following tutorial:

1. Insert the ActiveX Controls option buttons by clicking Developer > Insert > Option Button (ActiveX Control), see screenshot:

doc-insert-group-radio-buttons9

2. And then drag and draw the option button one by one as you need.

doc-insert-group-radio-buttons9

3. Then you can change the option button name by right clicking it, and choose OptionButton Object > Edit, type the option name as you need. Repeating this step to change the option button names one by one, see screenshots:

doc-insert-group-radio-buttons8 -2 doc-insert-group-radio-buttons9

4. After renaming the option button, you need to give a group name for the group radio buttons. Select your first radio button of your first group, and right click it, then click Properties from the context menu.

doc-insert-group-radio-buttons9

5. In the Properties dialog, specify a name for the GroupName property under the Alphabetic tab, and then close the dialog.

doc-insert-group-radio-buttons9

6. Now, select the second button from the first group, and then enter the same name for GroupName that you used in the first button. And then, repeat this operation for all the left buttons in the first group.

7. Then you can apply the same operation to give a name for the second group of all radio buttons, but you must enter a different name for distinguishing with the first group name.

8. Then exit the Design Mode by clicking Developer > Design Mode, and now your radio buttons have been grouped as following screenshot shown:

doc-insert-group-radio-buttons9


If you want to insert multiple radio buttons in a range of cells in a minute, Kutools for Excel’s Batch Insert Option Buttons feature may help you to deal with this task.

Kutools for Excel : with more than 300 handy Excel add-ins, free to try with no limitation in 30 days

If you have installed Kutools for Excel, please do as follows:

1. Select the range of cells where you want to insert option buttons.

doc-insert-group-radio-buttons9

2. Then click kutools > Insert > Batch Insert Option Buttons, see screenshot:

doc-insert-group-radio-buttons9

3. And then the selected cells have been filled with the option buttons, see screenshot:

doc-insert-group-radio-buttons9

Note: You can also insert the radio buttons before the values within the same cells as following screenshot shown:

doc-insert-group-radio-buttons9

Click to know more about this Batch Insert Option Buttons utility.

Download and free trial Kutools for Excel Now !


Related articles:

How to insert a radio button or option button in Excel?

How to quickly insert multiple checkboxes in Excel?

Best Office Productivity Tools

🤖 Kutools AI Aide: Revolutionize data analysis based on: Intelligent Execution   |  Generate Code  |  Create Custom Formulas  |  Analyze Data and Generate Charts  |  Invoke Kutools Functions
Popular Features: Find, Highlight or Identify Duplicates   |  Delete Blank Rows   |  Combine Columns or Cells without Losing Data   |   Round without Formula ...
Super Lookup: Multiple Criteria VLookup    Multiple Value VLookup  |   VLookup Across Multiple Sheets   |   Fuzzy Lookup ....
Advanced Drop-down List: Quickly Create Drop Down List   |  Dependent Drop Down List   |  Multi-select Drop Down List ....
Column Manager: Add a Specific Number of Columns  |  Move Columns  |  Toggle Visibility Status of Hidden Columns  |  Compare Ranges & Columns ...
Featured Features: Grid Focus   |  Design View   |   Big Formula Bar    Workbook & Sheet Manager   |  Resource Library (Auto Text)   |  Date Picker   |  Combine Worksheets   |  Encrypt/Decrypt Cells    Send Emails by List   |  Super Filter   |   Special Filter (filter bold/italic/strikethrough...) ...
Top 15 Toolsets12 Text Tools (Add Text, Remove Characters, ...)   |   50+ Chart Types (Gantt Chart, ...)   |   40+ Practical Formulas (Calculate age based on birthday, ...)   |   19 Insertion Tools (Insert QR Code, Insert Picture from Path, ...)   |   12 Conversion Tools (Numbers to Words, Currency Conversion, ...)   |   7 Merge & Split Tools (Advanced Combine Rows, Split Cells, ...)   |   ... and more

Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time.  Click Here to Get The Feature You Need The Most...

Description


Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
Comments (10)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
This is really helpful. Thanks for posting this.
This comment was minimized by the moderator on the site
Thank you, so useful explenation
This comment was minimized by the moderator on the site
Super explanation on grouping ActiveX controls. However, what is missing is how to assign code to those grouped option buttons. I have 5 ActiveX radio button inside a Microsoft Frame, and I've Googled till I'm Green as the Grinch and cannot figure out how to assign code to each of those ActiveX buttons.

Any help much appreciate - code or link.
Happy Holidays!
This comment was minimized by the moderator on the site
how do you output the check box
options in one cell as combined text?
This comment was minimized by the moderator on the site
Is it possible to remove the group box line so it doesn't show on the form?
This comment was minimized by the moderator on the site
Hello, Shawn,
If you want to hide or remove the group box, the following article may do you a favor, please view it.
https://www.extendoffice.com/documents/excel/3622-excel-remove-border-from-group-box.html

Hope it can help you, thank you!
This comment was minimized by the moderator on the site
Really helpful - so obvious when it's pointed out: way better than the MS website :)
This comment was minimized by the moderator on the site
If you do a questionnaire with Option Buttons it gets all jittery and shaky when you scroll through the sheet. Picking the option to "Don't move or resize..." is useless. Any suggestions?
This comment was minimized by the moderator on the site
Hi, I was struggling with categorizing the toggle buttons and your page helped me figure out the "Grouping". Thank you!!
This comment was minimized by the moderator on the site
This great, just what i was looking for. Thanks!
There are no comments posted here yet
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations