How to Insert a Check Mark in Excel: 6 Easy and Useful Methods
Microsoft Excel lets you add various visual elements to your workbook. One of the most used ones for projects, tasks, quality tests, or even to-do lists is a check mark. Today’s tutorial will quickly guide you through how to insert a check mark in Excel to make your spreadsheets beautiful and meaningful.
Insert a Check Mark in Excel: Using Bullets
- Click on the Insert menu on the Excel ribbon.
- Go to the Text commands section and click on the Text Box function.
- You’ll see that the cursor has changed to a sword icon.
- Click anywhere and drag a rectangular box.
- Now, type a list of things.
- Select the entire list and right-click.
- Choose Bullets on the context menu and select the check mark bullets.
- A tick mark will appear beside each item.
Insert a Check Mark in Excel: Using Symbols
- Select any cell or double-click on any data.
- Choose Insert from the Excel menu and then click on Symbol.
- Select Windings 2 as a Font inside the Symbol dialog box.
- You should see the check mark on your screen.
- Select it and click Insert to add the check mark.
Insert a Check Mark in Excel: Using a Function
- Copy-paste the following formula on any cell:
= CHAR(252)
- Hit Enter and then change the cell font to Windings.
- You’ll get your check mark (a black tick mark).
- You can also use the below function to get a boxed check mark:
=CHAR(254)
Insert a Check Mark in Excel: Using Shortcuts
- Click on any cell on your Excel workbook.
- Now press the Alt key and type the number 0252 and release the Alt key.
- Change the cell font to Windings.
- The check mark will appear within the cell.
- You can alternatively use the number 0254 for a boxed check mark.
Note: You’ll need to use the numpad to type the numbers. If the keyboard doesn’t come with a numpad, this method won’t work for you.
Insert a Check Mark in Excel: Using Icons
- Icons are the latest additions to the latest version of Excel.
- You’ll find them in the Illustrations command section of the Insert menu.
- Click on Insert on the Excel ribbon menu to find some professional icons.
- On the Icons menu search bar, type in Check to find tick marks.
- Add the check mark that you want.
- Excel will add these icons as an overlay on cells.
- You can right-click on the icons to modify the color and other properties.
Note: This method is only applicable to the users with Excel for Microsoft 365.
Insert a Check Mark in Excel: Using Conditional Formatting
- Select a range of values on your spreadsheet.
- Click on Conditional Formatting and choose the check mark from Icon Sets.
- Again, Go to Conditional Formatting and now choose Manage Rules.
- Click on Edit Rule and customize the formatting rule to show a check mark for certain values.
Conclusion
So far, you’ve learned different ways to add a check mark in Excel. Hence, we hope that the tutorial has answered your query about how to insert a check mark in Excel. However, you need to put the methods into regular use to master the skill.
You may also be interested in learning the best 3 methods to delete blank rows in Excel.
