PlayInfoBox

Home /Utilities /How to Insert a Form Control Checkbox in Excel

How to Insert a Form Control Checkbox in Excel

Tap through each step in order.

  1. Turn on the Developer tab if it is hidden

    Go to "File β†’ Options β†’ Customize Ribbon" and check "Developer" to add it to the ribbon.

  2. On the Developer tab, click Insert β†’ Form Controls

    In the "Controls" group on the "Developer" tab, click "Insert" and choose the checkbox icon under Form Controls.

  3. Click or drag to draw the checkbox

    Click, or click and drag, on the worksheet where you want the checkbox to appear.

  4. Why it is worth using

    For checklists or survey items, a checkbox lets you mark status with a click, and the linked cell's value can be used to calculate how many items are complete.

Still typing "done" and "not done" by hand?

Manually typing status labels into a checklist is slower and easier to get wrong than it needs to be. Adding a checkbox lets you mark something complete with a single click, and the TRUE/FALSE value in the linked cell can feed directly into a formula.

Count completed items automatically with COUNTIF

Once each checkbox is linked to its own cell, a formula like =COUNTIF(range,TRUE) instantly totals how many boxes are checked. This turns a simple checklist into a small live progress tracker without any extra manual counting.

Frequently Asked Questions

Can I remove the text label next to the checkbox?

Yes β€” click the label once to select just the text, then delete it and leave the checkbox itself in place.

Can I copy one checkbox to create several more?

Yes β€” copy and paste the checkbox to add identically shaped ones elsewhere, but you will need to set the Cell Link separately for each new copy.