Symbols can often be more visually appealing than numbers or letters. It takes just a few clicks to insert a checkmark symbol into your Microsoft Excel spreadsheet.
While you can certainly use interactive checkboxes for things like creating a checklist in Microsoft Excel, you don’t always need that extra step or added work. Simply place a checkmark next or a completed task, completed order, or verified data.
How to Add a Check Mark Symbol in Excel
A check mark in Microsoft Excel is nothing but a sign ,, a character such as an equal sign or an arrow. You can also choose from several different styles of check marks thanks to the many font options.
Select cell in which you want to put the checkmark. Click the Insert tab and select “Symbol .”
There are several font styles that have check mark symbols. You can also enter the Character Codes in order to jump to them.
Make sure you are on the Symbols Tab and choose “Wingdings”, from the Font drop-down menu. Then, type “252” in the Character Code box. This is your first checkmark option!
If you look at the check mark style in two spaces to its right, you will see another. For reference, the Character Code is 254.
To see all that Segoe has to give, click on “Segoe UI Symbol” from the Font drop-down menu. Next, type the following codes in the Character Code box.
As soon as you have decided on the style of check mark you would like, click “Insert”, and then “Close.” A check mark will appear in the cell.
You can copy the check mark to other cells, use AutoFill, or access it again quickly later. You’ll find your Most Recently Used Symbols at bottom of the Symbols window if you reopen it. You can simply select the checkmark and hit “Insert .”
How To Edit or Remove A Check Mark
A checkmark is a symbol that has been inserted into a cell. You can edit it the same way as text. You can select it or the cell, and then use the Font or Alignment sections on the ribbon on your Home tab just like any other character.
You can alter the color, size and format of , as well as the alignment.
If necessary, you can delete a checkmark by selecting the item and clicking Delete.
Interested in doing something similar with Excel? Check out how to change the currency symbol you use in Excel.