How to Insert a Checkbox in Excel: 3 Easy Methods

You can insert a checkbox in Excel in three ways: use Excel’s new Insert > Checkbox feature for interactive lists, add a Form Control checkbox for older desktop versions, or insert a checkbox symbol for printable sheets. The best method depends on your Excel version and whether you need formulas to react to checked items.

For most Microsoft 365 users, the new in-cell checkbox is the quickest and cleanest option. It stores a logical value—TRUE when checked and FALSE when unchecked—so you can use it in formulas, filters, and conditional formatting.

Which Checkbox Method Should You Use?

Method	Best for	Interactive?	Works with formulas?
Insert > Checkbox	Modern task lists and trackers	Yes	Yes
Form Control	Older Excel desktop versions and forms	Yes	Yes, with a linked cell
Checkbox symbol	Printed forms or visual lists	No	No

Method 1: Insert a Checkbox Using the Insert Tab

This is the easiest method in newer versions of Excel, including supported Microsoft 365 desktop versions.

Steps to Add In-Cell Checkboxes

1. Open your Excel worksheet.
2. Select the cell or range of cells where you want checkboxes.
3. Go to the Insert tab on the Ribbon.
4. Click Checkbox.
5. Excel adds a checkbox to every selected cell.

To check or uncheck an item, simply click the checkbox. You can also select a checkbox cell and press the Spacebar.

Example: Create a Simple To-Do List

Create this small list:

A	B
Task	Done
Reply to emails	Checkbox
Finish presentation	Checkbox
Pay electricity bill	Checkbox

Select the cells in the Done column and choose Insert > Checkbox. Each checkbox will store either TRUE or FALSE in the background.

How to Use Excel Checkbox Values in Formulas

The new Excel checkboxes use logical values:

• Checked = TRUE
• Unchecked = FALSE

This makes them useful for trackers and dashboards.

Show “Complete” or “Pending”

If your checkbox is in cell B2, enter this formula in C2:

=IF(B2,"Complete","Pending")

When the checkbox is selected, Excel shows Complete. When it is cleared, Excel shows Pending.

Count Completed Tasks

If your checkboxes are in cells B2:B20, use:

=COUNTIF(B2:B20,TRUE)

This counts all checked boxes.

Calculate Completion Percentage

Use this formula to calculate the percentage of completed tasks:

=COUNTIF(B2:B20,TRUE)/COUNTA(B2:B20)

Then format the result as a percentage.

Add Values Only When a Checkbox Is Checked

Suppose column B contains checkboxes and column C contains amounts. To total only the checked items, use:

=SUMIF(B2:B20,TRUE,C2:C20)

This is useful for shopping lists, invoice approvals, expense trackers, and project checklists.

How to Remove In-Cell Checkboxes

To remove checkbox formatting and keep the TRUE/FALSE values:

1. Select the checkbox cells.
2. Go to Home > Clear > Clear Formats.

To remove the checkboxes and values completely:

1. Select the checkbox cells.
2. Press Delete.
3. If Excel only clears the check marks on the first attempt, press Delete again.

Method 2: Insert a Checkbox Using Form Controls

If you do not see Insert > Checkbox, use the classic Form Control method. This works in many desktop versions of Excel, including Excel 2016, Excel 2019, Excel 2021, Excel 2024, and Microsoft 365.

Step 1: Enable the Developer Tab

The Developer tab is hidden by default.

1. Click File > Options.
2. Select Customize Ribbon.
3. Under Main Tabs, tick the box beside Developer.
4. Click OK.

The Developer tab will now appear on the Excel Ribbon.

Step 2: Insert a Form Control Checkbox

1. Open the Developer tab.
2. Click Insert.
3. Under Form Controls, choose the Check Box icon.
4. Click anywhere on the worksheet to place the checkbox.
5. Drag the edges to resize or reposition it.

Excel adds a default label, usually “Check Box 1.” To remove or edit this text, right-click the checkbox and choose Edit Text.

Step 3: Copy the Checkbox to Other Rows

To create a checklist quickly:

1. Right-click the checkbox.
2. Select Copy.
3. Select the destination cells.
4. Press Ctrl + V.

Make sure each checkbox is aligned with the correct row.

Link a Form Control Checkbox to a Cell

Unlike the newer in-cell checkbox, a Form Control checkbox is an object placed over the worksheet. To use it in formulas, link it to a cell.

1. Right-click the checkbox.
2. Select Format Control.
3. Open the Control tab.
4. In the Cell link box, enter a cell reference, such as $D$2.
5. Click OK.

When the checkbox is checked, the linked cell displays TRUE. When unchecked, it displays FALSE.

You can now use the same formulas shown earlier, such as:

=IF(D2,"Complete","Pending")

Keep Form Control Checkboxes Aligned With Cells

Checkboxes can become misaligned when you sort or resize data. To reduce this problem:

1. Right-click the checkbox.
2. Select Format Control.
3. Open the Properties tab.
4. Choose Move and size with cells.
5. Click OK.

Do this before sorting your task list or adding new rows.

Method 3: Insert a Checkbox Symbol for Printable Lists

Use this method when you only need a visual checkbox for a printed form. A symbol cannot be clicked and does not return TRUE or FALSE.

Insert an Empty Checkbox Symbol

1. Select the cell where you want the symbol.
2. Go to Insert > Symbol.
3. Choose a font such as Segoe UI Symbol, Wingdings, or Arial Unicode MS.
4. Find an empty box symbol, such as ☐.
5. Click Insert.

For a checked box, you can use ☑.

You can also copy and paste these symbols:

• Empty checkbox: ☐
• Checked checkbox: ☑
• Tick mark: ✓

How to Insert Checkboxes in Excel for Mac

On newer Excel for Microsoft 365 for Mac versions, select the cells and use:

Insert > Checkbox

If the Checkbox command is unavailable, use the Developer tab:

1. In the top menu, select Excel > Preferences.
2. Under Authoring, choose View.
3. Enable the Developer tab.
4. Open Developer and insert a checkbox control.

The names of menu options can differ slightly depending on your Excel version.

Can You Insert Checkboxes in Excel for the Web?

Excel for the web has feature limitations that can vary by account and workbook. If you need classic Form Control checkboxes, use the Excel desktop app.

When working with a workbook containing Form Controls, avoid editing it in the browser if Excel warns that unsupported features may be removed. Open the workbook in the desktop application to preserve the controls.

How to Use Checkboxes With Conditional Formatting

You can make completed tasks easier to identify by applying a strikethrough or colour when the checkbox is selected.

Assume:

• Task name is in A2
• Checkbox is in B2

Steps

1. Select the task range, such as A2:A20.
2. Go to Home > Conditional Formatting > New Rule.
3. Choose Use a formula to determine which cells to format.
4. Enter:

=$B2=TRUE

5. Click Format.
6. Choose a light grey fill, strikethrough text, or another completed-task style.
7. Click OK.

Now, when you tick a checkbox in column B, the related task in column A changes automatically.

Common Problems and Fixes

I Cannot Find the Checkbox Button

The newer Insert > Checkbox option may not be available in your Excel version. Update Microsoft 365 if possible, or use the Form Control method through the Developer tab.

My Checkbox Is Not Moving With the Row

This usually happens with Form Controls. Right-click the checkbox, open Format Control > Properties, and choose Move and size with cells.

My Formula Does Not Work With a Checkbox

For new in-cell checkboxes, reference the checkbox cell directly because it contains TRUE or FALSE.

For Form Control checkboxes, first link each checkbox to a cell through Format Control > Control > Cell link. Use the linked cell in your formula.

I Accidentally Added the Same Checkbox to Many Cells

Select the affected cells and press Delete. If the checkbox is an in-cell checkbox, you may need to press Delete a second time after clearing its checked state.

Should I Use ActiveX Checkboxes?

For most users, no. Microsoft has disabled ActiveX controls for security reasons, and they may not work in newer Excel versions. Use the new in-cell Checkbox feature or a Form Control checkbox instead.

Frequently Asked Questions

What is the fastest way to add checkboxes in Excel?

Select the target cells and choose Insert > Checkbox. This is the fastest method in supported Microsoft 365 versions.

Can I add multiple checkboxes at once?

Yes. Select a range of cells before choosing Insert > Checkbox. Excel inserts one checkbox into each selected cell.

Can I count checked boxes in Excel?

Yes. If the checkbox cells contain TRUE or FALSE values, use:

=COUNTIF(B2:B20,TRUE)

How do I make a checklist in Excel?

Add tasks in one column, select the adjacent cells, and choose Insert > Checkbox. You can then add conditional formatting to cross out completed tasks.

Can I use checkboxes in an Excel budget sheet?

Yes. Add a checkbox beside each expense or payment and use SUMIF to total only checked items. This is helpful for bills, shopping lists, reimbursement trackers, and approval sheets.

Final Thoughts

For modern Excel versions, Insert > Checkbox is the best option because it is fast, clean, and works directly with TRUE/FALSE formulas. Use Form Control checkboxes when you need compatibility with older desktop versions, and use symbols only for non-interactive printable forms.

Once your checkboxes are linked to formulas and conditional formatting, Excel can become a simple but powerful tool for managing tasks, budgets, approvals, and project progress.