The tick (✓) also known as checkmark is often used to indicate the correct answer.
Insert a tick in Excel
The most popular way to insert a tick symbol in Excel is:
- Click a cell where you want to insert the symbol.
- Navigate to Insert >> Sybols >> Symbol.
- On the Symbols tab, inside Font type: Wingdings.
- Move to the end of the list, and select the tick symbol and click Insert.
There are two types of checkmark symbols. You can use any of them. The cross mark is often used next to a checkmark, so you can insert them as well. After you place them, it’s a good idea to change their colors, as you do with any other characters.
Insert a tick and assign it to a keyboard shortcut
Now, instead of using all these steps, we are going to create a macro and assign it to a keyboard shortcut.
Click the button in the bottom-left corner to start recording a macro.
From a new window, type a name for the macro.
Under Shortcut Key, inside small box use Shift + T. Now you will be able to use this macro with the Ctrl + Shift + T keyboard shortcut.
Now, Excel is going to save your every move.
Change font color to green and navigate to Home >> Font and choose the Wingdings font.
It’s necessary to do this step, otherwise, Excel will insert different type of character.
Move to Insert >> Symbols >> Symbol, and choose from Wingdings font the tick characters as you did before.
Click the Home tab, and change color to green and press Ctrl + Enter to stay inside the cell.
You can check your macro in View >> Macros >> Macros.
Your code should be similar to this.
Sub Tick() ' ' Tick Macro ' ' Keyboard Shortcut: Ctrl+Shift+T ' With Selection.Font .ThemeColor = xlThemeColorAccent6 .TintAndShade = -0.249977111117893 End With With Selection.Font .Name = "Wingdings" .Size = 11 .Strikethrough = False .Superscript = False .Subscript = False .OutlineFont = False .Shadow = False .Underline = xlUnderlineStyleNone .ThemeColor = xlThemeColorAccent6 .TintAndShade = -0.249977111117893 .ThemeFont = xlThemeFontNone End With Selection.FormulaR1C1 = "ü" End Sub
Excel usually ads a lot of unnecessary code. You can remove it, so it will look like this.
Sub Tick() With Selection.Font .Name = "Wingdings" .ThemeColor = xlThemeColorAccent6 End With ActiveCell.FormulaR1C1 = "ü" End Sub
Now, you can just use Ctrl + Shift + T (or any other shortcut) to insert the green tick symbol.