The simplest way to add a tick mark

The fastest way to add a tick mark in Excel is to type it directly using your keyboard. On Windows, hold Alt and type 0252 on the numeric keypad, then release Alt. On Mac, press Option and V together. A checkmark (✓) will appear in the cell where your cursor is.

This method works in any cell and takes two seconds. You do not need to install anything or change your Excel settings. The tick mark is just a character, like a letter or number, so you can format it, copy it, and move it like any other text.

If the numeric keypad method does not work on your keyboard — many laptops do not have one — use the Insert menu instead. This takes slightly longer but works on every device.

Key Takeaways

  • On Windows, hold Alt and type 0252 on the numeric keypad to insert a checkmark when ready into any cell.
  • On Mac, press Option and V together to type a tick mark without using the Insert menu.
  • The Insert Symbol dialog lets you find and insert a tick mark on any keyboard, including laptops without a numeric keypad.
  • Once inserted, a tick mark behaves like any other character — you can copy it, paste it, and format its size and color.
  • Conditional formatting can automatically add tick marks based on cell values, which is useful for tracking status across many rows.

Using the Insert menu when Alt codes do not work

If you are on a laptop or the Alt code does not work, use Excel's Insert Symbol feature. Click the Insert tab at the top of the ribbon, then find and click Symbol (it is usually on the right side of the Insert tab). A dialog box will open showing hundreds of characters.

In the dialog, look for the search box or scroll down until you find a checkmark. The most common tick mark is called Check Mark and looks like ✓. Click it once to select it, then click Insert. The tick mark will appear in your cell at the cursor position. Close the dialog when you are done.

This method is slower than the Alt code but works on every device and every keyboard layout. Once you have inserted one tick mark this way, you can copy and paste it into other cells instead of repeating the steps.

Copying and pasting a tick mark to multiple cells

After you insert your first tick mark, you can reuse it without going through the Insert menu again. Click the cell containing the tick mark, then press Ctrl+C (Windows) or Command+C (Mac) to copy it.

Select the range of cells where you want the tick mark to appear. You can click one cell and drag to select many, or click the first cell, hold Shift, and click the last cell. Then press Ctrl+V (Windows) or Command+V (Mac) to paste. The tick mark will appear in every selected cell.

This is much faster than inserting the mark one cell at a time, especially if you need the same tick mark in dozens of rows. You can also paste just the tick mark without overwriting other data in the cells by using Paste Special — press Ctrl+Shift+V (Windows) or Command+Shift+V (Mac), then choose Values before clicking OK.

Using conditional formatting to add tick marks automatically

If you want Excel to add a tick mark automatically based on what is in another cell, use conditional formatting. For example, you might want a tick mark to appear in column C whenever column B contains the word "Complete".

First, select the range of cells where you want the tick marks to appear. Click the Home tab, then find Conditional Formatting (usually on the right side). Click it and choose New Rule. In the dialog, select Format only cells that contain, then set the condition — for example, if another cell equals "Complete". Click Format, go to the Font tab, and type a tick mark in the preview box. Click OK twice to explore the rule.

Now whenever the condition is met, the tick mark will appear automatically. If you change the data in the other column, the tick marks will update without you doing anything. This saves time when you are tracking status across many rows and the status changes frequently.

Changing the size and color of your tick mark

A tick mark is just a character, so you can format it like text. Select the cell containing the tick mark. To make it larger, click the font size dropdown in the ribbon (it usually shows a number like 11 or 12) and choose a bigger size. To change the color, click the font color button — it looks like an A with a colored bar underneath — and pick a new color.

You can also make the tick mark bold or italic by selecting it and clicking the B or I button in the ribbon. If you have pasted the same tick mark into many cells, you can select all of them at once and format them together. Click the first cell, hold Ctrl (Windows) or Command (Mac), and click each additional cell, then explore your formatting.

Tick marks versus checkboxes — which to use

Excel also has an interactive checkbox feature that is different from a tick mark character. A checkbox is a small box you can click to toggle on and off, and it stores a true/false value in the cell. A tick mark is just a character that looks like a checkmark but does not do anything when you click it.

Use a tick mark character when you want to display status visually but do not need to click it to change anything — for example, showing which tasks are done in a list. Use a checkbox when you want to click it to toggle between checked and unchecked, such as a to-do list where you check off items as you complete them. Checkboxes require the Developer tab to be visible, while tick marks work when ready with no setup.

Troubleshooting tick marks that do not appear

If you type the Alt code and nothing happens, your numeric keypad may be turned off. Look for a key labeled Num Lock and press it to turn the keypad on, then try the Alt code again. If you are on a laptop, you may need to hold Fn (Function) at the same time as Alt.

If the tick mark appears as a box or strange symbol instead of a checkmark, your font does not support that character. Select the cell and change the font to Calibri, Arial, or Times New Roman — these fonts have the checkmark character. If it still does not work, use the Insert Symbol method instead, which shows you exactly what the character will look like before you insert it.

On Mac, if Option+V does not work, check that you are using the right Option key — some keyboards have two. If neither works, use the Insert Symbol menu instead.

Frequently Asked Questions

Can I use a different symbol instead of a checkmark?

Yes. The Insert Symbol dialog shows hundreds of characters. You can use an X mark, a star, a bullet point, or any other symbol Excel has. Click Insert, then Symbol, and browse or search for the character you want. The same copy-and-paste method works for any symbol.

Will the tick mark print correctly if I print my spreadsheet?

Yes, tick marks print exactly as they appear on screen. Make sure your printer is set to print in color if you have colored the tick mark, otherwise it may print as gray or black depending on your printer settings.

What is the difference between a checkmark and a tick mark?

They are the same thing — checkmark and tick mark are two names for the same symbol (✓). In Excel, both refer to the character you insert, not the interactive checkbox feature.

Can I search for cells that contain a tick mark?

Yes. Press Ctrl+H (Windows) or Command+H (Mac) to open Find and Replace. In the Find field, paste a tick mark (copy one from a cell you already made), leave the Replace field empty, and click Replace All to remove them, or click Find All to see which cells contain them.

Why does my tick mark look different in different cells?

The font size or font type is different in those cells. Select the cells and make sure they all use the same font and size. You can also select all cells with tick marks and format them together to may support they look consistent.