Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

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


Insert multiple option buttons in multiple selections:

With Kutools for Excel’s Batch Insert Option Buttons feature, you can quickly insert multiple radio buttons into multiple selected cells.

doc-insert-group-radio-buttons20

Kutools for Excel: with more than 200 handy Excel add-ins, free to try with no limitation in 60 days. Download and free trial Now!



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.


Kutools for Excel: with more than 200 handy Excel add-ins, free to try with no limitation in 60 days. Download and free trial Now!


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 60 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?


Excel Productivity Tools

Ribbon of Excel (with Kutools for Excel installed)

300+ Advanced Features Increase Your Productivity by 70%, and Help You To Stand Out From Crowd!

Would you like to complete your daily work quickly and perfectly? Kutools For Excel brings 300+ cool and powerful advanced features (Combine workbooks, sum by color, split cell contents, convert date, and so on...) for 1500+ work scenarios, helps you solve 80% Excel problems.

  • Deal with all complicated tasks in seconds, help to enhance your work ability, get success from the fierce competition, and never worry about being fired.
  • Save a lot of work time, leave much time for you to love and care the family and enjoy a comfortable life now.
  • Reduce thousands of keyboard and mouse clicks every day, relieve your tired eyes and hands, and give you a healthy body.
  • Become an Excel expert in 3 minutes, and get admiring glance from your colleagues or friends.
  • No longer need to remember any painful formulas and VBA codes, have a relaxing and pleasant mind, give you a thrill you've never had before.
  • Spend only $39, but worth than $4000 training of others. Being used by 110,000 elites and 300+ well-known companies.
  • 60-day unlimited free trial. 60-day money back guarantee. Free upgrade and support for 2 years. Buy once, use forever.
  • Change the way you work now, and give you a better life immediately!

Office Tab Brings Efficient And Handy Tabs to Office (include Excel), Just Like Chrome, Firefox, And New IE

  • Increases your productivity by 50% when viewing and editing multiple documents.
  • Reduce hundreds of mouse clicks for you every day, say goodbye to mouse hand.
  • Open and create documents in new tabs of same window, rather than in new windows.
  • Help you work faster and easily stand out from the crowd! One second to switch between dozens of open documents!
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Mort · 5 months ago
    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!
  • To post as a guest, your comment is unpublished.
    davey · 8 months ago
    how do you output the check box
    options in one cell as combined text?
  • To post as a guest, your comment is unpublished.
    Shawn · 1 years ago
    Is it possible to remove the group box line so it doesn't show on the form?
  • To post as a guest, your comment is unpublished.
    John · 1 years ago
    Really helpful - so obvious when it's pointed out: way better than the MS website :)
  • To post as a guest, your comment is unpublished.
    BD · 2 years ago
    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?