How to add check mark in a cell with double clicking in Excel?
Typically, adding a check mark symbol to a cell in Excel involves navigating to the Symbol dialog, searching among a wide array of symbols, and manually inserting the check mark—the process can be time-consuming and a bit tedious, especially if you need to insert check marks repeatedly or across many cells. Locating the correct symbol among the numerous available can add to the complexity. To streamline this task and save time, there are several alternatives that allow you to add check marks more efficiently, whether through automation or using built-in Excel features.
In this article, you will learn how to quickly insert check marks into Excel cells, focusing on a VBA solution that enables one-click entry through double-clicking a cell. Additional alternative methods are also included for scenarios where VBA is unavailable or when you need to visually indicate completion or status with check marks through formulas or conditional formatting.
Double click to add check mark in a cell with VBA code
Excel Formula - Insert check mark using Wingdings font
Other Built-in Excel Methods - Insert check marks with Conditional Formatting (Icon Sets)
Double click to add check mark in a cell with VBA code
Using VBA is a flexible and practical way to enhance Excel’s interactivity. The method below allows you to insert or remove a check mark simply by double-clicking a cell within a specific range. This approach is especially useful if you want to quickly toggle a check status, such as in task lists or attendance sheets, without the need to manually insert symbols each time.
Here’s how you can apply the VBA solution:
1. Open the worksheet where you want to use double-clicking to insert check marks. Right-click the sheet tab at the bottom and select View Code from the menu that appears.
2. In the Microsoft Visual Basic for Applications editor window, copy and paste the following VBA code into the opened Code window.
VBA code: Double click to add check mark in a cell
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Not Intersect(Target, Me.Range("B1:B10")) Is Nothing Then
Application.EnableEvents = False
Cancel = True
With Target
If .Value = ChrW(&H2713) Then
.ClearContents
Else
.Value = ChrW(&H2713)
End If
End With
Application.EnableEvents = True
End If
End SubNote: By default, this code targets the range B1:B10. If you want to apply this feature to a different cell range, please modify B1:B10 in the code accordingly. Also, ensure that worksheet protection settings allow for editing these cells, otherwise double-clicking may not trigger the macro.
3. Press Alt + Q to close the Microsoft Visual Basic for Applications window and return to your Excel worksheet.
Now, whenever you double-click a cell within B1:B10, the check mark will be inserted automatically. Double-clicking again will remove the check mark. This toggle feature can make managing lists of completed items, attendance tracking, or any visual checklist more efficient and intuitive in your workbook.
Tip: If you want the check mark to visually stand out or match other formatting, you may adjust the font size or color of the target cells. If you encounter any issues, double-check that your macro settings allow the code to run and that you are double-clicking within the specified range.
Limitations: You must enable macros, and in some office environments, macros may be disabled for security reasons.
If you need to frequently use the check marks in your Excel daily work, here I recommend the Auto Text Utility of Kutools for Excel. With this feature, you can save a check mark as an auto text entry, and then reuse it in the future with only one click in Excel as the below demo shows.
Download and try it now! (30-day free trial)
Excel Formula - Insert check mark using Wingdings font
Another practical way to dynamically display check marks in Excel is by using an Excel formula together with the Wingdings font. This method is particularly valuable when you want the check mark to appear automatically based on the value of a related cell—such as marking tasks as complete, indicating status, or creating visually clear dashboards—without using VBA or enabling macros.
With this approach, you can leverage logical expressions (like comparing a value to TRUE, “Yes”, or numeric values) and have a check mark or empty cell display accordingly. It is easy to implement, does not require enabling macros, and works well for both individual and multiple cells.
Pros: Lightweight, no macros needed, compatible with .xlsx files, and ideal for dashboards or reports that track completion.
Cons: Requires cell formatting; result is font-dependent for the check mark display.
Instructions:
- Flexible for any cell or status (simply adjust the reference cell and condition as needed).
- Be aware that the check mark character (“ü”) appears as a check mark only if the Wingdings font is applied to the target cell.
1. Select the cell where you want the check mark to appear (for example, B1) and enter the following formula:
=IF(A1=TRUE, "ü", "")2. After entering the formula, apply the Wingdings font to cell B1. You can do this by clicking the cell, going to the Home tab, and selecting "Wingdings" from the font dropdown list. When A1 is TRUE, a check mark will display in B1.
3. If you need to quickly copy the formula to other rows, drag the fill handle from the lower-right corner of B1 down to cover the desired range. Adjust the logical condition in the formula (e.g., A1="Yes" or A1=1) to suit your specific use case.
Tip: The character “ü” (lowercase "u" with an umlaut) is specifically mapped to the check mark symbol in the Wingdings font. If you use a different font, it will appear as a normal letter, so always check the font after pasting the formula. You can also use similar logic to show different symbols for other conditions.
Potential issues: This solution is visual and intended for presentation purposes. If your spreadsheet is frequently printed or shared with users who may not have the standard Wingdings font installed, the check mark may not display as intended.
Other Built-in Excel Methods - Insert check marks with Conditional Formatting (Icon Sets)
Conditional Formatting with icon sets provides a visual way to insert check marks—or other status icons—based on cell values or conditions, all without formulas or macros. This built-in feature is particularly useful for reviewing progress, marking tasks, or displaying results visually across a range, making data interpretation easier at a glance.
Advantages: No need for manual input or complex formulas; visually attractive and adaptable for dashboards or reports; easily applied across many rows/columns.
Limitations: Icon placement is fixed to the left of the cell and cannot be merged with text content in the same cell. Customization of icons is limited to those available in Excel’s built-in sets.
Usage scenario: Ideal for tracking tasks, progress updates, or for conditional status displays where a check mark icon (✔) is needed.
Steps:
- Prepare or select the value cells that will trigger the check mark (e.g., cells in B1:B10 with “Completed”, TRUE, or1).
- Select the target range (e.g., B1:B10).
- Go to the Home tab, click Conditional Formatting > Icon Sets > choose a set that includes a check mark (for example, "Symbols" or "3 Symbols (Circled)").
- Customize: Go back to Conditional Formatting > Manage Rules, select your rule, and click Edit Rule. You can adjust the criteria to display the check mark only for your desired values (e.g., when the value is equal to 1 or “Completed”). Set the other icon values and, if necessary, choose to “Show Icon Only” to hide the underlying value and display just the icon.
- Click OK to apply the rule.
Tip: You can combine icon sets with additional formatting, such as coloring the row when checked, to improve readability. For advanced usage, you might prepare helper columns with logical output (e.g., 1 for complete, 0 for incomplete) to support the icon set logic.
Troubleshooting: If a check mark does not appear as expected, ensure the value or condition matches your rule settings. Also, note that icon sets work only with numeric-based or certain text-based thresholds.
When choosing the best approach for displaying check marks in Excel, consider your specific needs: VBA solutions offer interactivity for toggling status; formulas with Wingdings offer dynamic symbol display in a macro-free environment; and Conditional Formatting with icon sets allows for visually appealing, data-driven results. If working in a shared or protected workbook where macros or font changes are impractical, icon sets or formula-based solutions are generally more compatible.
- If you encounter issues with VBA not running, make sure macros are enabled, the workbook is saved as .xlsm, and cell protection is not interfering.
- With formula-based options, always check that the font is correctly set to Wingdings for the check mark symbol to display as intended.
- When using conditional formatting, regularly review rule settings if icon behavior is unexpected, especially after copying or rearranging data.
By using these methods, you can efficiently add check marks to your Excel sheets to visually track progress, indicate completion, or create interactive checklists according to your workflow preferences and workbook limitations.
Related articles:
- How to double click a cell and add1 to that cell value in Excel?
- How to auto add/enter current date/time in a cell with double clicking in Excel?
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
All Kutools add-ins. One installer
Kutools for Office suite bundles add-ins for Excel, Word, Outlook & PowerPoint plus Office Tab Pro, which is ideal for teams working across Office apps.
- All-in-one suite — Excel, Word, Outlook & PowerPoint add-ins + Office Tab Pro
- One installer, one license — set up in minutes (MSI-ready)
- Works better together — streamlined productivity across Office apps
- 30-day full-featured trial — no registration, no credit card
- Best value — save vs buying individual add-in