How to Use the Option Buttons in Excel

1. Open Excel. Click 'File' and 'New' in the menu bar. Select 'Blank Workbook' from the pane on the right side of the Excel window.
2. Turn on the Forms toolbar. Right-click in the gray area of any toolbar. Select 'Forms' from the displayed list.
3. Add a group box. Select 'Group Box' from the 'Forms' toolbar. Click and drag in the spreadsheet with the mouse to create a group box of the desired size.
4. Rename Group Box 1 by highlighting the text and typing an appropriate name.
5. Create the option button. Click on 'Option Button' in the 'Forms' toolbar. Click in the desired area of the group box to paste the option button.
6. Customize text for the option button. Right-click the option button. Select 'Edit Text' from the displayed menu. Type the new name.
7. Change the appearance of the option button, if desired. Right-click the option button. Select 'Format Control'. Add color and select line style and weight.
8. Create more option buttons by repeating Steps 5, 6 and 7. Use the arrow keys on the keyboard to align or reposition the option buttons.
9. Save the file. Click 'File' and 'Save' in the menu bar. Name the file. Click the 'Save' button. Click on 'File' and 'Close' in the menu bar to close the file.