4 Ways to Use a Check Mark in Excel

There are many reasons why you may want to use a check mark in Excel. In some cases, you may want a way to place an image with a check in a cell with other text or in a cell by itself.

More interactive ways to use check marks in Excel can be to accept selection input from a user or as an automatic way to indicate that a completed task 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.

Checkmark shortcuts

If you just need to insert a check mark into a cell, either as part of an existing text or on its own, using keyboard shortcuts is the easiest way to use a check mark in Excel.

There are two Wingdings2 characters that work well for inserting check marks in Excel. To use it, you need to right click on the cell and change the font style to Wingdings2

Once the cell is formatted, hold down the Shift key and press P. The keyboard shortcut here is: Shiftp

Inserts a check mark in the cell. You can also insert this at the end of each line of text in the cell.

Another sign is the opposite of a check mark, an “x” where you can symbolize a negative reaction. Hold down the Shift key and press O. The hotkey here is ShiftO

Inserts an “x” sign into the cell.

For a quick list where you need to add a positive or negative answer, these two Excel ticks will suffice.

Other Wingdings2 keyboard codes include the following.

  • Shift + R: check mark in a box
  • Shift + QShift + SShift + T: Different styles of “x” in a box
  • Shift + V, Shift + U: Different styles of “x” in a circle

If you need more variety, format the cells in the Wingdings font instead.

This allows you to use four possible keyboard shortcuts for the check mark.

  • ALT 0252: Default checkmark
  • ALT 0254: check mark in a box
  • ALT 0251: Default “x” character
  • ALT 0253: “x” in a box

To use these keyboard codes, hold the ALTO key, then type the four-digit number using the numeric keypad

As you can see, there are plenty of options and styles to use for using check marks in Excel.

Prefer to use the CHAR function? No problem. Just choose the cell where you want to place the symbol and type one of the following functions.

  • =CHARACTER(252): Default checkmark
  • =CHARACTER(254): check mark in a box
  • =CHARACTER(251): Default “x” character
  • =CHARACTER(253): “x” in a box

Press Enter and the check mark appears in that cell.

Insert checkmark symbols

There are several checkmarks that you can insert with the Segoe UI Symbol font. To do this, select Insert from the menu and choose the symbols ribbon icon. Then select Symbol from the drop-down list.

This opens the Symbol window. change the Font style dropdown to Segoe UI Symbol

As you scroll through the list of symbols for this font, you will see several check marks scattered throughout the font. One section has both check marks and the “x” style markers in one area.

However, feel free to scroll if you want to use a different style.

When you find the checkmark 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 a checkmark in Excel if you don’t remember any of the codes and want to browse through a wider variety of styles.

Paste a check in Excel

If you don’t want to mess with codes or fonts, you can use a checkmark in Excel quickly and easily by copying and pasting it.

If you search for ‘check mark’ in Google, you will first see a check mark in search results

You can copy this symbol directly in the results by highlighting it and pressing Ctrl C† Then return to your Excel spreadsheet, select the cell where you want to put the check mark and paste it by pressing Ctrl V

Automatically correct a keyword with a checkmark

You can forget about any symbols or menus explained above and just use your own special phrase where you want to put a check.

For example, you can create your own autocorrect answer in Excel that replaces your keyword (something like “CMARK”) with the check mark.

To do this, place a checkmark in your sheet using one of the methods above. Once you only have one in the sheet, you can use it as part of an autocorrect.

1. Select the cell and copy the check mark in the formula bar.

2. Right click the cell and check the cell font. Note this for later.

3. Select Filethen Optionsthen proofingand finally AutoCorrect Options

4. In the AutoCorrect window, enter the word (such as “CMARK”) in the To replace field. Then select the Of field and press Ctrl + V to paste the check mark you copied earlier from the Excel formula bar.

Select To add and then Okay to finish.

Now whenever you type “CMARK” and press Enterthe text automatically changes to a check mark.

This is one of the easiest ways to use a check mark in Excel, especially if you use them often and don’t want to remember keyboard shortcuts, codes, or anything else.

Why use check marks in Excel?

There are many reasons why you may want to use check marks in Excel. Whether you’re trying to keep track of project tasks or have people fill out a survey for you, there are plenty of options.

Choose the method of adding checkmarks to your spreadsheet that’s most convenient for you.

Leave a Reply

Your email address will not be published.