Categories
Check’ Insert

How to insert a check mark in Microsoft Excel

Many times, symbols can be better visuals than letters or numbers. If you want to insert a check mark symbol into your Microsoft Excel spreadsheet, it takes only a few clicks. 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…


Microsoft Excel logo on a green background

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.

RELATED: How to Insert a Checkbox in Microsoft Excel

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 .”

“.

Go to Insert, Symbols, 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!

Wingdings check mark in Excel

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.

Wingdings check mark in Excel

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.

Segoe UI Symbol check marks

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.

Check mark in Excel

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 .”

“.

Recently Used Symbols

RELATED: How to Fill Excel Cells Automatically with Flash Fill and Auto Fill

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.

Colored check marks in Excel

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.

Read More

Leave a Reply

Your email address will not be published.