If you are using Microsoft Excel regularly, you might come across the need to insert a check mark symbol for various purposes. It may be for marking completed tasks or indicating the correctness of the document. Instead of inserting the symbol manually every time, Excel offers a shortcut to do it quickly. In this article, we will discuss the various ways to insert a check mark symbol in Excel using shortcuts.
Option 1: Using Keyboard Shortcut
The easiest and quickest way to insert a check mark symbol in Excel is by using a keyboard shortcut. Follow the steps below:
- Select the cell where you want to insert the check mark symbol.
- Press the following keys together: Alt + 0252. (Note: Make sure to use the numeric keypad for entering the numbers).
- The check mark symbol will now appear in the cell.
Option 2: Using Symbol Command
Another way to insert a check mark symbol in Excel is by using the Symbol command. Follow the steps below:
- Select the cell where you want to insert the check mark symbol.
- Go to the Insert tab in the ribbon menu.
- Click on the Symbol button in the Symbols group.
- Select the check mark symbol from the list of symbols.
- Click on the Insert button.
Option 3: Using Wingdings Font
Another way to insert a check mark symbol in Excel is by using the Wingdings font. Follow the steps below:
- Select the cell where you want to insert the check mark symbol.
- Change the font to Wingdings from the Home tab in the ribbon menu.
- Press the letter “P” on your keyboard. (Note: The letter “P” is the check mark symbol in Wingdings font).
- The check mark symbol will now appear in the cell.
Option 4: Using AutoCorrect Feature
If you frequently use the check mark symbol in your Excel worksheets, you can set up an AutoCorrect feature to insert the symbol automatically. Follow the steps below:
- Select the cell where you want to insert the check mark symbol.
- Type “tick” or “check” in the cell.
- Press the spacebar or Enter key.
- The word “tick” or “check” will be replaced with the check mark symbol.
Option 5: Using Custom Number Format
You can also use a custom number format to insert a check mark symbol in Excel. Follow the steps below:
- Select the cell where you want to insert the check mark symbol.
- Go to the Home tab in the ribbon menu.
- Click on the Number Format button in the Number group.
- Select Custom from the list of categories.
- In the Type field, enter the following custom number format: “;;\✔”
- The check mark symbol will now appear in the cell.
Conclusion
Inserting a check mark symbol in Excel is a simple task, and there are multiple ways to do it using shortcuts. You can use any of the above methods that suit your preference and convenience. By using these shortcuts, you can save time and complete your work efficiently.
