Editing Multiple Check Boxes in Microsoft Excelby Randall Blackburn
You can edit multiple check boxes in a control group in Microsoft Excel with the Format Controls dialog box. First, add the Developer tab to the top navigation ribbon in the interface. The Developer tab makes Visual Basic commands and controls available for use in the spreadsheet. Next, change the view to Design Mode. You can then open the Format Controls dialog box for the check box group to edit the corresponding text and formatting options for the check box controls.
Display Developer Tab
Open Microsoft Excel, then click the “File” tab on the top menu bar.
Click “Options,” then click “Customize Ribbon.”
Click the “Customize the Ribbon” drop-down box, then click “Main Tabs.”
Click the “Developer” check box. Click “OK” to save the changes and close the dialog box. The Developer tab displays on the top menu bar.
Open the spreadsheet to edit in Excel and make sure the Developer tab is visible.
Click the “Developer” tab, then click the “Design Mode” view option.
Right-click on the check box group to edit, then click “Format Control.”
Click the “Control” tab in the Format Control dialog box, then edit the check box control as desired. For example, you can click the “Input Range” icon to select a range of text to use as the labels in your check box group.
Click the "Properties" tab to edit the properties of the controls, if desired.
Click “OK” to save the changes to the control, then save the spreadsheet.
- Information provided in this article applies to Microsoft Excel 2013. Instructions may vary slightly or significantly for other versions of Excel.