How To Put Tick Symbol In Excel: 6 Fast And Professional Methods

To put a tick symbol in Excel quickly, you can select your target cell and press Shift + P while using the Wingdings 2 font, or input the formula =UNICHAR(10003) to generate a dynamic Unicode checkmark. For broader compatibility across different computers and mobile devices, inserting a standard checkmark via the Segoe UI Symbol font ensures the visual asset renders correctly without font-degradation issues.

Whether you are building interactive project management dashboards, tracking quality assurance protocols, or maintaining simple to-do lists, knowing how to put tick symbol in Excel is an essential skill for clean data visualization. While Excel does not feature a dedicated "checkmark" key on standard physical keyboards, Microsoft provides several robust native systems to insert, automate, and format checkmarks. This comprehensive guide details the precise technical workflows to implement these symbols across all modern versions of Excel.

Pre-Formatting Planning and Font Compatibility Checklist

Before applying tick marks to your spreadsheets, you must evaluate how the workbook will be shared and processed. Certain legacy fonts, such as Wingdings, may not display correctly on mobile devices or operating systems outside of Windows. Choosing the correct approach during the planning stage prevents visual errors and preserves spreadsheet functionality.

Essential Tools and Requirements

• Software Platform: Microsoft Excel (Microsoft 365, Excel 2021, 2019, 2016, 2013, or Excel for the Web).
• Compatible Fonts: Segoe UI Symbol (for universal Unicode rendering), Wingdings (for legacy systems), Wingdings 2 (for rapid manual shortcuts), or Arial/Calibri (for standard system characters).
• Input Hardware: A standard QWERTY keyboard. A numeric keypad is recommended but not mandatory for entering Alt-code shortcuts.
• Operating Systems: Windows 10/11 or macOS Mojave and later.
• Estimated Integration Time: 2 minutes for manual inserts; 10 minutes for automated conditional formatting configurations.
• Project Cost: Free (integrated directly into the native features of Microsoft Office).

Step-by-Step Guide to Inserting Tick Symbols in Excel

Select the method below that best aligns with your workflow speed, presentation goals, and technical environment.

Step 1: Inserting Ticks via the Symbol Dialog Box (Universal Compatibility)

This method is highly recommended if your workbook will be shared with external clients or opened on multiple operating systems (including macOS and mobile devices). It utilizes the standard Segoe UI Symbol font to guarantee formatting preservation.

1. Double-click the specific cell where you want the tick symbol to appear to enter Edit mode.
2. Navigate to the Excel Ribbon at the top of the screen and click on the Insert tab.
3. Locate the Symbols group on the far-right side of the ribbon and click the Symbol button.
4. In the Symbol dialog window that opens, click the dropdown menu labeled Font and select Segoe UI Symbol.
5. In the dropdown menu labeled Subset (located on the right side), select Dingbats or scroll down until you locate the checkmark designs.
6. For a faster search, locate the Character code box at the bottom of the window. Type 2713 for a standard light tick, or 2714 for a bold checkmark. Ensure the "from" dropdown is set to Unicode (hex).
7. Click the Insert button at the bottom of the dialog box, and then click Close.

Pro-Tip: Once you have inserted your first tick mark, you do not need to repeat these steps. Simply highlight the cell, press Ctrl + C to copy it, select your target cells, and press Ctrl + V to paste it.

Step 2: Using Keyboard Shortcuts with Wingdings 2 (Speed-Focused)

If you need to manually input dozens of ticks and crosses across a massive dataset, changing your column font to Wingdings 2 allows you to enter checkmarks using simple keyboard keystrokes.

1. Select the column, row, or specific range of cells where you want to input your tick marks.
2. Navigate to the Home tab on the Excel Ribbon, locate the Font dropdown menu, type Wingdings 2, and press Enter.
3. Select the first cell in your formatted range.
4. To insert a standard checkmark, press Shift + P (capital P) on your keyboard.
5. To insert a checkmark inside a square box, press Shift + R (capital R).
6. To insert an "X" or cross mark for incomplete tasks, press Shift + O (capital O).

Warning: Because this method alters the font of the entire cell, any standard alphabetical text you type into these cells will also convert into Wingdings symbols. Use this method only in dedicated status columns where no regular text is required.

Step 3: Generating Dynamic Ticks with the UNICHAR Formula (Data-Driven)

For automated dashboards, you can use the Excel UNICHAR function to output a tick mark based on the contents of another cell. This eliminates the need for manual copy-pasting.

1. Identify the target cell where you want the automated tick to appear (for example, cell B2).
2. Identify the source cell that contains your data or task status (for example, cell A2, which contains the text "Complete").
3. In cell B2, input the following logical IF statement: =IF(A2="Complete", UNICHAR(10003), "")
4. Press Enter. If cell A2 contains the exact string "Complete", Excel will automatically output a clean Unicode tick mark in cell B2. If cell A2 is blank or contains any other text, cell B2 will remain blank.
5. To use a heavier, bolder checkmark instead, replace the code 10003 with 10004: =IF(A2="Complete", UNICHAR(10004), "")

Step 4: Creating an AutoCorrect Shortcut (Long-term Efficiency)

If you frequently write reports and want to type a short text string that instantly converts into a tick symbol, you can configure Excel's global AutoCorrect dictionary.

1. Insert a tick symbol into an empty cell using Step 1. Copy that symbol to your clipboard by highlighting it and pressing Ctrl + C.
2. Click the File tab in the top-left corner of the screen and select Options at the bottom of the left sidebar.
3. In the Excel Options dialog box, select the Proofing category.
4. Click the button labeled AutoCorrect Options....
5. In the AutoCorrect dialog window, locate the Replace text box and type a unique text trigger that you are unlikely to write in regular sentences, such as \chk or ctick.
6. Click inside the With text box and press Ctrl + V to paste the copied tick symbol.
7. Click Add, then click OK to close the AutoCorrect options, and click OK again to exit Excel Options.
8. Test the shortcut by typing your trigger text into any cell and pressing Space or Enter. The text will instantly transform into a formatted tick symbol.

Step 5: Applying Conditional Formatting Icon Sets (Visual Dashboards)

If you want to display professional, colored checkmarks and cross marks based on numerical cell values (such as 1 for complete, 0 for incomplete), use Excel's built-in Icon Sets.

1. Input your raw status numbers (such as 1s and 0s) into your target column.
2. Select the entire data range containing those numbers.
3. Go to the Home tab, locate the Styles group, and click on Conditional Formatting.
4. Hover your cursor over Icon Sets and select the style containing the green checkmark, yellow exclamation point, and red cross.
5. To hide the raw numbers and display only the icons, click Conditional Formatting again and select Manage Rules.
6. Select the Icon Set rule you just created and click Edit Rule....
7. Check the box labeled Show Icon Only on the right side of the window.
8. Under the "Display each icon according to these rules" section, change the Type dropdowns from Percent to Number.
9. Set the green checkmark to display when value is >= 1.
10. Set the yellow exclamation point (or choose "No Cell Icon") to display when < 1 and >= 0.
11. Set the red cross to display when < 0. Click OK to save and apply.

Excel Tick Symbol Font Codes and Character Specifications

The following reference table outlines the technical specifications for each primary tick symbol method, ensuring you can quickly identify the correct character codes and keyboard shortcuts for your spreadsheet.

Common Excel Symbol Failures and Formatting Remedies

When working with custom fonts and character codes across various versions of Excel, you may run into rendering errors. Below are the most common real-world failures and their immediate technical fixes.

• Failure Scenario 1: The tick symbol displays as a capital letter "P" or an empty square box on a colleague's computer.
  
  
  • Root Cause: The target computer does not have the custom font (such as Wingdings 2) installed, or Excel stripped the cell formatting when transferring the file.
  • Actionable Fix: Convert your symbols to use the universally supported Segoe UI Symbol font via the Unicode Character Code 2713, or switch to the UNICHAR formula method, which is font-independent.
• Failure Scenario 2: The UNICHAR formula returns a #VALUE! error code.
  
  
  • Root Cause: The spreadsheet is being run in an outdated version of Microsoft Excel (Excel 2010 or older) that does not support Unicode character functions.
  • Actionable Fix: Upgrade the file format to a modern version of Excel, or fall back on the manual Symbol Insertion method using a standard system font like Arial.
• Failure Scenario 3: Formulas and Pivot Tables ignore your tick-marked cells during calculations.
  
  
  • Root Cause: Excel treats manual symbol characters as text strings, meaning mathematical functions like SUM or AVERAGE cannot process them.
  • Actionable Fix: Replace the raw symbols with numerical values (1 for true, 0 for false) and use Conditional Formatting Icon Sets to display the ticks visually while keeping the underlying data numerical.
• Failure Scenario 4: The checkmark disappears when exporting the Excel sheet to a PDF format.
  
  
  • Root Cause: The PDF printer driver cannot embed legacy Wingdings font files during the rendering pipeline.
  • Actionable Fix: Change the font of your checkmark cells to a standard OpenType or TrueType font like Segoe UI Symbol before executing the PDF export command.

Frequently Asked Questions

How do I put a tick symbol inside a box in Excel?

To insert a checkmark inside a box, select your target cell and change its font to Wingdings. Hold down the Alt key and type 0254 on your numeric keypad, then release the Alt key. If you prefer using the Wingdings 2 font, you can simply select the cell, apply Wingdings 2, and press Shift + R on your keyboard.

Can I use a keyboard shortcut for a standard checkmark without changing fonts?

Yes, you can input a standard checkmark in any cell by holding down the Alt key and typing 02713 on your computer's physical numeric keypad (ensure Num Lock is active). If your laptop lacks a dedicated numeric keypad, setting up an AutoCorrect shortcut like "\chk" is the most efficient alternative.

What is the difference between UNICHAR 10003 and UNICHAR 10004?

UNICHAR 10003 displays as a standard, light checkmark that matches regular font weights. UNICHAR 10004 generates a heavy, bold checkmark. Both formulas use universal Unicode formatting, allowing them to render accurately across both Windows and macOS systems.

How do I filter an Excel sheet to only show rows with tick marks?

If you used the Symbol insert method, you can filter your column by clicking the dropdown arrow in the header cell, typing the tick symbol into the search box, and checking its box. If you utilized Conditional Formatting Icon Sets, click the filter dropdown arrow in the header, select "Filter by Color", hover over "Filter by Cell Icon", and select the green checkmark.

Optimize Your Corporate Reporting Pipelines

Transforming raw numbers into clean, highly readable dashboards is the key to faster business decisions and professional project tracking. Implement these tick symbol strategies in your team's tracking sheets today to ensure seamless cross-platform compatibility and visual clarity.