How to insert a check mark in Excel: 9 steps (with pictures)

Table of contents:

How to insert a check mark in Excel: 9 steps (with pictures)
How to insert a check mark in Excel: 9 steps (with pictures)
Anonim

Excel, which is the Microsoft office suite spreadsheet, makes it easy to track activities. In addition to being able to make graphs, tables, not to mention formulas that make your monitoring dynamic, you can also use a specific font as needed. For example, you can use the check mark character found in the Wingdings 2 font to identify actions performed in an activity report.

Steps

Insert a Check Mark in Excel Step 1
Insert a Check Mark in Excel Step 1

Step 1. Go to Excel

Double-click the Excel icon which is a green icon with a white "X" inside. This icon should be on the Office or in the file tree.

If you need to use a specific file, open it and don't worry about the next step in this article

Insert a Check Mark in Excel Step 2
Insert a Check Mark in Excel Step 2

Step 2. Tap the New Workbook icon

When you are on the spreadsheet home page, click on the icon New workbook which is at the top left to open a new worksheet.

  • If you want to use a template, select it, then click To create in the window that appears.
  • Don't worry about this step, if Excel opens directly to a blank workbook.
Insert a Check Mark in Excel Step 3
Insert a Check Mark in Excel Step 3

Step 3. Click in a cell

In the worksheet, select a cell where you want a check mark to appear.

Insert a Check Mark in Excel Step 4
Insert a Check Mark in Excel Step 4

Step 4. Go to the Insert menu

Click in the ribbon at the top of your sheet on the tab Insertion to display the latter's toolbar.

Insert a Check Mark in Excel Step 5
Insert a Check Mark in Excel Step 5

Step 5. Select the Symbols icon

In the toolbar, tap the icon Symbols which is on the far right.

Insert a Check Mark in Excel Step 6
Insert a Check Mark in Excel Step 6

Step 6. Scroll down the drop-down list

Click on the drop-down menu arrow Police tab Symbols from the window Special characters. You will see the list of fonts.

  • For Mac, click Bullets / Stars in the left column to see the list of different special characters.
Insert a Check Mark in Excel Step 7
Insert a Check Mark in Excel Step 7

Step 7. Choose the Wingdings 2 font

From the list of fonts, select Wingdings 2 which is near the end, because the fonts are listed alphabetically.

For Mac users, scroll through the list of characters in the right column

Insert a Check Mark in Excel Step 8
Insert a Check Mark in Excel Step 8

Step 8. Click on the check mark symbol

You should find the symbol easily by browsing the font list Wingdings 2. Once you find the check mark, click on it.

  • If you can't quickly find the check mark symbol, take the time to scroll through the different characters in the list.
  • To go faster, know that the character code is 80. You just have to enter in the field Character code the number to directly select the symbol. Then, all you have to do is press the Enter key on your keyboard to insert it into the cell of the worksheet.
Insert a Check Mark in Excel Step 9
Insert a Check Mark in Excel Step 9

Step 9. Press the Insert button

After selecting the symbol, click Insert at the bottom of the window so that the checkmark appears in the cell you selected.

Advice

  • If you want to insert the check mark in other cells by doing a "copy / paste", you must change the font of the cells. To do this, select the cell, click on the tab Home, then in the field Font from the toolbar, scroll through the different fonts and choose Wingdings 2.

Warnings

  • Note that not all fonts take the check mark into account. If you change the font of the document, you may lose the display of the check mark. It will then be necessary for each cell, where you wish to have a check mark, put back the font Wingdings 2.

Popular by topic