How to Use Radio Buttons in Excel

Written by tricia goss Google
  • Share
  • Tweet
  • Share
  • Email

A radio button, sometimes called an option button, is a circular control similar to a check box. Radio buttons are usually in groups, allowing users to select one of several options. A radio button displays a dot in the centre when a user selects that option by clicking on the button. You can add radio buttons to Excel worksheets to collect data from users or simply to make the spreadsheet more interactive.

Skill level:
Moderately Easy

Other People Are Reading

Things you need

  • Excel 2003 or 2007

Show MoreHide

Instructions

    Using Radio Buttons in Excel 2003

  1. 1

    Open the worksheet to which you want to add radio buttons. Open the "Control Toolbox" by going to the "View" menu, pointing to "Toolbars" and selecting "Control Toolbox." The toolbox appears as a floating toolbar.

  2. 2

    Click the radio button control in the "Control Toolbox." If you are not sure which control this is, hover your mouse over each button in the "Control Toolbox" and click on the one that says "Option Button."

  3. 3

    Click onto the worksheet where you want to place the first radio button and drag the box to "draw" the size you want it to be.

  4. 4

    Right-click the radio button, point to "Option Button Object" and click "Edit." Delete the "Option Button" text and type in your desired text for the first radio button. Click outside of the box to stop editing and apply your text.

  5. 5

    Right-click the radio button and select "View Code" to add a macro to the radio button. Right-click the radio button and select "Properties" to change other properties of the button. Click the "Exit Design Mode" button in the "Control Toolbox" to leave design mode and enable the radio button.

    Using Radio Buttons in Excel 2007

  1. 1

    Display the "Developer Tab." Click the "Office Button" and click "Excel Options." Select the "Show Developer Tab in the Ribbon" check box under "Top Options for Working With Excel" and click "OK."

  2. 2

    Go to the "Developer" tab and click "Insert" in the "Controls" group. Click "Option Button" under "ActiveX Controls."

  3. 3

    Click onto the Excel worksheet and drag the mouse to draw the radio button onto the page.

  4. 4

    Click "Design Mode" in the "Controls" group of the "Developer" tab. Right-click the radio button, point to "Option Button Object" and click "Edit." Delete the "Option Button" text and type in your desired text for the first radio button. Click outside of the box to stop editing and apply your text.

  5. 5

    Right-click the radio button and select "View Code" to add a macro to the radio button. Right-click the radio button and select "Properties" to change other properties of the button. Click the "Exit Design Mode" button in the "Control Toolbox" to leave design mode and enable the radio button.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.