Add a check box or option button (Form controls) - Excel

Try Microsoft Edge A fast and secure browser that's designed for Windows 10 No thanks Get started. You can insert form controls such as check boxes or option buttons to make data entry easier. Check boxes work well for forms with multiple options.

Option buttons are better when your user has just one choice. To enable the Developer tab, follow these instructions:.

To add a check box, click the Developer tab, click Insertand under Form Controlsclick. To add an option button, click the Developer tab, click Insertand under Form Controlsclick.

You can only add one checkbox or option button at a time. To edit or remove the default text for a control, click the control, and then update the text as needed. After you insert a check box or option button, you might want to make sure that it works the way you want it to.

For example, you might want to customize the appearance or properties. The size of the option button inside the control and its distance from its associated text cannot be adjusted. To format a control, right-click the control, and then click Format Control. In the How to put a tick box in excel spreadsheet Control dialog box, on the Control tab, you can modify any of the available options:.

In the Cell link box, enter a cell reference that contains the current state of the option button. The linked cell returns the number of the selected automated futures trading software button in the group of options.

Use the same linked cell for all options in a group. The first option button returns a 1, the second option button returns a 2, and so on.

If you have two or how to put a tick box in excel spreadsheet option groups on the same worksheet, use a different linked cell for bollinger bands forex ea option group. For example, a personnel form, with a Job type group box, contains two option buttons labeled Full-time and Part-time linked to cell C1. After a user selects one indicators for profitable trading binary options 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.

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. Add a check box, option, or Toggle button ActiveX controls. Overview of forms, form controls, and ActiveX controls on a worksheet.

Search Office help No results. Add a check box or option button Form controls Applies To: Excel Excel Excel Excel More To enable the Developer tab, follow these instructions: Was this information helpful?

Use Excel check boxes to create a list-totaling spreadsheet - TechRepublic

How can we improve it? Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents. Learn Windows Office Skype Outlook OneDrive MSN. Devices Microsoft Surface Xbox PC and laptops Microsoft Lumia Microsoft Band Microsoft HoloLens.

Downloads Download Center Windows downloads Windows 10 apps Office apps Microsoft Lumia apps Internet Explorer. Values Diversity and inclusion Accessibility Microsoft in education Microsoft philanthropies Corporate social responsibility Privacy at Microsoft. Company Careers About Microsoft Company news Investors Research Site map.