• Skip to primary navigation
  • Skip to content
  • Skip to primary sidebar
  • Skip to footer
EDUCBA

EDUCBA

MENUMENU
  • Resources
        • Excel Charts

          • Histogram Chart Excel
          • Basic Excel Formulas
          • Text to Columns in Excel
        • Excel Charts
        • Excel Tips

          • Excel Gantt Chart
          • IFERROR with VLOOKUP
          • Data Table in Excel
        • Excel Tips
        • Excel Tools in Excel

          • Stacked Column Chart
          • Cheat Sheet of Excel Formulas
          • Excel Data Validation
        • Histogram chart in excel
        • Others

          • Resources (A-Z)
          • Excel Functions
          • Financial Functions in Excel
          • Logical Functions in Excel
          • Lookup Reference Functions in Excel
          • Maths Function in Excel
          • TEXT and String Functions in Excel
          • View All
  • Free Courses
  • All Courses
        • Certification Courses

          Excel Course 1
        • All in One Bundle

          All-in-One-Excel-VBA-Bundle
        • Excel course

          Excel-Training
        • Others

          • Excel advanced course
          • VBA Course
          • Excel Data Analysis Course
          • Excel for Marketing Course
          • Excel for Finance Course
          • View All
  • 120+ Courses All in One Bundle
  • Login

Excel Radio Button

Home » Excel » Blog » Excel Tools » Excel Radio Button

Radio Button in Excel

Radio Button in Excel (Table of Contents)

  • Radio Button in Excel
  • How to Add Radio Button in Excel Ribbon?
  • How to insert Radio Button in Excel?

Radio Button in Excel

Radio Button is also called the “Option Button”.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

  • It allows users to select or toggle through multiple options in excel dashboard or report one at a time.
  • Radio button or Options button is used to select or choose the predefined and specific option from the multiple options.

Definition

It is a Windows control containing some text, it is a small round shaped button caption before or after the text value. After selection of a radio button, it gets a black dot in it (where it indicates, that it is marked) and it is linked with a cell in the worksheet.

Radio Button

Radio Button 1

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.

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.

Popular Course in this category
Cyber Week Sale
Excel Advanced Training (14 Courses, 21+ Projects) 14 Online Courses | 21 Hands-on Projects | 129+ Hours | Verifiable Certificate of Completion | Lifetime Access
4.8 (2,665 ratings)
Course Price

View Course

Related Courses
Excel Training (18 Courses, 9+ Projects)

Customize the Ribbon tab

Now developer tab appears as one of the tabs in the ribbon.

Developer tab

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.

You can download this Radio Button Excel Template here – Radio Button Excel Template

Options button in Excel Example #1

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.

Group Box

Click on the Excel worksheet where the + symbol appears & a group Box is created, with the default name of Group Box 1.

Radio Button Example 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.

Radio Button Example 1-1

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.

Radio Button Example 1-2

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.

Radio Button Example 1-3

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.

Radio Button Example 1-4

A Text is Edited as Gender.

Radio Button Example 1-5

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.

Radio Button Example 1-6

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.

Radio Button Example 1-7

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.

Radio Button Example 1-8

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”.

Radio Button Example 1-9

Similarly, if you select a male option, value of the “F4” cell changes to 1.

Radio Button Example 1-10

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.

Recommended Articles

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 –

  1. CEILING Function in MS Excel
  2. How to Use TANH Function in Excel?
  3. Use of RATE Function in Excel
  4. Guide to Excel Month Function

All in One Excel VBA Bundle (120+ Courses, 30+ Projects)

120+ Online Courses

30+ Projects

500+ Hours

Verifiable Certificates

Lifetime Access

Learn More

4 Shares
Share
Tweet
Share
Reader Interactions
Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar
Excel Functions Tutorials
  • Excel Tools
    • Power Query in Excel
    • Power View in Excel
    • XML in Excel
    • Excel Evaluate Formula
    • Examples of Excel Macros
    • Consolidation in Excel
    • Ribbon in Excel
    • Excel Conditional Formatting for Dates
    • Protect Sheet in Excel
    • Data Model in Excel
    • Pivot Table Examples
    • Pivot Table Slicer
    • Pivot Table Filter
    • Watch Window in Excel
    • Slicer in Excel
    • Print Gridlines in Excel
    • Convert Numbers to Text in Excel
    • Freeze Columns in Excel
    • Spelling Check in Excel
    • Name Box in Excel
    • Solve Equation in Excel
    • Excel Spreadsheet Examples
    • What If Analysis in Excel
    • How to Print Labels From Excel
    • Excel Named Range
    • Excel TRANSPOSE Formula
    • Excel Merge and Center
    • Excel Freeze Rows
    • HLOOKUP Formula in Excel
    • Excel Create Database
    • Excel Gridlines
    • Excel Spreadsheet Formulas
    • Excel Sort By Number
    • Excel Concatenating Columns
    • Excel AutoCorrect
    • Conditional Formatting For Blank Cells
    • Excel Icon Sets
    • Excel CTRL D
    • Excel Accounting Number Format
    • Excel Regression Analysis
    • Excel Import Data
    • Excel Freeze Panes
    • Excel Calendar
    • Excel Developer Tab
    • Excel Enable Macros
    • Excel Autosave
    • Heat Map in Excel
    • Excel Toolbar
    • Excel Error Bar
    • Excel Status Bar
    • Excel Unprotect Sheet
    • Check mark in Excel
    • Excel Column Filter
    • Excel Header and Footer
    • Excel Drawing
    • Range in Excel
    • Timeline in Excel
    • Excel Lock Formula
    • Excel Table styles
    • Insert New Worksheet in Excel
    • Excel Column Lock
    • Excel Forms for Data Entry
    • QUOTIENT in Excel
    • Excel Sorting
    • Excel Sort by color
    • Excel Data Bars
    • Excel Tool for Data Analysis
    • Excel Flash Fill
    • Excel Auto Fill
    • Excel Quick Access Toolbar
    • Excel Wrap Text
    • Excel Exponential Smoothing
    • Excel ANOVA
    • Excel Merge Two Tables
    • Excel Conditional Formatting in Pivot Table
    • Dynamic Tables in Excel
    • Excel Sort by date
    • Excel Dynamic Range
    • Record Macro in Excel
    • Two Variable Data Table in Excel
    • Merge Cells in Excel
    • One Variable Data Table in Excel
    • Excel Fill Handle
    • CheckBox in Excel
    • Excel Table
    • Excel Combo Box
    • Auto Format in Excel
    • Advanced Filter in Excel
    • Excel AutoFilter
    • Excel Data Filter
    • Excel Data Validation
    • Excel Radio Button
    • Data Table in Excel
    • Text to Columns in Excel
    • Excel List box
    • Excel Solver Tool
    • Scrollbar in Excel
  • Excel Functions (10+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (12+)
  • Lookup Reference Functions in Excel (30+)
  • Maths Function in Excel (39+)
  • TEXT and String Functions in Excel (25+)
  • Date and Time Function in Excel (20+)
  • Statistical Functions in Excel (55+)
  • Information Functions in Excel (4+)
  • Excel Charts (44+)
  • Excel Tips (195+)
  • VBA (180+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (14+)
  • Excel Formula and Functions (20+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED Training
  • EXCEL Training COURSE
Footer
About Us
  • Who is EDUCBA?
  • Sign Up
  •  
Free Courses
  • Free Online Excel Course
  • Free Vba Course
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training
Resources
  • Resources (A To Z)
  • Excel Charts
  • Excel Tips
  • Excel Tools in Excel
  • Excel Functions
  • Financial Functions in Excel
  • Logical Functions in Excel
  • Lookup Reference Functions in Excel
  • Maths Function in Excel
  • TEXT and String Functions in Excel
  • Date and Time Function in Excel
  • Statistical Functions in Excel
  • Information Functions in Excel
Apps
  • iPhone & iPad
  • Android
Support
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions

© 2019 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

Download Radio Button Excel Template

By continuing above step, you agree to our Terms of Use and Privacy Policy.
EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA Login

Forgot Password?

Let’s Get Started
Please provide your Email ID
Email ID is incorrect

Limited Period Offer - All in One Excel VBA Bundle (120+ Courses, 500+ hours of Videos) View More

Limited Period Offer - Limited Period Offer - All in One Excel VBA Bundle (120+ Courses, 500+ hours of Videos) View More