Easily insert multiple checkboxes or option buttons at once in Excel

Normally we can only insert one checkbox or option button in a cell at a time with tedious steps in Excel. But Kutools for Excel's Batch Insert Check Boxes utility and Batch Insert Option Buttons utility can help Excel users quickly insert multiple checkboxes or option buttons into all selected cells.

Normally, we can apply the Symbol feature to insert check mark symbols into cells easily.

1. Select the cells you will insert the check mark symbols, and click Insert > Symbol.

2. In the opening Symbol dialog box, please:

(1) Select Wingdings from the Font drop down list;

(2) Drag the vertical scroll bar down until you view the check mark symbols, and select the check mark symbol you will insert. See screenshot:

3. Click the Insert button.

Note: With the Symbol feature, you can insert multiple symbols into one cell, but can’t insert multiple symbols into multiple cells at a time.

Sometimes you may forget the group where the check mark symbols are saved in the Symbol dialog box. Do not worry! Kutools for Excel’s Auto Text utility provides you a workaround to save the check mark symbols as AutoText entries, so that you can reuse these symbols easily with only one click in any workbook.

1. Click Kutools > Insert > AutoText to activate the AutoText Pane.

2. Select one/multiple check mark symbol cells you will save as AutoText entry, and click the Add button  at the top of AutoText pane.

3. In the opening New AutoText dialog box, please type a name for the new AutoText entry in the Name box, specify a group where this AutoText will be saved into from the Group drop down list, and click the Add button. See screenshot:

So far we have saved the selected check mark symbol cells as an AutoText entry. When you need to reuse it, just select the cell you will insert the check mark symbols in, and click the AutoText entry in the AutoText pane. See screenshot:

Insert multiple checkboxes in Excel

Insert radio buttons or option buttons in Excel