How to Group Radio Buttons in Excel (2 Simple Methods)

While working in Microsoft Excel sometimes we need to group radio buttons to work more effectively. The radio button is also known as the options button which is a great tool to work with. Today in this article, I am going to share with you how to group radio buttons in excel.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


2 Quick Methods to Group Radio Buttons in Excel

In the following, I have shared 2 simple methods to group radio buttons in excel.

Suppose we have a dataset of a Company’s Sales of Air conditioners, Refrigerators, and Televisions month-wise.


1. Use Form Controls to Create and Group Radio Buttons in Excel

Using the form controls from the developer option we can easily create and group radio buttons. To do so-

Step 1:

  • Let’s start with creating the radio button in our worksheet. Simply, choose the “Radio Button” icon from the “Developer” feature to create it.

Use Form Controls to Create and Group Radio Buttons in Excel

  • Simply, select a cell and draw the button.

  • While the button is selected press Ctrl+D to make multiple buttons.

Use Form Controls to Create and Group Radio Buttons in Excel

  • Thus position them and your multiple radio buttons are created. It’s time to group these buttons.

Use Form Controls to Create and Group Radio Buttons in Excel

Step 2:

  • First, go the the “Developer” option and press the “Group” icon.

Use Form Controls to Create and Group Radio Buttons in Excel

  • Hence, draw a border outside the buttons to group them.

  • Thereafter, select a button and right-click the mouse button to get options from the options press “Edit Text” to edit the words.

  • According to the dataset, I have typed “Jan” as the first button.

Use Form Controls to Create and Group Radio Buttons in Excel

  • Similarly, I have named all the buttons in the same group.

  • In the same fashion, I have created a group of radio buttons just beside the previous one.

Use Form Controls to Create and Group Radio Buttons in Excel

Step 3:

  • In this step, we will create a corresponding cell for each group of radio buttons.
  • Gently, select a button and click the “Format Control” option by getting options by clicking the right side button of the mouse.

Use Form Controls to Create and Group Radio Buttons in Excel

  • From the new window, choose a cell to link with the button and hit OK to continue.

  • As you can see, we have successfully linked a cell (F13) with the grouped radio button. To check-

  • Choose another button and it will show the number “3” as the radio button is in the 3rd position.

Use Form Controls to Create and Group Radio Buttons in Excel

  • Similarly, we will link another cell (H13) with another group of radio buttons.

Use Form Controls to Create and Group Radio Buttons in Excel

Finally, we will link those groups of options buttons with our dataset. To do that-

Step 4:

  • Select a cell (B13) where we will collect the month’s name when we press the radio button from the group.
  • Apply the following formula-
=INDEX($B$5:$B$10,$F$13)

Where,

  • The INDEX function returns a value or reference from the given table in the string. Here, ($B$5:$B$10) is the array and the row number is ($F$13) which will provide a month name according to the cell reference value.

Use Form Controls to Create and Group Radio Buttons in Excel

  • Likewise, press Enter and you will get the month name. To check whether the formula is working properly or not-

  • Click any radio button of your choice and see the changes. Simple isn’t it?

Use Form Controls to Create and Group Radio Buttons in Excel

  • Now, we will collect the sales value from the dataset by pressing the radio button from another group. For that,
  • Select a cell (C13) and write the following formula down-
=INDEX($C$5:$E$10,ROWS($C$4:E4),$H$13)

Use Form Controls to Create and Group Radio Buttons in Excel

  • Hit Enter to get the desired output.

  • In conclusion, you can see from the following screenshot we have successfully grouped the radio button and used it to gather information from the dataset. Enjoy!

Use Form Controls to Create and Group Radio Buttons in Excel


2. Utilize Activex Controls to Group Radio Buttons in Excel

If you are looking for a simple solution to group radio buttons in excel then you are at the right place. Follow the steps below-

Step 1:

  • Above all, select “Radio or Option Button” from the “Activex Controls” list appearing from the “Developer” feature.

Utilize Activex Controls to Group Radio Buttons in Excel

  • Just like the previous method, draw the button in any position on the worksheet.
  • Hence, selecting the button press Ctrl+D to create multiple buttons.

Utilize Activex Controls to Group Radio Buttons in Excel

  • Here I have placed them under the “Month” roof to group those buttons.

  • In the same fashion, I have created some more buttons under the “Sales of Products” roof. Now it’s time to edit and group those radio buttons.

Utilize Activex Controls to Group Radio Buttons in Excel

Step 2:

  • Presently, choose a button and right-click the mouse button to get more options. From the options press “Edit”.

Utilize Activex Controls to Group Radio Buttons in Excel

  • Formerly, type according to your choice. Here I typed “January”.

  • Similarly, we will edit all the button names on our worksheet.

Utilize Activex Controls to Group Radio Buttons in Excel

  • To group those, again click the right side of the mouse and press the “Properties” option.

Utilize Activex Controls to Group Radio Buttons in Excel

  • Underneath, provide a group name. Here I have provided “A” as the group name.
  • Similarly, for all the month’s buttons change the group name to “A” to group the month’s button into the same group.

  • Likewise, we will group the other buttons by opening the “Properties” option.

  • Here, we will name the other buttons group name to “B”.

Utilize Activex Controls to Group Radio Buttons in Excel

  • Finally, as you can see we have successfully grouped radio buttons in excel.

How to Group Radio Buttons in Excel


Things to Remember

  • If you are not getting the “Developer” option at the top ribbon, just go to File > Options > Customized Ribbon. Hence, checkmark the “Developer” option to get it.

Conclusion

In this article, I have tried to cover all the methods to group buttons in excel. Take a tour of the practice workbook and download the file to practice by yourself. I hope you find it helpful. Please inform us in the comment section about your experience. We, the Exceldemy team, are always responsive to your queries. Stay tuned and keep learning.

Wasim Akram

Wasim Akram

Hi! my name is Wasim Akram. I am a graduate in mechanical engineering from Ahsanullah University of Science & Technology. I am passionate about learning new things and writing articles. I write article about Microsoft Excel and it's my favourite thing to do.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo