Add Check Marks to Cells by Double-Clicking or Typing

Input a check mark into a cell in Excel by double-clicking the cell or by typing a letter into it.

This tutorial shows you two ways to input the check mark because you might want to use the mouse to input or remove the check mark or quickly key through a list and type a sinlge letter to input the check mark.

There are many ways to perform this trick in Excel, but, here, I will show you one of the easier ways to do it, which combines a custom font and a macro.

Custom Font

Font to use: Marlett

Letter to input to make the check-mark: a

Macro for the Double-Click

Right-click the sheet where you want to have this trick work and click View Code and paste the code from here.

B3:B6 change this to the range of cells that should be able to get a check mark when they are double-clicked.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
' Add/Remove a Check Mark from a Cell
'
' Made by: https://www.TeachExcel.com
'
' Excel Courses: https://www.teachexcel.com/premium-courses/?src=tut_id_2444
 
    If Not Intersect(Target, Range("B3:B6")) Is Nothing Then
    
        Target.Font.Name = "Marlett"
    
        If Target.Value = "a" Then
            
            Target.Value = ""
            
        Else
        
            Target.Value = "a"
        
        End If
        
        Cancel = True
    
    End If
    
End Sub

Additional Resources

Microsoft Doc to Insert a check mark symbol

Worksheet.BeforeDoubleClick event (Excel)