Collecting and entering static data into a spreadsheet entry can be a real chore, bore or more. Reading the same data, making the same entries over and over are enough to drive a thinking person to ... to thinking about ways not to have enter the same data over and over again. That's where radio buttons come in handy. These unique features control the data being entered, ensuring no duplication or errors. A radio button set allows only one entry per grouping. In Office 2007 and 2010, "radio buttons" are called "option buttons."
Things You'll Need
- Microsoft Excel 2007 or 2010
Define the mutually exclusive data to be collected. For example, if the spreadsheet is used to track clothing by size, the option buttons might be for small, medium and large sizes. This prevents mistyping information.
Select the "Developer" tab; from the "Controls group," press "Insert > Option Button." Place the cursor into the position where the upper left corner of the button and label are desired, and then drag a square, creating the frame. Do the same for the remaining option buttons to be created. Excel will name these "Option Button 1," "2," and "3."
Select "Option Button 1," and in the "Developer" tab, "Controls" group, select "Properties." A new window opens allowing the option button to be customized. From this pane, the font, color, status, control, caption and important functions can be controlled. Define the caption, select fonts, colors and size, and then create the functions for the button. Do the same for the remaining option buttons to be grouped.
Select the option buttons. Using the "Drawing Tools>Format" tab in the "Align" group, use the "Align" button to position the option buttons as desired, then use the "Group" button to create the Option Button Group.
Add the appropriate commands and cell links as needed for the option buttons, and then protect the cells over which the buttons are located. When the spreadsheet is completed, protect the Worksheet in the "Review" tab, "Changes" group, and the option buttons will be functional.
Tips & Warnings
- Excel 2007 and 2010 offer a choice of conventional or ActiveX controls; this article highlights the ActiveX controls.
- Design features are limited for the option buttons, but using the 3D lighting options can create some unusual and attractive appearance effects.
- If a macro is to be attached to an option button, write and test the macro before creating the option buttons.
- Although slightly more complex than the conventional controls using ActiveX is the better system because of its portability using XML (Extensible Markup Language) for sharing or even Internet use.
- Radio buttons function differently in Excel 2000 and 2003, and these instructions will not work in those versions.
- Option buttons are mutually exclusive; the design will not allow more than one button in a group to be selected.
- Ensure that the buttons are locked from editing once the controls are working as desired to prevent accidental editing that could impact function.
- Photo Credit Jupiterimages/Pixland/Getty Images
How to Make a Button for a Macro in Excel
Excel macros are designed to automate processes on a spreadsheet or perform commands on Excel data. You create the actual code for...
How to Create a Command Button in Microsoft Excel
You can add a button control to an Excel worksheet and link it to a macro or a VBA routine through the...
How to Use the Option Buttons in Excel
Option buttons are also known as radio buttons. When used in Microsoft Excel forms, they allow the user to select from a...
How to Use Radio Buttons in Excel
A radio button, sometimes called an option button, is a circular control similar to a check box. Radio buttons are usually in...
How to Create an Option Group in MS Excel
Most people associate Microsoft Excel with spreadsheets, which are the most common use for the program. But Excel has Visual Basic, a...
How Can I Remove a Button From Within a Spreadsheet?
If you routinely encounter buttons you don’t use or use sporadically in a spreadsheet you're working on, you can remove those buttons...
How to Insert Check Boxes
There are times when you're working with programs like MS Word, Infopath or Excel and need to include a check box for...
Excel Spreadsheet Options
The Excel options, which you can find under the "File" tab in Microsoft Excel 2010, allow you to alter certain aspects of...