The fastest way to add a tick symbol

The quickest method is to use the Insert Symbol dialog. Click the cell where you want the tick, go to the Insert tab on the ribbon, select Symbol, then search for "check mark" in the dialog box. Excel will show you several tick options — the most common is Unicode 2713 (✓). Click it and select Insert.

This takes about 10 seconds once you know where to look, and it works the same way in Excel for Windows and Excel for Mac. The tick appears in the cell exactly as you clicked it, and you can copy it to other cells by selecting the cell and pressing Ctrl+C (or Cmd+C on Mac), then pasting it where you need it.

If you only need one or two ticks, this is the simplest route. If you need dozens, the copy-paste method saves time over inserting each one individually.

Key Takeaways

  • The Insert Symbol dialog (Insert tab → Symbol) is the most straightforward way to add a tick mark to any cell in Excel.
  • You can copy a tick symbol from one cell and paste it into others, which is faster than inserting each one separately.
  • The Wingdings font contains tick symbols that look different from the standard Unicode checkmark, so you can choose the style you prefer.
  • Typing a formula like =CHAR(252) in a cell will produce a tick symbol without opening any dialog, though the appearance depends on your font.
  • Conditional formatting can automatically add tick symbols based on cell values, which is useful for checklists or status tracking.

Using the Wingdings font for different tick styles

The Symbol dialog defaults to showing you Unicode characters, but Excel also has tick symbols built into the Wingdings font that look different. Some are heavier, some are outlined, and some are filled boxes with ticks inside.

To see Wingdings options, open the Symbol dialog again (Insert → Symbol), then change the font dropdown from "normal text" to Wingdings. Scroll through the list or type "check" in the search box. You will see variations like a heavy checkmark, a ballot box with a check, or a circled tick. Pick the one that matches your spreadsheet's style, click it, and select Insert.

Wingdings symbols work exactly like Unicode ones — you can copy and paste them across cells. The main difference is appearance: Wingdings ticks tend to be bolder and more decorative, while Unicode checkmarks are simpler and more neutral.

Typing a formula to generate a tick symbol

If you want to avoid the dialog entirely, you can type a formula directly into a cell. The formula =CHAR(252) produces a tick symbol in most fonts. Type it into a cell and press Enter, and a tick will appear.

This method is fastest if you need many ticks at once — you can enter the formula in one cell, then copy it down to fill an entire column. However, the appearance of the tick depends on which font your cells are using. In some fonts it looks like a standard checkmark; in others it may look different or not display at all.

If the CHAR formula does not produce the look you want, try =CHAR(10003) instead, which uses a different Unicode character. Test both in your spreadsheet to see which one matches your needs.

Using conditional formatting to add ticks automatically

For checklists or status columns, you can set up conditional formatting to add a tick symbol whenever a cell meets a certain condition. For example, you might want a tick to appear automatically when someone types "done" or "yes" in a cell.

To do this, select the range of cells where you want ticks to appear, go to the Home tab, click Conditional Formatting, then select New Rule. Choose Format only cells that contain, set the condition (for example, cell value equals "done"), then click Format. On the Font tab, change the font to Wingdings and type a tick symbol in the preview. Click OK twice, and the tick will now appear in any cell that matches your condition.

This approach is useful when you are tracking progress or status across a team — the ticks update automatically as people fill in the column, so you do not have to add them manually.

Copying and pasting ticks across multiple cells

Once you have inserted a tick symbol in one cell, the fastest way to fill other cells is to copy and paste it. Click the cell with the tick, press Ctrl+C (or Cmd+C on Mac), then select all the cells where you want the tick to appear and press Ctrl+V (or Cmd+V on Mac).

You can also use the fill handle — the small square at the bottom-right corner of a selected cell. Click and drag it down or across to copy the tick to adjacent cells. This is faster than copy-paste if you are filling a contiguous block of cells.

If you want to paste only the tick symbol and not any other formatting from the original cell, use Paste Special (Ctrl+Shift+V on Windows, Cmd+Shift+V on Mac). Select Text in the dialog and click OK. This pastes only the character itself, leaving the destination cells' formatting unchanged.

Troubleshooting tick symbols that do not display correctly

Sometimes a tick symbol appears as a box, a question mark, or a different character than expected. This usually means the font you are using does not support that particular Unicode character. The fix is to change the font of the cell to one that does.

Select the cell with the problematic tick, then change the font dropdown (on the Home tab) to Wingdings, Segoe UI Symbol, or Arial. One of these will almost always display the tick correctly. If none of them work, try deleting the tick and inserting it again using the Symbol dialog, then immediately changing the font before you move to another cell.

Another common issue is that the tick symbol is there but invisible because the font color is set to white or matches the cell background. Click the cell and check the font color button on the Home tab — it should match your spreadsheet's text color. If it is set to white or a light color, click the dropdown and select black or your preferred text color.

Frequently Asked Questions

Can I use a keyboard shortcut to insert a tick symbol?

There is no single keyboard shortcut that works across all versions of Excel. The fastest keyboard method is to use the Symbol dialog (Alt+N, U on Windows; Ctrl+Cmd+Space on Mac to open the character viewer), but this still requires you to search and click. For speed, most people copy a tick from one cell and paste it into others.

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

In Excel, the terms are used interchangeably — they both refer to the ✓ symbol. Different fonts and Unicode characters produce slightly different visual styles (some are heavier, some are outlined), but they all serve the same purpose of marking something as done or selected.

Can I make a tick symbol larger or change its color?

Yes. Select the cell containing the tick, then use the font size dropdown on the Home tab to make it larger or smaller. To change the color, click the font color button (the "A" with a colored bar underneath) and select a new color. The tick will update to match.

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

Different fonts render the same Unicode character differently. If you send a spreadsheet to someone else and the tick looks wrong on their screen, it is usually because their computer is using a different default font. Ask them to select the cells with ticks and change the font to Wingdings or Segoe UI Symbol, which display consistently across Windows and Mac.

Can I use a tick symbol in a formula or conditional statement?

Yes, but it requires the formula to reference the cell containing the tick, not the tick itself. For example, you could write =IF(A1="yes", CHAR(252), "") to display a tick only when cell A1 contains "yes". The CHAR function generates the tick symbol as part of the formula's output.