Right-click the control, and press DELETE. If you have three or more options to evaluate in the same group of options, you can use the CHOOSE or LOOKUP functions in a similar manner. After a user selects one of the two options, the following formula in cell D1 evaluates to "Full-time" if the first option button is selected or "Part-time" if the second option button is selected. Use the returned number in a formula to respond to the selected option.įor example, a personnel form, with a Job type group box, contains two option buttons labeled Full-time and Part-time linked to cell C1. Click on the Option button This changes the default mouse pointer to a crosshair-like pointer. Under the Controls section, click on the dropdown from Insert and click on the Option Button. To insert a radio button, navigate to the Developer tab. If you have two or more option groups on the same worksheet, use a different linked cell for each option group. Insert a Radio Button Once the developer tab is enabled, let us see how to insert radio button in Excel. The first option button returns a 1, the second option button returns a 2, and so on. Use the same linked cell for all options in a group. The linked cell returns the number of the selected option button in the group of options. In the Cell link box, enter a cell reference that contains the current state of the option button. Unchecked: Displays an option button that is cleared. In the Format Control dialog box, on the Control tab, you can modify any of the available options:Ĭhecked: Displays an option button that is selected. To format a control, right-click the control, and then click Format Control. Note: The size of the option button inside the control and its distance from its associated text cannot be adjusted.
0 kommentar(er)
