Editing Multiple Check Boxes in Microsoft Excel
By 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
Step 1
Open Microsoft Excel, then click the “File” tab on the top menu bar.
Step 2
Click “Options,” then click “Customize Ribbon.”
Step 3
Click the “Customize the Ribbon” drop-down box, then click “Main Tabs.”
Step 4
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.
Edit Controls
Step 1
Open the spreadsheet to edit in Excel and make sure the Developer tab is visible.
Step 2
Click the “Developer” tab, then click the “Design Mode” view option.
Step 3
Right-click on the check box group to edit, then click “Format Control.”
Step 4
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.
Step 5
Click the "Properties" tab to edit the properties of the controls, if desired.
Step 6
Click “OK” to save the changes to the control, then save the spreadsheet.
References
Warnings
- Information provided in this article applies to Microsoft Excel 2013. Instructions may vary slightly or significantly for other versions of Excel.
Writer Bio
Randall Blackburn has worked for several Fortune 1000 companies as a technical writer over the past seven years. He has produced a wide variety of technical documentation, including detailed programming specifications and research papers. Randall has also acquired several years' experience writing web content. Randall lives and works in Austin, TX.