Shortcut to insert tick mark(check mark) symbol in excel

The following macro will allow you to automatically insert a check mark into the active cell with a keyboard shortcut.

Open your workbook.

Copy this macro to the clipboard:

Sub InsertCheckMark()
ActiveCell.Font.Name = "Wingdings"
ActiveCell.Font.Size = 11
ActiveCell.FormulaR1C1 = "ü"
ActiveCell.HorizontalAlignment = xlCenter
End Sub

Next, press alt+q


Now Go to View(2007 users)> Macro > View Macros

Highlight this macro, if it is not already highlighted.

Click: 'Options' (bottom right)

Select a letter to be used as a keyboard shortcut.

Close back to Excel.

Click in a cell, press CTRL + your shortcut letter and a check mark will be entered in the cell.