Latest Video Tutorial – 10 Excel Keyboard Shortcuts (Probably YOU are NOT Using)
A check mark is commonly used in Excel to indicate whether the task is completed or not. Users can insert the check mark symbol in Excel instead of entering “Yes” to indicate the tasks done or completed from the given list.
There are multiple ways to insert a check mark but the best way to insert the check mark is using the keyboard shortcut.
Shortcut Key to Check Mark in the Excel
Alt + 0 ⇢ 2 ⇢ 5 ⇢ 2
Shift + P
Steps to Enter a Check Mark using a Keyboard Shortcut
- First, go to the cell where you want to insert the check mark symbol.
- After that, go to the Home tab, and under the Font group, change the font style to Wingdings font.
- Now, press and hold the Alt key and press the 0 > 2 > 5 > 2, and then release the Alt.
- Or, go to the cell and simply press the Shift + P keys, and after that go to the Font group and select font style Wingdings 2.
- At this point, you will get the check mark symbol inserted into the cell.
Points to Remember
- To insert a check mark, the font style of the cell should be selected as Wingdings if you are going to use Alt + 0 > 2 > 5 > 2.
- If you are going to use the Shift +P shortcut option then the font should be Wingdings 2.
- Either by using manual or shortcut keys, check marks can only be inserted into one cell at a time.
- You can also apply the check mark shortcut first and then change the Font style.
- If you want to insert the check mark symbol in other cells, just copy and paste and it will get pasted.