Subscribe

Lesson 7 of 104 5 min Updated Completed

How to Insert a Checkbox in Excel

Checkboxes turn a plain list into an interactive checklist. In this lesson you’ll insert a checkbox, link it to a cell, and use it to build a simple to-do list that counts what you’ve finished.

You’ll need the Developer tab. If you don’t see it, first follow How to Show the Developer Tab in Excel.

Insert a checkbox

  1. On the Developer tab, click Insert.

  2. Under Form Controls, click Check Box.

    The Check Box button under Form Controls on the Developer tab

  3. Click and drag on the worksheet to draw the checkbox, here in cell E4.

    Drawing a checkbox in cell E4 of an Excel worksheet

  4. To change or remove the text next to the box, right-click the checkbox and click Edit Text.

    Right-clicking a checkbox and choosing Edit Text

Linking a checkbox to a cell lets formulas know whether it’s ticked.

  1. Right-click the checkbox and click Format Control.

    Right-clicking a checkbox and choosing Format Control

  2. On the Control tab, set Cell link to C3, then click OK.

    The Format Control window with the cell link set to C3

  3. Test it: when the box is ticked, cell C3 shows TRUE, and when it isn’t, C3 shows FALSE.

    A ticked checkbox with its linked cell C3 showing TRUE

Build a to-do list

  1. Draw a checkbox in cell C3 and delete its text (right-click > Edit Text).

  2. Select C3 and drag the fill handle down to C9 to copy the checkbox to each task.

    Copying a checkbox down to cell C9 with the fill handle

  3. Right-click the first checkbox and click Format Control.

    Opening Format Control for the first checkbox in the to-do list

  4. Link it to cell D3.

  5. Repeat for the other six checkboxes, linking each one to the cell beside it (D4 to D9).

  6. To count finished tasks, enter this formula in C12:

    =COUNTIF(D3:D9, TRUE)

    It counts how many linked cells are TRUE, meaning how many boxes are ticked.

    The COUNTIF formula counting 5 of 7 tasks done

  7. To check whether you’ve finished everything, enter this formula in C14:

    =IF(C12=C11, "YES", "NO")

    It shows YES only when the number of tasks done equals the total in C11.

    An IF formula showing NO because not all tasks are done

  8. Tick all the boxes and watch the result change to YES.

    All tasks ticked and the daily goal showing YES

Tip: Column D only helps the formulas, so you can hide it to make the list look cleaner. Right-click the column D heading and click Hide.

Using Microsoft 365? Newer versions also have built-in cell checkboxes: select the cells, then on the Insert tab click Checkbox. Each cell then holds TRUE or FALSE itself, with no linking needed.

Download the example: Excel checkbox to-do list

You’ve finished the first chapter. Next, learn how to select and work with groups of cells in What Is a Range in Excel?