Excel Tutorial: How To Put A Checkmark In Excel


When working with data in Excel, it is often important to indicate completion or status using checkmarks. However, many users struggle with inserting these symbols into their spreadsheets. In this tutorial, we will provide a step-by-step guide on how to put a checkmark in Excel, ensuring that your data is accurate and visually appealing.

Key Takeaways

  • Checkmarks are important for indicating completion or status in Excel.
  • There are different ways to insert a checkmark in Excel, such as using the Insert Symbol tool, Wingdings font, CHAR function, and keyboard shortcuts.
  • Unicode characters and the Wingdings font offer options for inserting checkmarks.
  • The Insert Symbol tool provides a step-by-step guide for inserting a checkmark and choosing the right font.
  • Readers are encouraged to practice and master the methods for inserting checkmarks in Excel.

Understanding the Symbol

When working with Excel, it's important to understand how to use different symbols and characters, including the checkmark. In this tutorial, we will explore the different ways to insert a checkmark in Excel and learn about Unicode characters and their usage.

A. Different ways to insert a checkmark
  • Using the Insert Symbol tool

  • Using the Wingdings font

  • Using the keyboard shortcut

B. Unicode characters and their usage

Unicode characters are a set of symbols and characters that are standardized across different platforms and devices. They can be used in Excel to insert a variety of symbols, including the checkmark.

  • Locating and inserting Unicode checkmark characters

  • Using the CHAR function to insert checkmarks

  • Understanding the limitations of Unicode characters in Excel

Using the Insert Symbol Tool

When working with Excel, you may want to add checkmarks to your spreadsheet to indicate completion or approval of certain tasks. One way to do this is by using the Insert Symbol tool. Here's a step-by-step guide on how to use this feature:

Step-by-step guide on how to use the Insert Symbol tool

  • Step 1: Open your Excel spreadsheet and click on the cell where you want to insert the checkmark.
  • Step 2: Go to the "Insert" tab in the Excel ribbon.
  • Step 3: Click on the "Symbol" button in the "Symbols" group.
  • Step 4: In the "Symbol" dialog box, select "Arial" or "Wingdings" from the "Font" dropdown menu.
  • Step 5: Scroll through the list of symbols and double-click on the checkmark symbol to insert it into the selected cell.

Choosing the right font for the checkmark symbol

When using the Insert Symbol tool to add a checkmark in Excel, it's important to choose the right font for the symbol. The two most commonly used fonts for checkmarks are "Arial" and "Wingdings." Here's how to choose the right font:

  • Arial: The Arial font is a standard font that contains a checkmark symbol. When using this font, simply select "Arial" from the "Font" dropdown menu in the "Symbol" dialog box and scroll through the list of symbols to find the checkmark.
  • Wingdings: The Wingdings font also contains a checkmark symbol, which may appear differently than the one in Arial. To use this font, select "Wingdings" from the "Font" dropdown menu in the "Symbol" dialog box and double-click on the checkmark symbol to insert it into the cell.

Using the Wingdings Font

Excel offers a variety of fonts to enhance the appearance of your spreadsheets. One of these fonts, Wingdings, contains a checkmark symbol that can be easily inserted into your Excel document.

A. Explanation of the Wingdings font and its checkmark symbol

The Wingdings font is a symbol font that contains a variety of icons and symbols, including a checkmark. This font is commonly used to add visual elements and decorative touches to documents, spreadsheets, and presentations.

B. How to change font and insert the checkmark

To use the Wingdings font and insert a checkmark in Excel, follow these simple steps:

1. Changing the font to Wingdings

  • First, select the cell in which you want to insert the checkmark.
  • Next, go to the "Home" tab on the Excel ribbon and locate the "Font" dropdown menu.
  • From the font dropdown menu, select "Wingdings" to change the font for the selected cell.

2. Inserting the checkmark symbol

  • Once the font has been changed to Wingdings, simply type the letter "a" into the selected cell. The letter "a" in the Wingdings font corresponds to the checkmark symbol.
  • You should now see a checkmark appear in the cell, indicating that the Wingdings font has been successfully applied.

By using the Wingdings font and following these steps, you can easily add a checkmark symbol to your Excel spreadsheet, enhancing its visual appeal and conveying important information at a glance.

Using the CHAR Function

When it comes to adding a checkmark in Excel, the CHAR function can be a useful tool. This function allows you to insert special characters, including the checkmark symbol, into your spreadsheet.

Understanding the CHAR function and its application for checkmarks

The CHAR function in Excel returns the character specified by a number. This means that you can use it to insert symbols, such as a checkmark, into your cells.

Step-by-step guide on using the CHAR function

  • Step 1: Select the cell where you want to insert the checkmark.
  • Step 2: Type the following formula into the formula bar: =CHAR(252).
  • Step 3: Press Enter to apply the formula. You should now see a checkmark symbol in the selected cell.

Using a Keyboard Shortcut

Inserting a checkmark in Excel can be done quickly and easily using a keyboard shortcut. This can save you time and make the process more efficient.

How to use a keyboard shortcut to insert a checkmark

To insert a checkmark in Excel using a keyboard shortcut, follow these simple steps:

  • Select the cell where you want to insert the checkmark.
  • Press the "Alt" key and, while holding it down, press "0252" on the numeric keypad.
  • Release the "Alt" key and a checkmark symbol will appear in the cell.

Tips for remembering the shortcut

Remembering keyboard shortcuts can be challenging, but there are a few tips that can help:

  • Practice using the shortcut regularly to commit it to memory.
  • Use mnemonic devices to help remember the numbers in the shortcut.
  • Create a cheat sheet with the shortcut written down for quick reference.

By using the keyboard shortcut to insert a checkmark in Excel, you can streamline your work and improve your efficiency when working with spreadsheets.


In conclusion, there are several methods for inserting a checkmark in Excel, including using the Wingdings font, the Insert Symbol feature, or the AutoCorrect feature. By practicing and mastering these methods, you can easily add checkmarks to your spreadsheets and enhance their visual appeal. Whether you are using Excel for work or personal projects, having the ability to insert checkmarks can be a valuable skill. So, don't hesitate to experiment with these methods and see which one works best for you!

Excel Dashboard

ONLY $99

    Immediate Download

    MAC & PC Compatible

    Free Email Support

Related aticles