How to Insert a Checkmark (Tick) Symbol in Microsoft Excel

Adding a checkmark (often called a tick symbol) in Microsoft Excel is a highly effective way to create visual to-do lists, track project progress, or denote the completion of specific tasks in a spreadsheet. Unlike specialized software like Microsoft To Do, Excel does not have a dedicated “checkbox” button on its main ribbon, leaving many users wondering how to insert this common symbol.

Fortunately, Excel supports several different methods for inserting checkmarks, ranging from simple keyboard shortcuts and symbol menus to interactive, clickable checkboxes designed for professional forms and dashboards.

Method 1: Using the Symbol Menu (Most Reliable)

The most straightforward way to insert a static checkmark character is by using Excel’s built-in Symbol menu. This method works across all versions of Excel on both Windows and Mac.

1. Click on the cell where you want the checkmark to appear.
2. Look at the ribbon at the top of your screen and click on the Insert tab.
3. On the far right side of the ribbon, click the Symbol icon. (If your Excel window is small, you may need to click a button labeled Symbols first to reveal the icon).
4. A dialog box will appear. Look for the dropdown menu labeled Font near the top left of this box.
5. Click the Font dropdown and scroll down (or type) to select the font Wingdings 2. (The standard Wingdings font also works, but Wingdings 2 has cleaner checkmarks).
6. Scroll through the grid of symbols until you find the checkmark (✓) or the checkmark inside a box (☑).
7. Click on the symbol to highlight it.
8. Click the Insert button at the bottom of the dialog box, then click Close.

The symbol is now inserted into your cell. Because it is treated as text, you can change its color (e.g., to green) or increase its size using the standard font formatting tools on the Home tab.

Method 2: Using a Keyboard Shortcut (Fastest)

If you need to insert checkmarks frequently, navigating menus becomes tedious. You can use a clever font trick combined with a keyboard shortcut to instantly create a checkmark.

1. Select the cell (or highlight a range of cells) where you intend to place checkmarks.
2. Go to the Home tab on the ribbon.
3. Change the font for these cells to Webdings (type it into the font box and press Enter).
4. Now, click into one of those cells, type a lowercase “a”, and press Enter.

Because you changed the font to Webdings, typing a lowercase “a” instantly renders as a solid checkmark. Typing a lowercase “r” renders as an “X” mark, making this an incredibly fast way to manage simple yes/no columns.

Method 3: Using the Windows Emoji Keyboard

If you are using Windows 10 or Windows 11, you can bypass Excel’s menus entirely and use the operating system’s built-in emoji keyboard to insert a colorful checkmark.

1. Double-click on the cell where you want the checkmark, placing your text cursor inside it.
2. Press the Windows Key + . (Period) on your keyboard simultaneously.
3. The Windows Emoji panel will appear on your screen.
4. Type the word “check” to search for the symbol.
5. Click on the heavy green checkmark emoji (✔️) or the standard black checkmark (✔) to insert it.

Note for Mac users: You can access a similar menu by pressing Cmd + Ctrl + Space.

Method 4: Using the UNICHAR Formula

If you are building complex formulas (such as an IF statement) and want Excel to automatically display a checkmark when a condition is met, you can use the UNICHAR function. This function translates numerical codes into Unicode symbols.

The Unicode number for a standard checkmark is 10003, and the number for an “X” is 10005.

• To insert a checkmark using a formula, type: =UNICHAR(10003)

Practical Example with an IF Statement

Imagine you have a sales target in cell B2 and the actual sales in cell C2. You want a checkmark to appear if the target is met, and an X if it is missed.

You would use this formula:
=IF(C2>=B2, UNICHAR(10003), UNICHAR(10005))

Method 5: Inserting an Interactive, Clickable Checkbox

The methods above insert static symbols. If you want to create a professional form or to-do list where users can actually click a small box to toggle a checkmark on and off, you need to use Form Controls. This requires enabling the hidden Developer tab.

Step 1: Enable the Developer Tab

1. Go to File > Options.
2. Click Customize Ribbon on the left side.
3. On the right side, check the box next to Developer and click OK.

Step 2: Insert the Checkbox

1. Click the new Developer tab on the ribbon.
2. In the Controls group, click Insert.
3. Under “Form Controls,” click the icon that looks like a small square with a checkmark inside it (Checkbox).
4. Your cursor will turn into a crosshair. Click anywhere on your spreadsheet to draw the checkbox.
5. You can now right-click the checkbox to edit the text next to it or move it to perfectly align inside a specific cell.

This interactive checkbox can even be linked to a specific cell (by right-clicking it and selecting Format Control) so that checking the box outputs “TRUE” in the background, allowing you to trigger other formulas based on whether the box is checked.