How to Insert Tick Mark in Excel Using Shortcut Key?

Microsoft Excel offers several quick and easy ways to insert a tick mark (✓), also known as a checkmark, into your spreadsheets. Tick marks are commonly used to indicate completion, approval, or selection in checklists, to-do lists, and for highlighting important data. They provide a clear visual cue that helps users quickly identify the status of tasks or the significance of specific cells.

In this comprehensive guide, we’ll explore the best methods to insert a tick mark in Excel, including shortcuts, fonts, symbols, and even creating your own custom tick mark style.

Method 1: Using Wingdings Font and Keyboard Shortcuts

One of the fastest and most convenient ways to insert a tick mark in Excel is by using the Wingdings 2 font and simple keyboard shortcuts. Wingdings is a font family that includes various symbols and icons, making it perfect for adding visual elements to your spreadsheets. Here’s a step-by-step guide on how to use this method:

1. Select the cell or range of cells where you want to insert the tick mark(s).
2. Navigate to the Home tab on the Excel ribbon.
3. Locate the Font group and click on the drop-down menu to expand the font options.
4. Scroll through the font list and select Wingdings 2.
5. With Wingdings 2 selected, you can now use two specific keyboard shortcuts to insert tick marks:

• Press Shift + P to insert a regular tick mark symbol (✓).
• Press Shift + R to insert a tick mark inside a square box (☑).

The tick mark will immediately appear in the selected cell(s), and you can continue working on your spreadsheet.

Shortcut	Symbol	Description
Shift + P	✓	Regular tick mark
Shift + R	☑	Tick mark inside square box

Using these keyboard shortcuts in combination with the Wingdings 2 font provides a quick and efficient way to add basic tick marks to your Excel spreadsheets. This method is particularly useful when you need to insert tick marks frequently or in multiple cells at once.

Method 2: Using the Symbol Dialog Box

If you require more tick mark options or want to browse through all available symbols, the Symbol dialog box in Excel is the way to go. This method offers a wide range of tick mark styles and related symbols, giving you the flexibility to choose the one that best suits your needs. Follow these steps to insert a tick mark using the Symbol dialog box:

1. Select the cell or range of cells where you want to insert the tick mark(s).
2. Go to the Insert tab on the Excel ribbon.
3. In the Symbols group, click on the Symbol button to open the Symbol dialog box.
4. In the Symbol dialog box, locate the Font drop-down menu and choose Wingdings 2 from the list.
5. Scroll through the symbol list to find the desired tick mark symbol. Some commonly used options include:

• ✓ (regular tick mark)
• ☑ (tick mark in a square box)
• ✔ (bold tick mark)
• ✗ (cross mark)

1. Click on the desired symbol to select it.
2. Click the Insert button to add the selected symbol to your spreadsheet.
3. Click Close to exit the Symbol dialog box.

The chosen tick mark symbol will now appear in the selected cell(s).

While using the Symbol dialog box may take a bit longer than using keyboard shortcuts, it provides a more comprehensive set of options and allows you to visually browse through various tick mark styles and related symbols.

This method is particularly helpful when you want to use a specific type of tick mark or need to insert multiple different symbols in your spreadsheet.

Method 3: Using Alt Codes and the UNICHAR Function

Excel doesn’t accept four-digit Unicode codes such as Alt + 2713 (that trick, typing 2713 and pressing Alt + X, only works in Word). These work in Excel instead:

• Alt + 0252 on the numeric keypad, then set the cell’s font to Wingdings: a tick mark (✔)
• Alt + 0254, then set the font to Wingdings: a tick in a box (☑)
• =UNICHAR(10003): a tick mark (✓) in any font, no font change needed
• =UNICHAR(10004): a heavy tick mark (✔)
• =UNICHAR(9745): a tick in a box (☑)

Method	Symbol	Font needed
Alt + 0252	✔	Wingdings
Alt + 0254	☑	Wingdings
=UNICHAR(10003)	✓	Any
=UNICHAR(9745)	☑	Any

UNICHAR is handy with IF, for example =IF(C2="Done", UNICHAR(10003), "") shows a tick automatically when a task is marked Done. Alt codes need a numeric keypad with Num Lock on; on a laptop without one, use UNICHAR or the Wingdings 2 method above.

Creating Custom Tick Mark Styles

In addition to the standard tick mark symbols available in Excel, you can also create your own custom tick mark styles using the built-in Shapes feature. This allows you to design tick marks that match your spreadsheet’s theme or branding. Here’s how to create a custom tick mark:

1. Go to the Insert tab on the Excel ribbon.
2. In the Illustrations group, click on the Shapes button.
3. Choose a shape that resembles a tick mark, such as a checkmark or a line with an arrow.
4. Click and drag on your spreadsheet to draw the shape in the desired size.
5. Use the formatting options in the Shape Format tab to customize the appearance of your tick mark, such as changing the fill color, outline, or adding effects like shadow or glow.
6. To use your custom tick mark in multiple cells, you can copy and paste it or save it as a Picture by right-clicking the shape and selecting Save as Picture.

Creating custom tick mark styles gives you the freedom to design marks that align with your specific needs and preferences, making your spreadsheets more visually appealing and on-brand.

Tips for Using Tick Marks in Excel

To make the most out of tick marks in your Excel spreadsheets, consider the following tips:

• Be consistent: Use tick marks consistently throughout your spreadsheet to maintain clarity and readability. Establish a clear system for what each tick mark represents and stick to it.
• Provide a legend: If your spreadsheet includes multiple types of tick marks or symbols, create a legend or key to explain their meaning, especially if you plan to share the file with others.
• Utilize conditional formatting: Excel’s conditional formatting feature allows you to automatically apply tick marks based on certain criteria, such as completion status or approval. This can save you time and ensure your spreadsheet is always up-to-date.
• Combine with other symbols: Use tick marks in combination with other symbols, such as crosses (X) or dashes (-), to create more detailed status indicators or to convey additional information.
• Customize colors: Change the color of your tick marks using the Font Color tool on the Home tab to make them stand out or match your spreadsheet’s color scheme.

By implementing these tips, you can enhance the functionality and visual appeal of tick marks in your Excel spreadsheets, making them more effective tools for tracking progress, indicating status, and highlighting important information.

Final Thoughts

Inserting tick marks in Excel is a simple yet powerful way to mark items as complete, approved, or selected, making your spreadsheets more organized and informative. Whether you prefer using keyboard shortcuts with the Wingdings font, exploring the Symbol dialog box, using Alt codes or the UNICHAR function, or even creating your own custom tick mark styles, Excel provides a variety of methods to suit your needs and preferences.

Remember to use tick marks consistently, provide a legend when necessary, and explore advanced features like conditional formatting to streamline your workflow and make your spreadsheets more dynamic.

People Also Ask