Add Checkbox to Excel 2007-2013

Add Checkbox to Excel 2007-2013

Add a CheckBox control

You can add selectable Check Box controls on your worksheet which you can check or uncheck by clicking on them.

Add Check Box controls to your Microsoft Excel spreadsheet


You will need to use the Developer tab to add these controls.

Add the Developer tab in Microsoft Excel


If the Developer tab isn’t displayed on your Ribbon, here’s how to display it.


Show Developer Tab


In Excel 2010, on the File tab click Options and click the Customize Ribbon category. In the Main Tabs list, select the Developer check box, and then click OK.

In Excel 2007, click the Office button and then click Excel Options. In the Popular category, select the Show Developer tab in the Ribbon.


Now, from the Developer tab, click Insert in the Controls group. Click on the Check Box control in Form Controls section and click and drag to place the checkbox on your worksheet.

Add Check Box controls to your Microsoft Excel worksheet

You can add a label to the check box or, for no label, delete the default text.

Add Check Box controls to your Microsoft Excel spreadsheet

Hold down the CTRL key while dragging the border of the CheckBox to make a copy of the CheckBox, .

Hold down the Shift while dragging the Check Box to move it vertically or horizontally.

Holding down the ALT key while dragging the Check Box will align it with the edges of the cells. This is a quick way to align multiple Check Boxes.

Right-click the Check Box and choose Format Control from the popup menu for other properties that you can customize (including 3D shading).

 

 

Add Checkbox to Excel 2007-2013