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.
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.
Explore your options, then double-click on one to insert it. You’ll now see a check mark in your cell.
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.
Find Duplicates in Excel