EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login

Check Mark in Excel

By Madhuri ThakurMadhuri Thakur

Home » Excel » Blog » Excel Tools » Check Mark in Excel

Checkmark in Excel

A checkmark in Excel  (Table of Contents)

  • Checkmark in Excel
  • How to Insert Checkmark in Excel?
  • How to use Tick mark in an Excel sheet?
  • How to insert Tick mark using CHAR Function?
  • How to insert Checkmark in excel with AutoCorrect?

Checkmark in Excel

Check Mark in Excel is a kind of marking type which is used as a character in a cell. This becomes applicable only if we have selected the Wingdings2 fonts in Excel, mainly used for creating the marks. If we want to create a Checkmark into a cell, we need to type Shift + P or directly use capital P, which will return Checkmark. Even if we are using the correct alphabet or character under Wingdings2 fonts, but the font size (Upper or Lower Case) is not properly used, we will end up getting a different mark.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

How to Insert Checkmark in Excel?

Let’s see how to insert check mark or tick mark in excel.

You can download this Checkmark Excel Template here – Checkmark Excel Template

A tick mark can be inserted into a cell to convey the result of “yes” as an answer to some questions, or the option “yes” applies here. There are two types of checkmarks in excel.

  • Interactive check box – Conveys a message to the next level
  • Tick symbol – Is a Special symbol

Checkmark in Excel – Example #1

The sheet represents the status of which all are the tasks are completed. The complete details are mentioned in the sheet, and in the status column, a tick mark is given to mention which are the completed tasks. When the sheets contain complex data, it is easy to use tick marks instead of using any other comments.

Checkmark Example 1-1

  • Select the cell in the status column where you want to insert the tick mark.

Checkmark Example 1-2

  • Go to the Insert menu click on the symbols option. You will get the list of symbols in the dialog window.
  • From the symbol, dialog window use the drop-down arrow to select the font Wingdings.

Checkmark Example 1-2

  • With the dialog window, you can see different symbols. Select the tick mark and click on the insert button to insert the symbol to the selected cell.

Checkmark Example 1-3

  • Press the cancel button to hide the dialog window.

Checkmark in Excel – Example #2

Instead of a tick mark, we can use a tick box or checkbox to represent an option selected. This checkmark box can be used to show a Yes; this applies. Along with this, a cross mark is also used to indicate some incorrectness. Here the task which is completed is indicated by the tick box.

Checkmark Example 2-1

  • Select the cell in the status column where you want to insert the checkbox. Go to the Insert menu click on the symbols option. You will get the list of symbols in the dialog window. (As shown in the above steps)
  • From the Symbol dialog window, use the drop-down arrow to select the font “Wingdings” (As shown in the above steps)
  • With the dialog window, you can see different symbols. Select the checkmark symbol and click on the insert button to insert the symbol to the selected cell.

Checkmark Example 2-2

  • Press the cancel button to hide the dialog window.

How to Use Tickmark in an Excel Sheet?

The simple way is to insert the tick mark symbol from the Symbols option.

Popular Course in this category
Sale
Excel Advanced Training (16 Courses, 23+ Projects)16 Online Courses | 23 Hands-on Projects | 140+ Hours | Verifiable Certificate of Completion | Lifetime Access
4.8 (11,442 ratings)
Course Price

View Course

Related Courses
Excel Training (21 Courses, 9+ Projects)
  • Select the particular cell where you want to insert the tick mark symbol.
  • Go to the menu bar and select the insert option.
  • From the Insert menu, go to the symbol option.

Checkmark Example 2-2

  • From the Symbol dialog window, use the drop-down arrow to select the font “Wingdings.”
  • With the dialog window, you can see different symbols. Select the tick mark and click on the insert button to insert the symbol to the selected cell.
  • Press the cancel button to hide the dialog window.

Wingdings Example 2-3

The same is shown in the figure where you can see the tick mark is being selected, and the same will be added to the “Recently Used Symbols” list.

Checkmark Example 2-4

How to insert Tick mark using CHAR Function?

It is possible to insert the tick mark in excel or checkbox using the char function, which is a built-in function in excel. This is a simple way for those who commonly use formulas more in excel.

While selecting the symbol in the dialog window, you can see excel in generating character code for each and every symbol.

For example, the Character code for the tick mark is 252.

Use the formula =CHAR (252) to get the tick mark in the selected cell. Make sure that the font of the cell should be Wingdings.

Checkmark Example 2-3

Use the below symbol code for inserting different symbols using the CHAR function.

Checkmark Example 2-4
How to insert tick mark in excel using keyboard shortcuts?

The symbols can be inserted in excel using some keyboard shortcuts. It is commonly a combination of the shift key and an alphabet. Before applying the shortcuts, the cells should apply the “Windings 2” or “Webdings” font to get the below-given results.

Checkmark Example 2-5
This is also a simple method to insert the tick mark symbol in the cell where you want. Once you apply any of the mentioned fonts, press the shift key along with alphabet P. you can see the tick mark will be appearing on the selected cell.

How to insert a checkmark in excel with AutoCorrect?

This is another option on how to insert check mark in excel. When you want to regularly use this symbol, this will be the easy way to insert the checkbox.

  • Insert the tick mark symbol from symbols followed by insert menu
  • Select the particular cell and copy the symbol from the formula bar

CM Example 2-6

  • Select the” ü” symbol and press “Ctrl + C” to copy it.
  • Note the font type that is being selected; this will be needed while you are auto-inserting the tick mark.

CM Example 2-7

  • Go to the File menu, then select options.
  • Select “proofing “from the dialog window; also select the Autocorrect Options.

CM Example 2-8

  • Once you go through the Autocorrect option, you will get another dialog box.
  • In the “Replace” box, type the word which you want to use instead of the tick mark.
  • In the “With” box, paste the copied symbol ” ü” (Ctrl + V)
  • Press on Add button, then click OK

CM Example 2-9

By following the mentioned steps, the tick mark symbol is auto-corrected. After completing this, when you want to put a tick mark on the excel cell, go with the following steps.

  • Type the word which you linked with the checkmark (Eg: tick mark) and press enter.
  • The symbol” ü” will appear in the cell. To change it into a tick mark, apply the proper font (i.e., Wingdings) to the cell.

The benefit of using this method is that you can associate the word you want to with the particular symbol and remember it easily. Once you configure the Autocorrect option, you can add the symbol anytime by typing the associated word.

Things to Remember about the Checkmark in Excel

  • The symbol font should be in “Wingdings” in the dialog window when selecting from insert symbol options.
  • While using the character function, ensure the selected cells should be in “Wingdings” font to get the expected result.
  • Use the Autocorrect method if you are regularly using the same type of symbols.
  • To find the character code for the symbol, select the symbol from the symbol window and check the corresponding character code in the box given at the end of the symbol window.

Recommended Articles

This has been a guide on Checkmark in Excel. The easiest way to adjust a column is to use the Checkmark in Excel. Here we also discuss how to insert Checkmark in Excel along with practical examples and downloadable excel template. You can also go through our other suggested articles –

  1. Checklist in Excel
  2. Excel Spell Check
  3. CheckBox in Excel
  4. Watermark in Excel

All in One Excel VBA Bundle (120+ Courses, 30+ Projects)

120+ Online Courses

30+ Projects

500+ Hours

Verifiable Certificates

Lifetime Access

Learn More

8 Shares
Share
Tweet
Share
Primary Sidebar
Excel Functions
  • Excel Tools
    • Excel Shortcut Redo
    • Reduce Excel File Size
    • Quick Analysis in Excel
    • Goal Seek in Excel
    • Compare Two Lists in Excel
    • Excel Quick Analysis
    • Estimate Template in Excel
    • Pivot Table Count Unique
    • CSV Files into Excel
    • Excel Business Plan Template
    • Excel Export to PDF
    • Free Excel Template
    • Excel Repair
    • Color in Excel
    • Form Controls in Excel
    • Timecard Template in Excel
    • How to Unhide All Sheets in Excel?
    • Power Query in Excel
    • Power View in Excel
    • XML in Excel
    • Excel Evaluate Formula
    • Examples of Excel Macros
    • Consolidation in Excel
    • Ribbon in Excel
    • Excel Conditional Formatting for Dates
    • Protect Sheet in Excel
    • Data Model in Excel
    • Pivot Table Examples
    • Pivot Table Slicer
    • Pivot Table Filter
    • Watch Window in Excel
    • Slicer in Excel
    • Print Gridlines in Excel
    • Convert Numbers to Text in Excel
    • Freeze Columns in Excel
    • Spelling Check in Excel
    • Name Box in Excel
    • Solve Equation in Excel
    • Excel Spreadsheet Examples
    • What If Analysis in Excel
    • How to Print Labels From Excel
    • Excel Named Range
    • Excel TRANSPOSE Formula
    • Excel Merge and Center
    • Excel Freeze Rows
    • HLOOKUP Formula in Excel
    • Excel Create Database
    • Excel Gridlines
    • Excel Spreadsheet Formulas
    • Excel Sort By Number
    • Excel Concatenating Columns
    • Excel AutoCorrect
    • Conditional Formatting For Blank Cells
    • Excel Icon Sets
    • Excel CTRL D
    • Excel Accounting Number Format
    • Excel Regression Analysis
    • Excel Import Data
    • Excel Freeze Panes
    • Excel Calendar
    • Excel Developer Tab
    • Excel Enable Macros
    • Excel Autosave
    • Heat Map in Excel
    • Excel Toolbar
    • Excel Error Bar
    • Excel Status Bar
    • Excel Unprotect Sheet
    • Check mark in Excel
    • Excel Column Filter
    • Excel Header and Footer
    • Excel Drawing
    • Range in Excel
    • Timeline in Excel
    • Excel Lock Formula
    • Excel Table styles
    • Insert New Worksheet in Excel
    • Excel Column Lock
    • Excel Forms for Data Entry
    • QUOTIENT in Excel
    • Excel Sorting
    • Excel Sort by color
    • Excel Data Bars
    • Excel Tool for Data Analysis
    • Excel Flash Fill
    • Excel Auto Fill
    • Excel Quick Access Toolbar
    • Excel Wrap Text
    • Excel Exponential Smoothing
    • Excel ANOVA
    • Excel Merge Two Tables
    • Excel Conditional Formatting in Pivot Table
    • Dynamic Tables in Excel
    • Excel Sort by date
    • Excel Dynamic Range
    • Record Macro in Excel
    • Two Variable Data Table in Excel
    • Merge Cells in Excel
    • One Variable Data Table in Excel
    • Excel Fill Handle
    • CheckBox in Excel
    • Excel Table
    • Excel Combo Box
    • Auto Format in Excel
    • Advanced Filter in Excel
    • Excel AutoFilter
    • Excel Data Filter
    • Excel Data Validation
    • Excel Radio Button
    • Data Table in Excel
    • Text to Columns in Excel
    • Excel List box
    • Excel Solver Tool
    • Scrollbar in Excel
  • Excel Functions (12+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup Reference Functions in Excel (34+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (23+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (21+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED Training
  • EXCEL Training COURSE
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

Download Checkmark Excel Template

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

डाउनलोड Checkmark Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

Independence Day Offer - EXCEL ADVANCED Training Learn More