In this Excel tutorial, you will learn how to insert the check mark symbol in Excel.
The check emoji is the one you would like to add to your spreadsheet. There are a few ways to insert the check mark symbol into your spreadsheet.
Adding a Check Mark Symbol
This method involves using the Symbol dialog box to insert the check mark symbol into a cell in your spreadsheet. This is a good option if you only need to insert a few check marks in your spreadsheet and you prefer to use the mouse to select the symbol.
Navigate to the Insert tab on the ribbon. Click the Symbol button.
There are plenty of symbols. Change Font to Wingdings2 (or Marlett). Here you can find two different check symbols: check mark and the box check mark. You will find these checks in the third row.
If you're not sure which font to use, you can scroll through the list of symbols until you find the check mark symbol, or you can search for it using the search box.
The character codes for them are 82 and 84.
There is also a possibility to insert a bold check mark and a bold box check mark. To insert one of these, change the font to Wingdings and scroll down to the last row.
The character codes for them are 252 and 254.
Using an Excel Font
You can just insert check mark symbols using a Font. Just change it to Wingdings2 and type uppercase P (SHIFT + P) for the check mark and uppercase R (SHIFT + R) for the box check mark.
Enter a character code
You can also insert check mark symbols in Excel by using the Character Map Windows application or character code. Just open the Character Map, change the Font to Wingdings, find the check symbols, and copy them. Then you can paste them into your Excel spreadsheet.
Character codes for check marks are: 0xFC for check mark and 0xfE for box check mark.
Using the Keyboard Shortcut
This method involves using a keyboard shortcut to insert the check mark symbol into a cell in your spreadsheet. This is a good option if you need to insert a lot of check marks in your spreadsheet and you prefer to use the keyboard.
- Select the cell where you want to insert the check mark symbol.
- Press the keyboard shortcut ALT + 0252. The check mark symbol will be inserted in the selected cell.
Note: The keyboard shortcut method may not work on all keyboards and operating systems, so it's best to check if your keyboard supports it.
This method involves using Autocorrect to automatically replace a keyword with the check mark symbol in your spreadsheet. This is a good option if you need to insert a lot of check marks in your spreadsheet and you prefer to type a keyword instead of using the mouse or keyboard shortcut.
- Go to the File tab and select Options.
- In the Excel Options dialog box, select the Proofing option.
- Click on the AutoCorrect Options button.
- In the AutoCorrect dialog box, enter a keyword for the check mark symbol in the Replace field (e.g., "check").
- Enter the check mark symbol in the With field (using the Symbol dialog box method described above).
- Click the Add button and then the OK button to close the AutoCorrect dialog box.
- Now, whenever you type the keyword you entered (e.g., "check"), it will be automatically replaced with the check mark symbol.
Now you can tick the value in the cell to make your spreadsheet easier to read and notice things.
In conclusion, there are several methods to insert a check mark symbol in Microsoft Excel, including using the Symbol dialog box, using a keyboard shortcut, and using Autocorrect. Choose the method that works best for you, depending on the type of data you are working with and your personal preferences.