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-
- Let’s start with creating the radio button in our worksheet. Simply, choose the “Radio Button” icon from the “Developer” feature to create it.
- Simply, select a cell and draw the button.
- While the button is selected press Ctrl+D to make multiple buttons.
- Thus position them and your multiple radio buttons are created. It’s time to group these buttons.
- First, go the the “Developer” option and press the “Group” icon.
- 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.
- 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.
- 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.
- 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.
- Similarly, we will link another cell (H13) with another group of radio buttons.
Finally, we will link those groups of options buttons with our dataset. To do that-
- 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-
- 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.
- 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?
- 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-
- 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!
- How to Set Option Button Value in Excel VBA (4 Easy Steps)
- Insert Excel VBA Radio Button Input Box (3 Easy Methods)
- How to Create Button to Link to Another Sheet in Excel (3 Ways)
- Change Color of Toggle Button When Pressed in Excel
- How to Create & Apply Option Button Click Event in Excel VBA
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-
- Above all, select “Radio or Option Button” from the “Activex Controls” list appearing from the “Developer” feature.
- 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.
- 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.
- Presently, choose a button and right-click the mouse button to get more options. From the options press “Edit”.
- Formerly, type according to your choice. Here I typed “January”.
- Similarly, we will edit all the button names on our worksheet.
- To group those, again click the right side of the mouse and press the “Properties” option.
- 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”.
- Finally, as you can see we have successfully grouped 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.
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.
- How to Make a Calculate Button in Excel (with Easy Steps)
- How to Use VBA Code for Submit Button in Excel (with Easy Steps)
- VBA Code for Save Button in Excel (4 Variants)
- How to Clear Cells in Excel with Button (with Detailed Steps)
- How to Hide Columns with Button in Excel (4 Suitable Methods)
- Print to PDF Using Macro Button in Excel (5 Macro Variants)