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

Excel Guide

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

If you’re working with a spreadsheet in Microsoft Excel, there may be times when you want to insert a checkmark. Maybe you’re tracking items that have been completed, or need to indicate “yes” or “no” answers to questions. Whatever the case, it’s easy to put a checkmark into a cell in Excel.

The Check Mark Symbol in Excel

The check mark symbol (✓) is a special character that is commonly used in spreadsheets and other digital documents, such as word processing files. If you’re using Microsoft Excel, you can insert this character by using the Symbol dialog box, which contains most of the common symbols used in Excel.

  1. Open the Symbol Dialog Box:
  2. Click the “Insert” tab on the Ribbon.
  3. Click “Symbol.”
  4. In the Symbol dialog box, select “Symbol” from the Font drop-down list.
  5. Scroll down to find the check mark symbol.
  6. Click “Insert” to insert the checkmark into the cell.

How to Insert a Check Mark with a Keyboard Shortcut

If you find yourself inserting checkmarks regularly, creating a keyboard shortcut can be more efficient than opening the Symbol dialog each time.

  1. Add the Developer Tab:
  2. Open the “File” menu and click “Options.”
  3. In the “Excel Options” dialog box, select “Customize Ribbon.”
  4. Check the “Developer” tab and click “OK.”
  5. Create a Macro:
  6. Go to the “Developer” tab and click “Macros” in the “Code” group.
  7. In the “Macros” dialog, select “All Open Workbooks” and click “Create.”
  8. In the VBA editor, type the code:
  9. vbaCopy code
  10. Sub InsertCheckMark()
      ActiveCell.Value = ChrW(&H2713)
    End Sub
  11. Close the VBA editor.
  12. Assign a Keyboard Shortcut:
  13. In the “Macros” dialog, select the macro you created.
  14. Click “Options” and assign a shortcut (e.g., Alt+C).
  15. Click “OK” and close the dialog.

Now, pressing your assigned shortcut will insert a checkmark into the active cell.

How to Put a Check Mark with the Wingdings Font

The Wingdings font includes a check mark symbol that you can easily insert into a cell.

  1. Select the Cell:
  2. Click on the cell where you want to insert the checkmark.
  3. Change to Wingdings Font:
  4. Go to the “Home” tab on the Ribbon.
  5. In the “Font” group, select “Wingdings.”
  6. Type the Check Mark:
  7. Type the letter “a” into the cell to insert the checkmark.

How to Change the Color of the Check Mark

You can change the color of the checkmark to suit your preferences.

  1. Select the Cell:
  2. Click on the cell containing the checkmark.
  3. Change Font Color:
  4. Go to the “Home” tab on the Ribbon.
  5. In the “Font” group, click the “Font Color” drop-down list.
  6. Select the desired color.

How to Remove a Check Mark

If you want to remove a checkmark from a cell:

  1. Select the Cell:
  2. Click on the cell containing the checkmark.
  3. Press Delete:
  4. Press the “Delete” key on your keyboard to remove the checkmark.

How to Insert a Check Mark in a Header or Footer

You can also insert a checkmark into a header or footer in your Excel spreadsheet.

  1. Access Header & Footer:
  2. Go to the “Insert” tab on the Ribbon.
  3. Click “Header & Footer.”
  4. Insert Check Mark:
  5. In the “Header & Footer Elements” section, choose “Field.”
  6. In the “Field Codes” dialog, select “Symbol” from the “Category.”
  7. Choose the check mark symbol and click “Insert.”

Now, the checkmark is inserted into your header or footer.

How to Insert a Check Mark with an Equation

You can use an equation to insert a checkmark into a cell.

  1. Select the Cell:
  2. Click on the cell where you want to insert the checkmark.
  3. Insert Equation:
  4. Go to the “Insert” tab on the Ribbon.
  5. Click “Equation.”
  6. Insert Symbol:
  7. In the “Equation Tools” Ribbon, click “Symbols.”
  8. Choose the check mark symbol from the “Symbols” dialog.

How to Insert a Check Mark with an ASCII Code

Using an ASCII code is another method to insert a checkmark.

  1. Select the Cell:
  2. Click on the cell where you want to insert the checkmark.
  3. Insert Symbol:
  4. Go to the “Insert” tab on the Ribbon.
  5. Click “Symbol” and then “More Symbols.”
  6. Choose “Unicode (Hex)” from the “From” drop-down list.
  7. In the “Character Code” text box, type ✓ and click “Insert.”

How to Insert a Check Mark with a Character Code

You can use the character code ✓ to insert a checkmark.

  1. Select the Cell:
  2. Click on the cell where you want to insert the checkmark.
  3. Insert Symbol:
  4. Go to the “Insert” tab on the Ribbon.
  5. Click “Symbol” and then “More Symbols.”
  6. Choose “Unicode (Hex)” from the “From” drop-down list.
  7. In the “Character Code” text box, type ✓ and click “Insert.”

How to Insert a Check Mark with a Character Map

The Character Map tool can also be used to insert a checkmark.

  1. Open Character Map:
  2. Click the “Start” button and type “character map” into the search field.
  3. Open “Character Map.”
  4. Select Wingdings Font:
  5. Choose “Wingdings” from the “Font” drop-down list.
  6. Insert Check Mark:
  7. Scroll down and find the check mark symbol.
  8. Click “Select” to insert it into the cell.

How to Insert a Check Mark with a Word Processor

If you’re using a word processor like Microsoft Word, you can insert a checkmark into a document.

  1. Access Symbol Dialog:
  2. Open the “Insert” menu and click “Symbol.”
  3. Insert Check Mark:
  4. In the “Symbol” dialog, select “Symbol” from the “Font” drop-down list.
  5. Choose the check mark symbol and click “Insert.”

Now you know various methods to insert, customize, and remove checkmarks in Excel, making it easier to communicate and visualize information in your spreadsheets.