See all How-To Articles

How to Insert a Check Mark / Tick in Excel & Google Sheets

This tutorial shows how to insert a check mark in Excel and Google Sheets.

 

InsertTick Wingdings Excel

 

Insert Check Mark

Excel offers several ways to insert check marks and other symbols. The first is to use the symbol feature.

  1. On the Ribbon, choose Insert > Symbols > Symbol.

 

symbols ribbon

 

  1. The Symbol field appears. You can resize the box if you want to see more symbols by dragging the lower right corner of the box.
  2. Change the font in the left drop-down box to Wingdings.

 

InsertTick Wingdings

 

  1. Scroll down until you find the checkmark icon and click Insert.

 

InsertTick Wingdings CheckMark

 

  1. Click Close and return to Excel.
    You can also change the font on Wingdings 2 and find the checkmark icon in that font.

 

InsertTick Wingdings2 Symbol

 

Wingdings and Alt Code

You can also insert a check mark in Excel by changing the font to Wingdings in the Excel screen and then typing the ü character directly into a cell. In the Ribbon, choose Start > Font, and then choose Wingdings from the Font drop-down box. Hold down the Alt key and type ALT + 0252.

 

InsertTick Wingdings Excel

 

The ü character is inserted into Excel. In the Wingdings font, this character is represented as a check mark.

Wingdings 2 Font

In the Ribbon, choose Start > Font, and then choose Wingdings 2 from the Font drop-down box.

 

InsertTick Wingdings2

 

In the selected cell, hold down the SHIFT key and press the letter P (capital P).

 

InsertTick Wingdings2 P

 

See also: How to Insert Cross Text Symbol.

Insert Check Mark Symbol in Google Sheets

Insert Check Marks With the CHAR Function

Insert check marks in Google Sheets by using the CHAR Function. Select the cell where you want to insert your check mark and enter the CHAR Function with the appropriate number (for example, 128504).

 

InsertTick char googlesheets

 

If you enter the numbers 10004 and 10003 using the DRAW Function, slightly different check mark formats will be displayed.

 

InsertTicks GoogleSheets charmultiple

 

Insert Special Characters

Google Sheets does not have a symbol function. Google Documents, on the other hand, does. If you want to insert symbols like the check mark into Google Sheets, open a Google document and copy and paste from that document into Google Sheets.

  1. From the File menu, choose New > Documents.

 

symbols insert google doc

 

A new tab opens in the browser, displaying a new Google document.

  1. From the Paste menu, choose Special Characters.

 

symbols insert google doc special characters

 

In the left drop-down box, you can select from a number of categories, such as Symbol, Emoji, Punctuation, etc.

 

symbols insert google doc list

 

  1. Select “Symbols” in the left drop-down box and then “Other” in the right box.

 

CrossText Googlsheet specialchar

 

  1. Click the checkmark icon to paste it into the Google document.
  2. Click the “Close” button to close the “Special characters” box.
  3. Select the symbol with the mouse and then press CTRL + C to copy the symbol.
  4. Switch back to the Google sheet and press CTRL + V to paste the symbol.

 

InsertTick-GoogleSheets-Tick