As Seen on TechCrunch: Finofo Raises $1.65M CAD!

Excel Guide

How to Make a Check Mark in Excel: Step-by-Step Guide

If you need to insert a check mark into a cell in Microsoft Excel, you can follow these step-by-step instructions. There are multiple methods, and you can choose the one that suits you best.

Method 1: Using the Symbol Dialog Box

  1. Select the cell where you want to insert the check mark.
  2. Go to the "Insert" tab.
  3. Click on the "Symbol" button.
  4. In the Symbol dialog box, choose the "Symbols" tab.
  5. Scroll down and select the check mark symbol (U+2714).
  6. Click "Insert" and then "Close."

Method 2: Using the Character Code

  1. Select the cell where you want to insert the check mark.
  2. Go to the "Insert" tab.
  3. Click on the "Symbol" button.
  4. In the Symbol dialog box, choose the "Symbols" tab.
  5. Click the "Special Characters" tab.
  6. In the "Character code" field, type 2714.
  7. Click "Insert" and then "Close."

Method 3: Using a Macro

  1. Open the workbook and go to the "View" tab.
  2. Click on "Macros" and then "Create."
  3. In the Macro name field, type a name (e.g., InsertCheckMark).
  4. Click "OK" to open the Visual Basic Editor.
  5. In the Editor, type the following code:
  6. vbaCopy code
  7. Sub InsertCheckMark()
    ActiveCell.Value = ChrW(&H2714)
    End Sub
  8. Click "File" > "Save."
  9. To run the macro, select the cell and press Alt+F8. Choose the macro and click "Run."

Method 4: Using the Wingdings Font

  1. Select the cell where you want to insert the check mark.
  2. Go to the "Home" tab.
  3. In the "Font" group, select "Wingdings" from the font list.
  4. Press Alt+0252.

Method 5: Inserting a Check Mark from the Symbol Library (Office 365)

  1. Select the cell where you want to insert the check mark.
  2. Go to the "Insert" tab.
  3. Click on the "Symbol" button.
  4. In the Symbol dialog box, choose the "Symbols" tab.
  5. Click "More Symbols."
  6. In the Symbol Library tab, select "dingbats."
  7. Choose the check mark symbol and click "Insert."

These methods offer flexibility depending on your preferences and the frequency of inserting check marks in your Excel sheets.