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?


Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%

  • Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
  • Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
  • Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
  • Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
  • Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
  • Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
  • Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
  • Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
  • More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial.
kte tab 201905

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!
officetab bottom
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 · 1 years 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 · 1 years 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 · 2 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 · 2 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?
  • To post as a guest, your comment is unpublished.
    Ramya · 3 years ago
    Hi,
    I was struggling with categorizing the toggle buttons and your page helped me figure out the "Grouping". Thank you!!
  • To post as a guest, your comment is unpublished.
    JamesS · 4 years ago
    This great, just what i was looking for. Thanks!