How Do I Do A Tick In Excel

8 min read

Of course. Here is a complete, in-depth article on how to insert a checkmark (tick) in Excel, written to be both user-friendly and SEO-optimized.


How to Do a Tick in Excel: 5 Simple Methods to Check Off Your Tasks

Are you looking for a way to insert a checkmark (or tick) in your Excel spreadsheets? Whether you’re creating a to-do list, tracking project progress, or marking items in a form, using a visual tick is a powerful way to represent completion or a positive status. Excel offers several straightforward methods to add this symbol, each with its own advantages Easy to understand, harder to ignore..

This practical guide will walk you through five different ways to put a tick in a cell, from the simplest built-in symbol to more advanced, interactive techniques. By the end, you’ll know exactly which method is best for your needs.

Method 1: The Easiest Way – Using the Symbol Dialog Box

The most direct and common method to insert a tick in Excel is by using the built-in Symbol dialog box. This is perfect for static ticks that don’t need to change dynamically And it works..

  1. Select the cell where you want the checkmark to appear.
  2. Go to the Insert tab on the Excel ribbon.
  3. In the Symbols group, click on the Symbol icon (it looks like a omega Ω symbol).
  4. A dialog box will pop up. In the Font dropdown, select Wingdings or Wingdings 2. These fonts contain a wide range of symbols, including checkmarks.
  5. Scroll through the list or use the Character code box. The most common checkmarks have these codes:
    • ✔ (Thick Check Mark): Character code 252 in Wingdings.
    • ✓ (Thin Check Mark): Character code 251 in Wingdings.
    • ☑ (Checked Box): Character code 163 in Wingdings 2 (or 0x00A3 in hexadecimal).
  6. Once you’ve selected the symbol you want, click OK. The checkmark will now appear in your chosen cell.

Pro Tip: If you plan to use the same checkmark frequently, consider assigning it to a custom button on your Quick Access Toolbar for one-click access The details matter here..

Method 2: The Fastest Way – Using Keyboard Shortcuts

If you’re a fan of keyboard efficiency, you can insert a tick without taking your hands off the keyboard. This method uses the same underlying fonts as the Symbol dialog Took long enough..

  1. Select the cell where you want the checkmark.
  2. Press and hold the Alt key.
  3. While holding Alt, type the following numeric codes on your keyboard’s numeric keypad (this must be the keypad on the right side of the keyboard, not the top row of numbers):
    • For a ✔ (Thick Check Mark): Type 252 and release the Alt key.
    • For a ✓ (Thin Check Mark): Type 251 and release the Alt key.
    • For a ☑ (Checked Box): Type 163 and release the Alt key.

We're talking about a quick and seamless method once you get the hang of it. Note that the Num Lock key must be turned on for this to work Small thing, real impact. Surprisingly effective..

Method 3: The Professional Way – Using Wingdings Font Directly

Instead of inserting a symbol, you can simply type a character and then change the font of the cell to Wingdings. This is a very flexible technique Simple, but easy to overlook..

  1. Select the cell and type the following character: P (a capital letter P).
  2. With the cell still selected, change the font in the font dropdown on the Home tab to Wingdings.
  3. Voilà! The letter "P" transforms into a bold ✔ (Thick Check Mark).

This method is excellent because the character is part of the cell's text, allowing you to manipulate it like any other text (e.g., change its size or color easily).

Method 4: The Interactive Way – Using Checkbox Form Controls

For a more dynamic spreadsheet where you can actively check and uncheck items (like a real to-do list), you need to use a Checkbox Form Control. This method requires a few more steps but offers a much better user experience.

  1. First, ensure the Developer tab is visible on your ribbon. If it’s not, you need to enable it:
    • Go to File > Options > Customize Ribbon.
    • On the right, check the box next to Developer and click OK.
  2. On the new Developer tab, in the Controls group, click Insert.
  3. Select the Checkbox icon from the Form Controls section (the first option).
  4. Now, click and drag in the cell where you want to place the checkbox. A small checkbox will appear.
  5. Right-click on the checkbox and select Edit Text. Type the label you want (e.g., "Done").
  6. To make it functional, you need to link it to a cell. Right-click the checkbox again and choose Format Control.
  7. In the Control tab, under Cell link, type the cell reference where you want the check status to be recorded (e.g., B2). When you check the box, the linked cell will display TRUE; when unchecked, it shows FALSE.

You can then use this TRUE/FALSE value in formulas for conditional formatting, calculations, and more.

Method 5: The Advanced Way – Using Conditional Formatting with Symbols

This method is powerful for automatically displaying a tick based on the value in another cell. Here's one way to look at it: if a task’s status in cell A2 is "Done," cell B2 can automatically show a checkmark And it works..

  1. First, set up your data. To give you an idea, in column A, you have task names, and in column B, you will have a status like "Done" or "Pending."
  2. Select the range of cells where you want the checkmarks to appear (e.g., C2:C10).
  3. Go to the Home tab and click Conditional Formatting > New Rule.
  4. Choose Use a formula to determine which cells to format.
  5. In the Format values where this formula is true box, enter a formula that references the corresponding cell in your status column. For row 2, it would be: =$B2="Done"
  6. Click the Format button. In the Format Cells dialog, go to the Font tab.
  7. Select the Wingdings font from the font list. Now, in the text preview box, type the character for a checkmark. You can select the ✔ symbol from the Symbol dialog (as in Method 1) or simply type a P (as in Method 3).
  8. Click OK to close the Format Cells dialog, and then OK again to close the Conditional Formatting rule.
  9. Now, whenever you type "Done" in column B, the corresponding cell in column C will automatically display a checkmark. If you change it to anything else, the checkmark disappears.

Which Method Should You Choose?

  • For a one-time, static tick: Use the Symbol Dialog Box (Method 1).
  • For speed and efficiency: Use **Keyboard

Shortcuts (Method 2 or 3) to rapidly insert marks without breaking your typing flow And that's really what it comes down to..

  • For interactive to-do lists and dashboards: Use Form Control Checkboxes (Method 4) to capture TRUE/FALSE data that drives charts, pivot tables, or COUNTIF summaries.
  • For dynamic, data-driven reports: Use Conditional Formatting (Method 5) to automatically visualize status changes without manual intervention—ideal for shared trackers where statuses update frequently.

Pro Tips for a Polished Workbook

Regardless of the method you choose, these finishing touches will elevate your spreadsheet from functional to professional:

  • Align for Readability: Center your checkmarks horizontally and vertically (Home tab > Alignment group > Middle Align + Center). This prevents the "floating" look that occurs when row heights vary.
  • Color-Code with Conditional Formatting: Even if you insert static symbols (Method 1 or 3), apply a Conditional Formatting rule to the cell range: Cell Value = "✔" (or =CHAR(252)) → Format Font Color to Dark Green. For FALSE or empty states, use Light Gray or Red. This provides instant visual scanning.
  • Protect the Structure: If you use Form Control Checkboxes (Method 4), protect the sheet (Review > Protect Sheet) but ensure "Edit Objects" is unchecked in the protection options. This allows users to click checkboxes without accidentally deleting or moving them.
  • Print Settings: Checkboxes and Wingdings symbols print differently. Form Control checkboxes print as interactive squares (checked/unchecked), while Wingdings/Unicode symbols print exactly as they appear on screen. Do a Print Preview (Ctrl+P) before distributing hard copies.

Conclusion

Excel offers a surprising depth of options for something as simple as a checkmark, and the "right" tool depends entirely on your workflow. But if you are building a static reference sheet, the Symbol dialog or a quick Alt code gets the job done in seconds. If you are building a living dashboard that feeds formulas, charts, or automation, investing the extra minute to set up Form Control Checkboxes or Conditional Formatting pays dividends in data integrity and visual clarity Worth knowing..

Mastering these five methods ensures you never have to settle for a typed "X" or a clumsy "Y" again. You now have the toolkit to make your spreadsheets not just accurate, but visually intuitive and interactive—hallmarks of an advanced Excel user.

Hot New Reads

Hot New Posts

Keep the Thread Going

Up Next

Thank you for reading about How Do I Do A Tick In Excel. We hope the information has been useful. Feel free to contact us if you have any questions. See you next time — don't forget to bookmark!
⌂ Back to Home