How to Insert Tick Mark in Excel Using Shortcut Key?

Sharing is caring!

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.

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 Unicode Characters and Alt Codes

Unicode is a standard for encoding characters, and each character has a unique code. Excel supports Unicode characters, which means you can use Alt codes to insert tick marks and other symbols into your spreadsheets. Alt codes are numeric codes that, when typed while holding down the Alt key, insert a specific character. Here’s how to use Alt codes to insert tick marks in Excel:

1. Select the cell or range of cells where you want to insert the tick mark(s).
2. Ensure that Num Lock is turned on, as Alt codes require the use of the numeric keypad.
3. Press and hold the Alt key on your keyboard.
4. While holding Alt, type the Alt code for the desired tick mark using the numeric keypad (not the number row at the top of your keyboard). For example:

• Alt + 2713 for a regular tick mark (✓)
• Alt + 2611 for a tick mark in a square box (☑)

5. Release the Alt key, and the tick mark will appear in the selected cell(s).

Using Alt codes to insert tick marks can be a bit more cumbersome than the previous methods, as you need to remember the specific codes for each symbol. However, this method is still useful when you don’t have access to the Wingdings font or prefer using keystrokes over navigating menus.

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, utilizing Unicode Alt codes, 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

Vaishvi Desai

Vaishvi Desai is the founder of Excelsamurai and a passionate Excel enthusiast with years of experience in data analysis and spreadsheet management. With a mission to help others harness the power of Excel, Vaishvi shares her expertise through concise, easy-to-follow tutorials on shortcuts, formulas, Pivot Tables, and VBA.