How to Insert a Checkmark in Microsoft Excel: 9 Steps

Table of contents:

How to Insert a Checkmark in Microsoft Excel: 9 Steps
How to Insert a Checkmark in Microsoft Excel: 9 Steps

Video: How to Insert a Checkmark in Microsoft Excel: 9 Steps

Video: How to Insert a Checkmark in Microsoft Excel: 9 Steps
Video: Excel Quick and Simple Charts Tutorial 2024, November
Anonim

This wikiHow teaches you how to insert a check icon in a box in a Microsoft Excel document. While not all fonts support this icon, you can use your computer's built-in Wingdings 2 font to add a check to any box on a spreadsheet.

Step

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

Step 1. Open Excel

Click or double-click the Excel icon, which looks like a white “X” on a dark green background.

If you want to open a specific document, double-click the document and skip the next step

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

Step 2. Click the Blank option

It's at the top of the Excel window. After that, a blank worksheet will be opened.

  • You can also select a template on this page and click “ Create ” from the displayed window.
  • Skip this step if Excel immediately displays a blank worksheet.
Insert a Check Mark in Excel Step 3
Insert a Check Mark in Excel Step 3

Step 3. Select the box

Click the box where you want to add a check icon.

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

Step 4. Click the Insert tab

This tab is on the green ribbon at the top of the Excel window. The toolbar will appear at the top of the window afterwards.

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

Step 5. Click Symbol

This option is at the far right of the toolbar. A new window will be opened after that.

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

Step 6. Click the “Font” drop-down box

It's at the top of the new window. After that, a drop-down menu will be displayed. If this option is not available, click the tab “ Symbols ” at the top of the new window first.

On a Mac computer, click the “ Bullets/Stars ” in the left column.

Insert a Check Mark in Excel Step 7
Insert a Check Mark in Excel Step 7

Step 7. Click Wingdings 2

It's in the "W" section of the drop-down menu. You may need to scroll down the drop-down menu to find it.

On Mac computers, swipe down the list of symbols in the right column

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

Step 8. Select the check mark

This sign appears at the bottom of the window. Click the mark once to select it.

  • If the check mark is not available, swipe up or down the list of symbols until you find the symbol before clicking on it.
  • You can also type 80 in the " Character code " field and press Enter to select the check mark automatically.
Insert a Check Mark in Excel Step 9
Insert a Check Mark in Excel Step 9

Step 9. Click Insert

It's at the bottom of the window. After that, a check mark will be added to the selected box in the worksheet.

Tips

If you want to convert the font of the entire Excel document to Wingdings 2, click the “ Home ”, click the font drop-down box, slide the drop-down menu down, and click “ Wingdings 2 ” on the menu. That way, you can copy and paste the checkmarks into the other boxes.

Recommended: