How to Convert TRUE/FALSE to Checkboxes in Excel

If you have a column filled with TRUE and FALSE values (such as survey results or logical formulas), you may want to convert them into interactive checkboxes—where TRUE appears as checked and FALSE as unchecked.

This tutorial introduces three practical methods, from basic formatting tricks to advanced automation, including a much faster solution using Kutools for Excel.

• Convert TRUE/FALSE to Checkbox Symbols (Formula Method)
• Convert true false to checkbox controls with VBA
• Convert true false to checkbox controls with an amazing tool

Convert TRUE/FALSE to Checkbox Symbols (Formula Method)

In many Excel worksheets, TRUE and FALSE values are often generated by formulas, such as logical comparisons (e.g., comparing two columns) or conditional calculations.

Instead of displaying these results as plain text, you may want to present them as checkbox-style marks for better visualization. For example, when the value in one column is greater than another, Excel returns TRUE; otherwise, it returns FALSE. See screenshots below.

In this method, we will show how to convert TRUE and FALSE into checkbox symbols using a simple formula.

Step 1: Replace TRUE/FALSE with symbols

Modify your original formula like this:

=IF(B3>C3,"þ","¨")

Then drag the formula down to apply it to other cells.

Step 2: Change font to Wingdings

1. Select the formula cells.
2. Right-click and select Format Cells in the context menu.

   

3. In the Format Cells dialog box, go to the Font tab, choose Wingdings from the Font list, and then click OK.

   

Result

The symbol þ is displayed as a checked box, while ¨ appears as an unchecked box. The symbols will update automatically if the formula result changes.

Limitations

• Not interactive (cannot click to toggle)
  The symbols are static characters, not real checkboxes. You cannot click them to switch between checked and unchecked states.
• Only visual symbols, not real form controls
  These symbols do not have any built-in functionality. They cannot be linked to cells, used in formulas, or trigger any actions.
• Limited compatibility and flexibility
  The display relies on the Wingdings font. If the font is changed or not supported, the symbols may not appear correctly.

Convert true false to checkbox controls with VBA

This method uses VBA to insert actual checkbox controls and link them to their corresponding cells. Unlike symbol-based solutions, these checkboxes are fully interactive—you can click to toggle their state, and the linked cells will automatically update between TRUE and FALSE.

While this approach provides powerful functionality, it requires writing and running VBA code, which may be time-consuming and difficult for non-technical users. If you are looking for a quicker and easier solution, you can try the Kutools method introduced below.

Steps

1. Select the range containing TRUE/FALSE.
2. Press Alt + F11 to open VBA editor.
3. Click Insert > Module.
4. Paste the code below:
   VBA: Convert TRUE and FALSE to checkbox controls in Excel

   Sub ConvertTrueFalseToCheckbox()
   Dim xCB As CheckBox
   Dim xRg, xCell As Range
   Application.ScreenUpdating = False
   On Error Resume Next
   Set xRg = Selection
   For Each xCB In ActiveSheet.CheckBoxes
   xCB.Delete
   Next
   For Each xCell In xRg
   If (UCase(xCell.Value) = "TRUE") Or (UCase(xCell.Value) = "FALSE") Then
   Set xCB = ActiveSheet.CheckBoxes.Add(xCell.Left, xCell.Top, cDblCheckboxWidth, xCell.Height)
   xCB.Value = xCell.Value
   xCB.LinkedCell = xCell.Address
   xCB.Text = ""
   End If
   Next
   Application.ScreenUpdating = True
   End Sub

5. Press F5 to run the code.

Result

TRUE values are displayed as checked checkboxes, while FALSE values are displayed as unchecked checkboxes. When you click a checkbox, the linked cell is automatically updated to reflect the new TRUE or FALSE value.

Limitations

• Requires VBA knowledge.
• Needs macro-enabled workbook (.xlsm).
• Not user-friendly for non-technical users.
• Hard to manage in large datasets.

Convert TRUE/FALSE to Checkboxes with Kutools (Recommended)

If you are looking for a fast, reliable, and user-friendly solution, Kutools for Excel provides a powerful feature called Batch Insert Smart Checkboxes.

With this feature, you can quickly insert real checkbox controls in bulk and automatically link each checkbox to its corresponding cell—no formulas or VBA required. The checkbox state will instantly reflect the existing TRUE or FALSE values, and any changes made by clicking the checkbox will update the linked cell automatically.

This makes it an ideal solution for handling large datasets, creating interactive worksheets, and saving significant time compared to manual or code-based methods.

Steps

1. Select the range containing TRUE/FALSE values.
2. Select Kutools > Insert > Batch Insert Smart Checkboxes.

   

3. In the Batch Insert Smart Checkboxes dialog box:
   1. Select Insert checkboxes and link to their own cells.
   2. Check Use cell content as checkbox label.
   3. Click OK.

      

Result

TRUE values are automatically converted into checked checkboxes, while FALSE values are displayed as unchecked checkboxes. Each inserted checkbox is linked to its corresponding cell by default, ensuring a seamless connection between the checkbox state and the cell value. When you click a checkbox, the linked cell is instantly updated to TRUE or FALSE, enabling smooth two-way interaction.

Why this method stands out

• Batch insert checkboxes in seconds.
• Automatically links each checkbox to its cell.
• TRUE/FALSE instantly controls checkbox state.
• No VBA, no formulas, no manual adjustment.
• Works perfectly with large datasets.

Conclusion

• Use the formula method for simple visual representation.
• Use VBA for advanced control and automation.
• Use Kutools for Excel for a fast, effortless, and fully automated solution.

Compared to formulas and VBA, Kutools offers a much simpler workflow—allowing you to insert and link checkboxes in bulk within seconds. It is the most efficient choice for managing TRUE/FALSE data in practical scenarios.

Related articles:

How Create Yes or No checkboxes in Excel
If you need to create a list of Yes/No checkboxes and make them mutually exclusive to each other, a method in this article can help you.

Hide the True/False words within cell when linked to checkbox in Excel
After linking checkboxes to cells, you can see the words TRUE or FALSE displaying in the linked cells while checking or unchecking the check boxes as below screenshot shown. If you want to hide these displayed words, please try the method in this article.

Make checkbox checked based on cell value in Excel
You may know how to change a cell value based on a checkbox. But, do you know how to make a checkbox checked automatically based on a cell value in Excel? This article will show you methods to achieve it.

Delete multiple checkboxes in Excel
Maybe you have a worksheet with a lot of checkboxes, and now you want to delete them. Except for removing them one by one manually, are there any fast ways to delete them?