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

Excel Guide

How to Insert a Check Mark in Excel

If you've ever needed to insert a check mark into a cell in Microsoft Excel, you might have discovered that there's no direct built-in symbol for it. However, there are several workarounds to achieve this. Here are various methods you can use to insert a check mark into your Excel spreadsheet:

Option 1: Use the Wingdings Font

  1. Select the cell or cells where you want to insert the check mark.
  2. Click the Home tab on the ribbon.
  3. In the Font group, click the Font drop-down arrow.
  4. Choose Wingdings from the list of fonts.
  5. Locate and click the check mark symbol (resembling a lowercase P with a check mark).
  6. The check mark will appear in the selected cell or cells.

Option 2: Use the Webdings Font

  1. Select the cell or cells where you want to insert the check mark.
  2. Click the Home tab on the ribbon.
  3. In the Font group, click the Font drop-down arrow.
  4. Choose Webdings from the list of fonts.
  5. Locate and click the check mark symbol (resembling a lowercase P with a check mark).
  6. The check mark will appear in the selected cell or cells.

Option 3: Use a Character Code

  1. Select the cell or cells where you want to insert the check mark.
  2. Click the Home tab on the ribbon.
  3. In the Font group, click More Symbols.
  4. In the Symbols tab, find the check mark symbol.
  5. Click the check mark symbol, then click Insert and Close.
  6. The check mark will now appear in the selected cell or cells.

Option 4: Use the Unicode Character

  1. Select the cell or cells where you want to insert the check mark.
  2. Press Alt+X on your keyboard.
  3. Enter the Unicode character code for the check mark (e.g., 2713).
  4. The check mark will appear in the cell.

Option 5: Use an Image

  1. Select the cell or cells where you want to insert the check mark.
  2. Click the Insert tab on the ribbon.
  3. Click the Picture button in the Illustrations group.
  4. Locate the image of the check mark on your computer and click Insert.
  5. The image of the check mark will appear in the selected cell or cells.

Option 6: Use a Symbol

  1. Select the cell or cells where you want to insert the check mark.
  2. Click the Insert tab on the ribbon.
  3. Click the Symbol button in the Symbols group.
  4. Click More Symbols.
  5. In the Symbols tab, find the check mark symbol.
  6. Click the check mark symbol, then click Insert and Close.
  7. The check mark will now appear in the selected cell or cells.

Additional Tips

  • You can use these methods to insert a check mark into a header or footer by clicking the Insert tab, selecting the Header or Footer button, and then choosing Edit Header or Edit Footer.
  • To insert multiple check marks into a cell, select the cell and press F9 on your keyboard, then press Enter.
  • You can use the CHAR function or UNICHAR function to insert a check mark based on character codes or Unicode character codes.

Choose the method that best fits your needs and preferences.