Online Test Banks
Score higher
See Online Test Banks
eLearning
Learning anything is easy
Browse Online Courses
Mobile Apps
Learning on the go
Explore Mobile Apps
Dummies Store
Shop for books and more
Start Shopping

Making Radio Buttons for Excel Forms in Office 2011 for Mac

7 of 12 in Series: The Essentials of Making Forms in Office 2011 for Mac

Knowing how to make radio buttons in Excel 2011 for Mac is just as important as knowing how to make check boxes. Radio buttons (also called option buttons) are similar to check boxes, but you use radio buttons when only one of several choices is allowed. You put a group box around each group of radio buttons that answer a given question so that Excel 2011 for Mac knows which radio buttons answer which question.

Each group has a single cell link for all the radio buttons within the group. You can put as many radio buttons as you want within a group, but you do need a minimum of two radio buttons to make the choices work. First you make radio buttons and then you group them. To finish up, you make the cell links.

image0.jpg

Making a radio button in Excel 2011 for Mac

Take these steps to make a radio button:

  1. While your form is unprotected, click the Radio Button control on the Developer tab of the Ribbon.

  2. Drag diagonally and then let go of the mouse.

    A radio button appears and is selected on your worksheet. Repeat Steps 1 and 2 for each radio button you need. If you don't make the right number of controls, you can always make more of them or delete them any time.

To change the text inside the button, click in the text. Drag over the text to select it, and then start typing replacement text.

Grouping radio buttons in Excel worksheets

When you have your radio buttons nicely arranged on your worksheet, you need to put them into groups.

  1. While your form is unprotected, click the Group Box control on the Developer tab of the Ribbon.

  2. Drag diagonally and then let go of the mouse.

    A group box appears as selected on your worksheet. Repeat Steps 1 and 2 for each group box you need. You need one group for each set of radio buttons.

  3. Resize the group boxes and the radio buttons so that the radio buttons fit completely inside the group boxes.

    If a radio button isn’t completely contained by its group box, it isn’t included in the group.

To change the text for the group box's label, click in the text. Drag over the text to select it and then start typing the replacement text or delete the text to have a continuous line for the box.

blog comments powered by Disqus

SERIES
The Essentials of Making Forms in Office 2011 for Mac

Advertisement

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.