How to Turn TRUE and FALSE Into Checkboxes in Excel

In Excel for Microsoft 365 (Windows or Mac), select the cells that hold TRUE and FALSE, then choose Insert > Checkbox. Microsoft describes a checkbox as a TRUE or FALSE value with checkbox formatting, so a checked box is TRUE and an empty one is FALSE. No Checkbox button? Use a Developer tab check box linked to each cell.

An exported task list has a Done column of TRUE and FALSE, and you’d rather click a box.

What You Need Before You Start

• A version with the Checkbox command. Microsoft’s Use checkboxes in Excel page lists Excel for Microsoft 365 and Excel for Microsoft 365 for Mac. It doesn’t mention Excel 2021, Excel 2024, Excel for the web or the mobile apps, so don’t count on it there.
• Real TRUE/FALSE values. Excel has a logical (Boolean) data type, and cells can also hold the plain text “TRUE”. Checkboxes are built on the logical type, so text needs converting first (next section).
• A backup copy. Duplicate the sheet (right-click its tab > Move or Copy > Create a copy) before you convert a column you care about.

Your situation	Best route
Microsoft 365 and a column of real TRUE/FALSE	Insert > Checkbox on the whole column
Microsoft 365, but the column holds text, Yes/No or 1/0	Convert to TRUE/FALSE first, then Insert > Checkbox
No Checkbox button on the Insert tab (for example, Excel 2019 or another version Microsoft’s checkbox page doesn’t list)	Developer tab check boxes linked to each cell
A sheet you only print, never click	A Wingdings box symbol driven by a formula

The example below uses Marcus’s moving checklist: tasks in column A, due dates in column B and a Done column C with TRUE or FALSE in C2:C20.

Check That Your Cells Hold Real TRUE and FALSE

Data exported from forms, databases or other apps often arrives as text that just looks like TRUE and FALSE. Two quick tells:

• Alignment: with no alignment applied, Excel normally centers logical values and lines text up on the left, so a left-hugging TRUE is usually text. Treat this as a hint and confirm with the test formula.
• A test formula: in an empty cell, type =ISLOGICAL(C2). TRUE means C2 holds a real logical value; FALSE means it’s text or something else.

Turn Text TRUE and FALSE Into Real Values

The quickest fix is to make Excel re-read the column. Select C2:C20, then go to Data > Text to Columns and select Finish without changing anything. Excel re-enters each value as if you’d typed it, which usually turns text TRUE into logical TRUE. Run the ISLOGICAL test again to confirm.

If that doesn’t work, use a helper column:

1. In D2, type =UPPER(C2)="TRUE" and fill it down to D20. The result is a real TRUE or FALSE whether C2 held text or a logical value.
2. Copy D2:D20, select C2, and choose Home > Paste > Paste Values.
3. Delete the helper column.

Start From Yes and No, 1 and 0, or X

The same helper-column method converts any marker into TRUE or FALSE. Use =C2="Yes" for Yes/No, =C2=1 for 1/0, or =C2="X" for an X in done rows. Text comparisons in Excel ignore upper and lower case, so “yes” and “YES” both count. Paste the results back as values, as above.

Find and Replace (Ctrl + H) can also swap Yes for TRUE across a column. Excel usually treats the replaced entry as typed, so it becomes a logical value, but check one cell with ISLOGICAL before you go further.

Turn the TRUE and FALSE Cells Into Checkboxes

Microsoft’s checkbox page only says to select the range and choose Insert > Checkbox, and that a checkbox is made of the values TRUE and FALSE with checkbox formatting. It doesn’t say what happens to values already in the cells, so try this on a copy first. Because a checkbox is formatting on a TRUE or FALSE value, existing TRUE cells should show as checked and FALSE cells as empty. Microsoft’s page also doesn’t cover cells that hold text or numbers, so convert those first with the steps above.

1. Select the range with your TRUE and FALSE values, here C2:C20. Leave out the header cell.
2. Open the Insert tab on the ribbon.
3. Select Checkbox.
4. Check the column. If it worked, cells that held TRUE now show a checked box and cells that held FALSE an empty one. If anything looks wrong, press Ctrl + Z.
5. Click any box to switch it, or select several cells and press the Spacebar to toggle them together.

To confirm it worked, click a box and watch the formula bar. It should switch between TRUE and FALSE. These checkboxes live in the cells rather than floating over them, so they should travel with the cells when you sort, filter, copy or fill down. Microsoft’s page doesn’t cover those actions, so check one sort on your copy.

Empty cells can get boxes too. Microsoft’s steps start from any selected range, and an unchecked box is FALSE, so blank cells should show empty boxes, which is handy for extending the list to row 50 for future tasks.

Count, Filter and Format by Checkbox

Microsoft notes that a formula referring to a checkbox cell gets TRUE or FALSE. That makes the boxes easy to build on.

Goal	Formula	Result in Marcus’s list
Show a message	=IF(C2,"Done","To do")	Done or To do in each row
Count finished tasks	=COUNTIF(C2:C20,TRUE)	Number of checked boxes
Count open tasks	=COUNTIF(C2:C20,FALSE)	Number of empty boxes
Percent complete	=COUNTIF(C2:C20,TRUE)/COUNTA(C2:C20)	Format the cell as Percentage

COUNTA counts both TRUE and FALSE cells, so the percentage ignores rows you haven’t given a box yet.

Strike Through Finished Rows

1. Select A2:C20.
2. Go to Home > Conditional Formatting > New Rule.
3. Choose Use a formula to determine which cells to format and type =$C2=TRUE.
4. Select Format, check Strikethrough on the Font tab, pick a gray font color, and select OK twice.

The dollar sign keeps every cell in the row looking at column C. For more rule ideas, see how to use conditional formatting in Excel.

To show only open tasks, select the header row, choose Data > Filter, open the Done column’s arrow and leave only FALSE checked.

To push finished tasks to the bottom instead, click any cell in the Done column and choose Data > Sort A to Z. An ascending sort normally lists FALSE before TRUE, so open tasks should rise to the top and checked ones sink.

Remove the Boxes or Keep Only the Values

There are two ways back, and they do different things.

• Back to plain TRUE and FALSE: select the cells and choose Home > Clear > Clear Formats. Microsoft says this keeps the values. It also removes every other format on those cells, such as fill color and number formats, so reapply anything you need.
• Remove the boxes entirely: select the cells and press Delete. If every box was unchecked, they’re removed. If any were checked, Delete first unchecks them all; press Delete again to remove them.

Delete therefore throws away your TRUE values, so use Clear Formats if the data matters. Ctrl + Z undoes either one right away.

No Checkbox Button? Use the Developer Tab Check Box

Older Excel versions use form controls instead: small objects that float over the sheet and are linked to a cell. They work, but you set up each box by hand, so this route is best for short lists. Microsoft’s Insert check boxes page covers the Developer tab controls.

1. Show the Developer tab: on Windows, go to File > Options > Customize Ribbon and check Developer. On a Mac, see how to turn on the Developer tab in Excel for Mac.
2. Select Developer > Insert, and under Form Controls choose Check Box. (On a Mac, the Check Box button sits directly on the Developer tab.)
3. Click inside the cell next to your first TRUE/FALSE value (D2, say) to draw the box.
4. Right-click the box, choose Format Control, open the Control tab and set Cell link to the value cell, C2. Select OK. Microsoft’s Form controls page describes the Control tab and its Cell link box.
5. Right-click again, choose Edit Text and delete the “Check Box 1” label if you don’t want it.

The box now reads the linked cell: TRUE shows checked, FALSE shows empty, and clicking the box writes the new value back. A few things to know about this route:

• When you copy or drag a form control down, the copies usually keep pointing at the first cell. Check the Cell link on each one.
• Floating controls don’t always follow their row when you sort. In Format Control > Properties, choose Move and size with cells to help them stay put.
• Choose the Form Controls check box, not the ActiveX one. ActiveX controls are driven by VBA code, and they aren’t generally usable in Excel for Mac.
• Many older guides use a VBA macro to add hundreds of linked boxes at once. Microsoft doesn’t publish such a macro, and the newer Checkbox command makes it unnecessary, so it isn’t covered here.

When the Checkboxes Misbehave

• Checkbox isn’t on the Insert tab: your version or update probably doesn’t include it yet. Microsoft’s page lists only Excel for Microsoft 365 on Windows and Mac. Check File > Account for the product name, install updates, or use the Developer tab method.
• Some cells won’t tick properly: they hold text, numbers or formulas that return something other than TRUE or FALSE. Run the ISLOGICAL test and convert them.
• A formula column may not toggle: clicking a box changes the cell’s value, so a cell whose value comes from a formula generally can’t be flipped by hand without replacing the formula. Paste the results as values first if you want to click them.
• A Yes/No column turned into boxes unexpectedly: Excel may offer to convert Yes/No or TRUE/FALSE columns in a table to checkboxes. If you accepted by mistake, press Ctrl + Z or use Clear Formats. This prompt isn’t on Microsoft’s checkbox page, so it may not appear in every version.
• The workbook opens elsewhere without boxes: an Excel version without the feature may show only the TRUE and FALSE values underneath. Your data is still there.

Checkbox Follow-Ups

Can I check every box at once?

Select the range and press the Spacebar to toggle the selected boxes. To force them all to checked, type TRUE and press Ctrl + Enter, which fills every selected cell with TRUE. Since the checkbox is formatting on the value, the boxes should all show as checked. Typing FALSE the same way clears them.

Do the words TRUE and FALSE disappear?

Only from view. The cell shows a box, but click it and the formula bar still shows TRUE or FALSE. Formulas, filters and exports keep working with those values, and Clear Formats brings the words back on screen.

Will a coworker on Excel 2021 or the web see the boxes?

Microsoft’s checkbox page only lists Excel for Microsoft 365 on Windows and Mac, so there’s no promise for other versions. Whatever they see, the TRUE and FALSE values are stored in the cells, so their formulas and counts still work. If a shared workbook has to look the same for everyone, test it in their version before you rely on the boxes.

Do checkboxes work inside an Excel table?

They’re cell formatting on a value, so you can apply them to a column in a formatted table. Microsoft’s checkbox page doesn’t discuss tables, so check that new rows added to the table pick up the box. If one doesn’t, select it and choose Insert > Checkbox again.

Is there a non-clickable checkbox look for printed sheets?

Some sheets use a formula such as =IF(C2,"þ","¨") with the cell font set to Wingdings, which shows a ticked or empty box symbol. It looks right on paper but can’t be clicked; the real value still lives in column C.

What if I want people to pick from a list instead?

For more than two choices, such as Not started, In progress and Done, a checkbox is the wrong tool. Use Data Validation instead: here’s how to add a drop-down list in Excel.

Next Step

Make a copy of your sheet, run ISLOGICAL on one cell of the TRUE/FALSE column, and then try Insert > Checkbox on the copy. Once the boxes look right, add the COUNTIF progress formula so the sheet tells you how far along you are.