Insert a Checkbox in Excel (and Build a Checklist)

In current Microsoft 365, Insert → Checkbox puts a real tick box inside a cell, and the cell’s value is simply TRUE or FALSE. In older versions, use the Form Control checkbox from the Developer tab.

Method 1: In-cell checkbox (Microsoft 365)

1. Select the cells, for example D3:D7.
2. Go to Insert → Checkbox.
3. Click a box, or select it and press Space, to tick it.

Each cell now holds TRUE or FALSE, so formulas can use it directly. The boxes copy, sort and filter like normal cells. To remove them, select the cells and press Delete twice.

Method 2: Form Control checkbox (any version)

Show the Developer tab first if you don’t see it: add the Developer tab.

1. Go to Developer → Insert → Check Box (Form Control).
2. Click on the sheet to place it. Right-click → Edit Text to change or delete the caption.
3. Drag the fill handle to copy it down.

Link each box to a cell

Right-click the checkbox → Format Control → Control tab → set Cell link (such as F3). The cell shows TRUE or FALSE as you tick and untick. Copied boxes keep the same link, so set each one.

Build a checklist

For colour, select the status cells → Conditional Formatting → New Rule → Use a formula: =E3="Done" with a green fill.

Video

Related