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.
Font to use: Marlett
Letter to input to make the check-mark: a
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