How to Create an Option Group in MS Excel

1. Display the Developer tab if it is not already visible. To turn this tab on, click the Microsoft Office Button (a round button with the mutli-colored Office logo) and choose 'Excel Options'. In the section called 'Top Options for Working with Excel', find the 'Popular' category. Place a check next to 'Show Developer Tab' in the Ribbon checkbox and click 'OK'.
2. Access the Developer tab and enter the 'Controls' section, then click the 'Insert' menu.
3. Select the 'Form Controls' option inside the 'Insert' menu, then click on the 'Option' button.
4. Click the cell on the spreadsheet that you want to contain the option button.
5. Launch the 'Properties' setting from the 'Controls' group in the 'Developer' tab.
6. Configure the settings for the new option button using the fields in the 'Properties' area. The 'Value' option allows a default state for the button that remains in effect until the user changes it. An option button is either on or off, so the 'Value' field accepts these two states as 'Checked' or 'Unchecked'.Each option button in a group carries a numerical value, with the first button equaling the value 1. The 'Cell Link' field copies the value of the option button as numerical data stored in any cell. Identify the cell using standard Excel cell referencing. For example, A1 is the upper left cell in a worksheet.
7. Add a checkbox to the option group in the same manner as the option button, if desired. In the 'Form Controls' option inside the 'Developer' tab's 'Insert' menu, click on the 'Checkbox' button.
8. Add more option buttons or checkboxes until the option group is complete.