How to Add a Checkmark or Tick Mark in Excel

The fastest way to add a tick mark in Excel

The simplest method is to type a checkmark directly using your keyboard. On Windows, hold Alt and type 0252 on the numeric keypad, then release Alt. On Mac, press Option + V. The checkmark appears in the cell immediately.

If the numeric keypad method does not work on your keyboard, you can copy a checkmark from anywhere online and paste it into Excel. Search "checkmark symbol" in your browser, copy the ✓ character, then paste it into your Excel cell using Ctrl+V (Windows) or Command+V (Mac).

Both methods work in any version of Excel and do not require special formatting or add-ons. The checkmark behaves like regular text — you can change its size, color, and font just as you would any other character.

Key Takeaways

On Windows, hold Alt and type 0252 on the numeric keypad to insert a checkmark without leaving Excel.
On Mac, press Option + V to insert a checkmark directly into the active cell.
You can copy a checkmark symbol from a web search and paste it into Excel if keyboard shortcuts do not work on your device.
Once inserted, a checkmark can be formatted like any other text — resized, colored, or moved to a different font.
Checkmarks in Excel are static characters, not formulas, so they do not change based on other cell values unless you add a formula yourself.

Using the Insert Symbol dialog for more checkmark styles

Excel has a built-in symbol menu that shows multiple checkmark designs. Click the cell where you want the checkmark, then go to the Insert tab at the top of the ribbon. Click Symbol (on the far right of the ribbon). A dialog box opens showing available symbols.

In the symbol dialog, look for the Subset dropdown menu and select Geometric Shapes or Dingbats. Scroll through the options until you find a checkmark style you prefer. Click the checkmark, then click Insert. The symbol appears in your cell.

This method gives you access to different checkmark designs — some are hollow, some are filled, and some are styled differently. If you use the same checkmark repeatedly, you can copy it from the first cell and paste it into others rather than opening the symbol dialog each time.

Creating a checkbox that responds to clicks

If you want a checkbox that toggles between checked and unchecked when you click it, you need to use Excel's form controls. Go to the Developer tab. If you do not see it, right-click the ribbon, select Customize the Ribbon, check the Developer box, and click OK.

Once the Developer tab is visible, click Insert and look for Checkbox under Form Controls (the first section, not ActiveX Controls). Click and drag on your spreadsheet to draw the checkbox. A checkbox appears that you can click to toggle on and off.

Form control checkboxes are linked to cells, so you can use them in formulas. Right-click the checkbox, select Format Control, and set the Cell Link to any empty cell. When you click the checkbox, that cell will show TRUE or FALSE, which you can reference in other formulas.

Using a formula to add checkmarks based on conditions

You can use a formula to display a checkmark only when a certain condition is met. For example, if you want a checkmark to appear in column C when the value in column B is greater than 100, use this formula: =IF(B1>100,"✓","")

Type this formula into the cell where you want the checkmark to appear. Replace B1 with the cell you want to check, and replace 100 with your condition. When the condition is true, the checkmark appears. When it is false, the cell stays blank.

You can modify this formula to check for text values too. For example, =IF(B1="Complete","✓","") will show a checkmark if cell B1 contains the word "Complete". Copy the formula down to apply it to multiple rows at once.

Changing the color and size of your checkmark

Once a checkmark is in a cell, you can format it like any other text. Select the cell containing the checkmark. On the Home tab, use the Font Color button (the "A" with a colored line underneath) to change the checkmark color. Click the dropdown arrow next to it and choose your color.

To change the size, select the cell and use the Font Size dropdown on the Home tab. Increase the number to make the checkmark larger, or decrease it to make it smaller. You can also select just the checkmark character within the cell by double-clicking the cell and dragging to highlight only the checkmark, then changing its size independently.

If you want the checkmark to stand out more, you can also apply bold or italic formatting. Select the cell, then click the Bold or Italic button on the Home tab. The checkmark will inherit the formatting of the entire cell.

Troubleshooting checkmarks that do not appear

If you typed the Alt code but no checkmark appeared, your keyboard may not have a numeric keypad, or Num Lock may be off. Check that Num Lock is enabled (usually a light on your keyboard shows this). If your keyboard has no separate numeric keypad, try using the number row at the top of your keyboard instead — this usually does not work, but it is worth testing.

If the Alt code method fails, the copy-and-paste method is more reliable. Search for "checkmark symbol" online, copy the ✓ character, and paste it into Excel. This works on any device and any keyboard layout.

If a checkmark appears as a box or strange character, the font you are using does not support that symbol. Select the cell and change the font to Arial, Calibri, or Segoe UI — these fonts display checkmarks correctly on most systems.

Frequently Asked Questions

Can I make a checkmark that automatically appears when I type something in another cell?

Yes, use an IF formula. For example, =IF(B1<>"","✓","") will show a checkmark in the current cell whenever cell B1 contains any text. Replace B1 with the cell you want to monitor, and adjust the condition to match what you need.

What is the difference between a checkmark and a checkbox?

A checkmark is a static character (✓) that you type or insert like text. A checkbox is an interactive form control that toggles between checked and unchecked when you click it. Use a checkmark for display only; use a checkbox when you need to track on/off status in a formula.

Why does my checkmark look different on someone else's computer?

Different fonts render the checkmark symbol slightly differently. If consistency matters, specify the font in your spreadsheet. Select all cells with checkmarks, then set the font to Arial or Calibri on the Home tab. When others open the file, those cells will use the same font and the checkmarks will look the same.

Can I print checkmarks in Excel?

Yes. Checkmarks print exactly as they appear on screen. Before printing, preview your spreadsheet by going to File > Print Preview to confirm the checkmarks are visible and positioned correctly. Adjust column widths or font sizes if needed before printing.

How do I remove a checkmark from a cell?

Click the cell containing the checkmark and press Delete. The checkmark disappears. If the checkmark is part of a formula, delete the formula and the checkmark will be removed along with it.

This guide is for general information only and is not medical, financial, legal, or other professional advice. For decisions specific to your situation, consult a qualified professional. See our Editorial Policy.