How To Put Check Mark In Excel

Excel is probably one of the best productivity applications out there. While users predominantly use it for professional reasons, you can use the application for personal use such as creating a to-do list. 

If you’re creating a list in Excel, you could add a checkmark next to the completed items. This will not only make your spreadsheet visually more appealing but, will also help you keep track of your lists.

There are three types of checkmarks you could add in Excel. One of the methods is to add a checkmark as a symbol while the second one involves using the Developer tab to insert a checkbox and add a checkmark. Similarly, you could also enter checkmarks as an icon! 

Depending on your needs, you can use either one of these methods to add a checkmark on your sheet.

Insert Checkbox

Checkboxes will be a great addition to your document if you’re creating a to-do list. Checkboxes in MS Office are interactive. Whenever you complete a task from your list, you can simply click on the inserted box for a checkmark to appear.

To insert a checkbox, you need to first enable the Developer tab.

Step 1: Enable Developer Tab

  1. Head to File > Options.
    Excel Options
  2. From the sidebar, select Customize Ribbon.
  3. Under Customize the ribbon, select Main tab.
  4. Select the box next to Developer.
    Enable Developer Tab
  5. Click OK.

Step 2: Insert Checkbox in the Grid

  1. Head to the Developer tab.
  2. Select Insert.
  3. Click on the checkbox under Form Controls.
    Insert checkbox from developer tab Excel
  4. On the grid, click anywhere you wish to insert the checkbox.
    Insert Checkbox Excel
  5. Change the name of your item. You can also make the changes later by right-clicking on the checkbox item.
    Insert Checkbox in Excel
  6. Repeat steps 3 and 4 for all of your checkbox elements.

Step 3: Put Check Mark

Put Check in Excel

To insert a check mark, simply click on the empty checkbox. You can remove the check mark by clicking on the box again.

Insert Check Mark as Symbol

An easy way to add a checkmark in your spreadsheet is by inserting it as a symbol. Unlike adding a checkbox, symbols are static and non-interactive.

  1. Open your workbook.
  2. Head to the Insert tab and select Symbol.
    Symbol MS Excel
  3. Next to Font, choose Wingdings.
  4. Enter either 252 or 254 next to character code.
    Insert Check Symbol Excel
  5. Click Insert.

(Note: Character code 252 is a checkmark while character code 254 is a checkmark in a squared box.)

Insert Check Mark as an Icon

If you intend to use a checkmark for purely decorative purposes, you could insert it as an icon. You can resize your icon from the anchor points and even format them.

  1. Open your worksheet.
  2. From the Illustration section, select Icons.
    Insert Icons in Excel
  3. In the search bar, enter Check.
  4. Choose an icon and select Insert.
    Insert icon Excel
  5. Resize the icon and format the icon as you desire from the Graphics Format tab.

Add a Comment

Your email address will not be published. Required fields are marked *