4 Ways to Use a Check Mark in Excel:
There can be many reasons for using check marks in Excel. In some cases, you might want a way to place a check mark image in a cell containing other text, or in the cell itself.
More interactive ways to use check marks in Excel could be to accept selection input from the user or as an automated way to indicate that a completed function or a row is true.
Regardless of how you want to use it, there are ways you can integrate check marks into your Excel spreadsheet.
keyboard shortcut for check mark
If you need to insert a checkmark in a cell, either as part of existing text or by itself, using keyboard shortcuts The easiest way is to use check marks in Excel.
There are two Wingdings2 characters that work well for inserting a check mark in Excel. To use these, you need to right-click on the cell and change font style To wingdings2.
Once the cell is formatted, simply hold down the Shift key and press P. here is the keyboard shortcut slip away + p.
This will insert a checkmark character into the cell. You can also put it at the end of any line of text in a cell.
Another character is the opposite of the check mark, an “x” where you can signify negative feedback. Hold down the Shift key and press O. here is the keyboard shortcut slip away + hey.
This will insert an “x” character into the cell.
For a quick list where you need to add a positive or negative answer, these two Excel check marks do the trick.
Other Wingdings2 keyboard codes include the following.
- shift + r: check mark in a box
- shift + q, shift + s, shift + t: Different styles of “x” inside a box
- Shift + V, Shift + U: different styles of “x” inside a circle
If you need more variety, format the cells in wingdings font instead.
This lets you use up to four possible check mark keyboard shortcuts.
- Alt 0252: standard check mark
- Alt 0254: check mark inside a box
- Alt 0251: standard “x” sign
- Alt 0253: “x” inside a box
To use these keyboard codes, hold down Alt Type a four digit number using the key and then digit numeric pad.
As you can see there are a lot of options and styles to use for using check marks in Excel.
Prefer to use CHAR function instead? not a problem. Simply select the cell where you want to place the symbol and type one of the following functions.
- =four(252): standard check mark
- =char(254): check mark inside a box
- =four(251): standard “x” sign
- =four(253): “x” inside a box
press recorded And check mark will appear in that cell.
enter check mark symbol
There are several check mark symbols that you can insert using the Segoe UI Icons font. To do this, select insert choose more from the menu symbol Icon from the ribbon. Then, choose symbol from dropdown.
it will open symbol Window. change to Font dropdown to drop sego ui icons.
If you scroll through the list of symbols for this font, you’ll see several check mark styles scattered throughout. A section has both a check mark and an “x” style mark in an area.
However, if you want to use a different style, feel free to scroll through.
When you find the check mark you want, just select insert And that symbol will be inserted directly into the excel cell where you placed the cursor.
This is an easy way to use check marks in Excel if you don’t remember any of the code and want to browse through a variety of styles.
Paste Check Marks in Excel
If you don’t want the hassle of codes or fonts, a quick and easy way is to use check marks in Excel. copy and paste this.
If you search for “check mark” in Google, you will see the check mark symbol listed first in search results.
You can copy this symbol directly into the results by highlighting and pressing Ctrl + C. Then, return to your Excel spreadsheet, select the cell where you want to place the check mark, and paste it by pressing Ctrl + V.
Autocorrect a keyword with a check mark
You can forget about all the symbols or menus mentioned above and just use your own special phrase wherever you want to put a checkmark.
For example, you can create your own AutoCorrect response in Excel that replaces your keyword (something like “CMARK”) with a check mark symbol.
To do this, put a checkmark in your sheet using one of the above methods. Once you have only one in a sheet, you can use it as part of AutoCorrect.
1. Select the cell and copy the check mark to the formula bar.
2. Right-click on the cell and check the font of the cell. Note it down for later.
3. Select file, Then the option, Then proofing, And finally autocorrect option.
4. In the AutoCorrect window, enter the word (such as “CMARK”) To change field. Then, select Together field and press Ctrl + V to paste the check mark symbol you copied from the Excel formula bar earlier.
Choose to link and then Okay to finish.
Now, whenever you type “CMARK” and press recorded, the text will automatically turn into a check mark.
This is one of the easiest ways to use check marks in Excel, especially if you use them frequently and don’t want to remember keyboard shortcuts, codes, or anything else.
Why Use Check Marks in Excel?
There can be many reasons for using check marks in Excel. Whether you’re trying to track project tasks or asking people to fill out a survey for you—there are tons of options.
Choose the method of adding check marks to your spreadsheet that is most convenient for you.