Radio Button in Excel (Table of Contents)
Radio Button in Excel
Radio Button in excel, also known as Option Button in excel is available in the Developer menu tab in Insert option. The radio button can be used for Excel and VBA Macro both. Radio Button is used when we have multiple options to select and out of them selecting one option is allowed. This is quite used in while filling online forms when we have a list of options and only one can be selected carrying 100% weightage.
For radio buttons to work, it needs to be connected or linked with a cell in the worksheet, then only you be able to record the response.
Radio buttons do not allow you to select multiple selections. i.e. When there are multiple radio buttons in a group, then only one of the radio buttons in that group can be selected at a time.
How to Add Developer Tab containing Radio Button Option in Excel Ribbon?
If you don’t find develop tab in excel, you can enable or add the Developer tab by following below mentioned instructions:
You can enter right-click on any of the existing tabs in the ribbon, where options appear, in that select Customize the Ribbon.
It opens the Excel Options dialogue box, in that under the customize ribbon main tab option, select the developer tab. Click OK to apply changes.
Now developer tab appears as one of the tabs in the ribbon.
Apart from radio or option button, Various other interactive control tools can be seen in developer tab
How to Insert Radio Button or Option Button in Excel?
Radio Button in Excel is very simple and easy to create. Let”s understand the working of Radio Button in Excel by Some Examples.
Step 1: Addition of a Group Box through Form control option.
Group boxes are rectangular objects with optional labels, where you can update the title in it based on your choice. The main purpose of adding group box is to visually organize related items on a form and it is used to connect a set of Option Buttons to one another and enclose them in a Group Box control on the worksheet
Group Box can be added in the sheet by below-mentioned steps:
On the Excel Ribbon, Click on Developer tab and click Insert, drop-down list appears, In the Form Controls, select Group Box command, to activate that tool.
Click on the Excel worksheet where the + symbol appears & a group Box is created, with the default name of Group Box 1.
Drag over the Caption text in a group box to select it and type a new Caption of your choice for the Group Box name. Here I changed it to “Gender”. After formatting text and removal of grid lines, it appears as below mentioned.
You can change the Group Box size from square shape to rectangular shape based on your choice by dragging the corners in or out.
Step 2: Addition of a radio or option button.
Now, you can add the radio or option buttons inside the group box by below-mentioned steps:
In the excel developer tab, Click Insert. Form Controls section and active X control toolbox appear in the drop-down under insert option, in that form Controls section, select the Options Button command, to activate that tool.
Once you select Option Button command, your mouse cursor changes to a crosshatch, and Move the mouse on to the cell where you want the radio button to be inserted, you can apply Option Button anywhere in gender group box based on your choice and number of options you want to add in the gender group box.
You can now modify or update the text name for each radio buttons by right-clicking on the cell and by selecting “Edit Text” option from the context menu.
A Text is Edited as Gender.
Note: Entire Option Button and its Caption must be within the Group Box, so adjust the Group Box size according to it too.
Options button as a name itself suggests or indicates, to create more option or radio buttons in Excel so that we can choose one of the various options. that is why only one option button in excel is not enough. We can create more options button by using a ( Ctrl+d) key or using Copy-Paste ( Ctrl+C and Ctrl+V ) option.
Here I created two radio buttons under the gender section, i.e. Male & female.
Step 3: Link the option box to a cell.
The main feature of an Option Button in excel is that when we select one, others should get deselected automatically.
Now the question is, how can we get to know, which one is selected? and moreover, I should able to record the response or result of a selection made between two option.
For this to happen, we need to link the options buttons with a specific cell based on your choice, where sequence number of the option button or result of option in excel is displayed and we can use this number as response or result of selection.
To link Option Button with cell right click on male option button and go to Format Control.
In ‘Format Control’ Dialog box, under the ‘Control’ tab, write the address of the cell based on your choice, select the cell link and click on OK.
Here In the screenshot below, the male option Box is linked to cell “F4” in the same sheet.
Note: You can link to another cell of the different sheet also to record a response.
Now the value of the “F4” cell value gets changed to either 1 or 2, according to or based on the options button selection in excel.
You can observe in the below-mentioned screenshot when you click on one of the Options Box i.e. Female in the Group Box, the Options Box’s number will appear in the linked cell. i.e. 2 in the cell “F4”.
Similarly, if you select a male option, value of the “F4” cell changes to 1.
Like this, you can create multiple questions with the help of group box and Option Buttons.
Things to Remember About the Radio Button Option in Excel
- It is specified under the category of excel interactive controls.it is simple to use and does not require any expertise in Excel.
- Option or radio buttons are also used to Create Dynamic Chart.
- Option Buttons in excel helps out to easily create your own surveyor multiple-choice questionnaire.
This has been a guide to a Radio Button in Excel. Here we discuss its uses and how to use Radio Button in Excel with excel examples and downloadable excel templates. You may also look at these useful functions in Excel –