This post will guide you how to group multiple option or radio buttons in your worksheet in Excel. How do I make independent groups of option buttons in Excel. How to set multiple groups of radio buttons in Excel.

• Using Group Box to Group Option Buttons
• Defining Group Name to Group Option Buttons
• Video: Group Option buttons

Using Group Box to Group Option Buttons

---

If you need to insert radio buttons from Form Controls into your worksheet, and then group them to different group. You need to do the following steps:

#1 go to DEVELOPER tab, click Insert command under Controls group. And then click Group Box button from the drop down menu list.

#2 drag your mouse to draw one or more group boxes.

#3 go to DEVELOPER tab, click Insert command under Controls group. And click Option Button (Form Control) button from the drop down menu list.

#4 drag your mouse to draw one radio button into the group boxes. Repeat step 3-4 to create multiple radio buttons as you need into the group boxes.

Defining Group Name to Group Option Buttons

---

If you create options buttons from ActiveX Controls pane, you can do the following steps to group multiple option buttons.

#1 go to DEVELOPER tab, click Insert command under Controls group, and click Option button (ActiveX Control) button from the ActiveX Controls pane.

#2 drag your mouse and draw the option button.

#3 repeat step 1-2 to create multiple option buttons as you need.

#4 select the first option button, and right click on it, and select Properties from the popup menu list. And the Properties dialog will open.

#5 you need to find the GroupName property in the Properties dialog, and type a group name in the text box. And then close the Properties dialog.

#6 repeat step4-5 for other option buttons to set group name. If you want to group the selected option button as the same group, just set the same group name in GroupName property.

#7 go to DEVELOPER tab, click Design Mode command to turn off the Design mode.

Video: Group Option buttons