How To Add Checkmark or CheckBox To Your Excel Sheet

Checkmark Excel

If you want to keep a checklist of all the work you need to complete or completed in Excel. In this guide, I will show you how to add a checkmark in the Excel sheet.

You can find two types of checkmark in your Excel Sheet:

One is in Checkbox while the other is Tick and Cross Symbol

How To Add Checkmark in Excel Using The Symbol Command
  1. Click on the cell where you want to insert a checkmark
  2. Select Insert Tab from the top menu and then click on Symbols
  3. In the Symbols dialog box Select the font as “Wingdings”, put the character code from 251-254.
  4. Click on Insert and close the dialog box

How To Add Checkmark By Typing The Character
  1. Click on the cell where you want to put a tick
  2. Right Click on that cell and select font as “Wingdings”
  3. Hold ALT Button beside your spacebar and type

Tick symbol               alt+0252

Tick in a box             alt+0254

Cross symbol            alt+0251

Cross in a box           alt+0253

Simple Copy-Paste Method

If you want to follow the above steps or unable to do it then simply copy and paste it from somewhere else in to excel cell. It can save you a lot of time because you are not using any code or formula here.

You can copy paste from here also ✓ . You can also search it on google.

Create an AutoCorrect To Convert it to a Checkmark

In Excel, there is a feature of Autocorrect, so if you start your sentence with small case alphabet it will automatically convert it into uppercase. You can predefine certain auto-correct word too.

  1. Go to File tab and open the Excel option
  2. After that navigate to proofing and open autocorrect
  3. Now in this dialog box, in the “Replace” box, enter the word you want to type for which Excel will return a check mark symbol
  4. Then, in the “With:” enter the check mark which you can copy from above.
  5. Click ok

Checkout More Guide’s on Excel:

How To Lock Specific Cells And Password Encrypt In Excel

How To Delete All Hidden Rows And Columns In MS EXCEL

Leave a Reply

Your email address will not be published. Required fields are marked *