• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Check Mark in Excel

April 26, 2021 by Andrew Childress
Check mark in Excel

When you have a list of data in Excel, you might want to place check marks beside some of the values. Here's how to use check marks in Excel.

When you have a list of data in Excel, you might want to place check marks beside some of the values. This is an easy visual way to illustrate values that you’ve reviewed, for example. Let’s learn how to use check marks in Microsoft Excel.

How to Use Check Marks in Excel

Consider a list of test scores. A grade above 70 counts as a pass, and you want to illustrate this by placing a check mark next to those scores that are 70 and higher. Excel makes it easy to add check marks that instantly signify a pass/fail in this scenario.

To get started, click into the empty cell to the left of the first value in your list of scores. Then, go to the Insert tab on Excel’s ribbon.

On the far right side, you’ll see the Symbols dropdown. Go ahead and click on it. Two options will appear: Equation and Symbol.

Check mark Excel

Click on Symbol, and Excel will launch the Character Viewer menu. As you can see, there are numerous options here. These include emojis, math symbols, currency symbols, and more.

The easiest way to find a check mark is to click into the search box in the upper right corner, and type check. Hit Enter on your keyboard, and Excel will display several style options under the Unicode Name section.

Check mark in Excel

Explore your options, then double-click on one to insert it. You’ll now see a check mark in your cell.

Check marks Excel

From here, you can add checks to additional cells in a variety of ways:

  • Repeat the above steps and insert additional check marks
  • Click and drag on the lower right corner of the cell containing the check to copy the symbol down
  • Copying and pasting the check into other cells

As you can see, it’s easy to add check marks in Microsoft Excel.

Category: Excel TutorialsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Find duplicates in ExcelFind Duplicates in Excel
Next Post:Separate First and Last Name in ExcelHow to separate first and last names Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top