Table of Contents
Knowing how to Insert a Check Mark in Excel is a useful skill, especially if you want your spreadsheets to look more organized and professional. Excel doesn’t make it as easy as it should to get to check marks, but we’re here to help. The check mark symbol is a special character that is often used in word processing files, spreadsheets, and other digital documents. If you’re using Microsoft Excel, you can use the Symbol dialog box, which has most of the common symbols used in Excel, to add this character. If you want to know more information about this issue so you can visit Microsoft Excel Official Website.
It’s pretty easy to add this character to word documents and programs that work with words, but what about a program like Excel, which works with numbers? In this article, we’ll look at the different ways to add a check mark to this program, from easiest to most difficult. You can use keyboard shortcuts or, if you’d rather, manually go to a symbols dialog box to make check marks in Excel. Let’s get right to learning how to Insert a Check Mark in Excel.
What is a check mark?
A check mark or tick mark is a symbol that is always used to indicate a positive answer, like “yes,” “done,” “correct,” etc. In Excel, the tick mark is treated as text. This means that you can change the color and size of the text just like you would with any other text, and you can change its location by using the standard Copy and Paste commands.
Check marks and check boxes are not the same thing. In Excel, a check box is an object that is put on a worksheet. Even though it looks like a check box is in a cell, it is not part of the cell and will not be deleted when the cell is deleted. You can move a check box around just like you would move any other object.
Why Use Check Marks in Excel?
- To indicate that a task has been completed. This is a common use for check marks, and it can be helpful for keeping track of progress on a project.
- To create a checklist. If you have a list of tasks that need to be completed, you can use check marks to indicate which tasks have been done and which ones still need to be done.
- To create a survey or poll. You can use check marks to allow people to select their answers to a question.
- To add visual interest to a spreadsheet. Check marks can add a bit of visual interest to a spreadsheet, and they can also make it easier to scan and understand the data.
How to Insert a Check Mark in Excel
Using the Symbol Command
- Open the part of the Excel sheet where you want to put the check mark.
- Click the cell where you want to put the checkmark.
- Go to the “Insert” tab at the top of the screen on the Excel ribbon.
- Click the “Symbol” button in the “Symbols” group. There will be a drop-down menu.
- From the menu that drops down, choose “More Symbols.” There will be a pop-up box.
- Make sure the “Symbol” tab is chosen in the “Symbol” dialog box.
- From the “Font” drop-down menu, pick “Wingdings.” The check mark symbol is part of the Wingdings font.
- Scroll through the list of symbols until you find the check mark (✔).
- To choose it, click on the check mark.
- Click the “Insert” button to add a check mark to the cell you have chosen.
- To close the “Symbol” dialog box, click the “Close” button.
Using the Keyboard Shortcut
- Open the Excel sheet where you want to put the check mark.
- Click the cell where you want to put the checkmark.
- Put the cursor where you want it to be.
- Press the “Alt” key on your keyboard and hold it down.
- Type “0252” on the number pad (not the numbers at the top of the keyboard) while holding down the “Alt” key.
- When you let go of the “Alt” key, a check mark (✓) will show up in the cell.
Using Conditional Formatting
- Open the part of the Excel sheet where you want to put the check mark.
- Choose the cell or cells where you want to put the check mark.
- Go to the Excel ribbon and click on the “Home” tab.
- In the “Styles” group, click “Conditional Formatting.”
- From the list of options, choose “Icon Sets.”
- Another menu will show up with different sets of icons. Choose the set that has a symbol for a check mark (✔️).
- If the condition for the icon set is met (for example, the value is greater than a certain number), the check mark will automatically appear in the selected cell.
Using Custom Formatting
- Open the part of the Excel sheet where you want to put the check mark.
- Click the cell where you want to put the checkmark.
- Right-click on the cell and choose “Format Cells.”
- Go to the “Number” tab in the “Format Cells” box.
- Choose “Custom” from the list of available options.
- In the “Type” box, type “;;;” (without the quotes) as a custom format.
- Click “OK” to use the custom format, and the check mark will appear in the cell.
Benefits of Using Check Marks in Excel
- Visual Clarity: Check marks provide a clear visual representation of completed tasks, status, or decisions, making it easy to identify which items have been addressed.
- Efficient Communication: Check marks allow you to communicate information concisely, especially when dealing with simple yes/no, done/undone, or approved/rejected scenarios.
- Data Analysis: You can use check marks as a data point for analysis, filtering, or sorting to gather insights on completed tasks, completed stages, or completed items.
- Conditional Formatting: You can apply conditional formatting to cells with check marks, making it easy to highlight completed items, overdue tasks, or important milestones.
- To-Do Lists and Checklists: Check marks are commonly used in to-do lists and checklists, enabling users to track progress and manage tasks effectively.
- Project Management: When managing projects or workflows, check marks can signify completed phases or project milestones, helping project managers and team members stay on track.
- Collaboration: When multiple users are collaborating on an Excel sheet, check marks offer a simple way to communicate the status of various items without relying on complex explanations.
Questions and Answers
A check or check mark (American English), checkmark (Philippine English), tickmark (Indian English), or tick (Australian, New Zealand, and British English) is a mark (,, etc.) used mostly in the English-speaking world to mean “yes” (for example, “yes, this has been checked” or “yes, that is the right answer”).
This is one of the quickest and easiest ways to add a checkmark or a cross to a Word document. To do this, just click on one of the checks or crosses below, copy it, and then paste it where you need it. From here, just press Ctrl+C to copy the symbol you want and Ctrl+V to paste it where you want it.
An ellipsis could be used to say, “Well, this is awkward.” People often use those three dots to show that something is awkward or uncomfortable without saying so. It means that they think the conversation has gone in an uncomfortable direction, but they might not feel comfortable enough to say so.
Note that you must use the ANSI code 252 to get the check mark with this formula. This would work if you used the keyboard shortcut ALT 0252, the formula =Char(252), or copied and pasted the check mark that was made using those methods.