How to Insert a Check Mark in Excel: Symbols Checkboxes and Wingdings Options

You need to add a check mark to your Excel spreadsheet for tracking tasks or approvals. Excel provides several methods to insert a check mark symbol or an interactive checkbox. This article explains how to use the Symbol menu, Wingdings font, and Form Controls to add check marks.

Overview of Excel Check Mark Methods

Excel does not have a dedicated check mark button on the main ribbon. You must use one of three core features. The Symbol dialog offers the most straightforward way to insert a standard check mark character. The Wingdings font method is useful for applying a check mark style using a regular letter. For lists where you need to track completion with a click, the Form Control checkbox is the correct tool. These methods create either a static character or a dynamic control, but not both.

Static Symbols vs. Interactive Controls

A key decision is whether you need a symbol or a checkbox. A symbol is text. You can copy, delete, and format it like any other letter, but it does not change state. A Form Control checkbox is an object. You can click it to toggle between checked and unchecked, and link its state to a cell value. Checkboxes are ideal for dashboards or to-do lists. Symbols are better for printed reports or indicating a fixed status.

Steps to Insert a Check Mark Symbol

Use these steps to add a static check mark character to a cell.

1. Select the target cell
   Click on the cell where you want the check mark to appear.
2. Open the Symbol dialog
   Go to the Insert tab on the ribbon. In the Symbols group, click the Symbol button.
3. Find and insert the check mark
   In the Symbol dialog, set the Font dropdown to Segoe UI Symbol. Scroll down the character list. You will find several check mark variants. Select the standard check mark (✓) and click Insert. Close the dialog box.
4. Adjust size and alignment
   The symbol is inserted as text. Use the Font Size setting on the Home tab to make it larger. Center it in the cell using the alignment buttons.

Using the Wingdings Font Method

You can also type a letter and change the font to display as a check mark.

1. Type a lowercase p
   Select a cell and type a lowercase letter p.
2. Apply the Wingdings 2 font
   With the cell selected, go to the Home tab. In the Font group, open the font dropdown. Select Wingdings 2 from the list. The letter p will change into a check mark symbol.

Steps to Add an Interactive Checkbox

Follow this process to insert a clickable Form Control checkbox.

1. Show the Developer tab
   The Developer tab is not visible by default. Right-click on the ribbon and select Customize the Ribbon. In the right pane, check the box next to Developer. Click OK.
2. Insert the checkbox control
   Go to the Developer tab. Click Insert in the Controls group. Under Form Controls, click the checkbox icon. Your cursor will change to a crosshair.
3. Draw the checkbox
   Click and drag on the worksheet to draw the checkbox. Release the mouse to place it.
4. Edit the text and link the cell
   Right-click the new checkbox and select Edit Text to change its label. To capture its state, right-click the checkbox, choose Format Control, and go to the Control tab. In the Cell link field, click a cell to store the value. Clicking the checkbox will put TRUE or FALSE in that cell.

Common Mistakes and Limitations

Checkbox Is Not Clickable

If you cannot click a checkbox, you may be in Edit mode. Click on a different cell to exit Edit mode. Also, ensure you inserted a Form Control checkbox from the Developer tab, not an ActiveX control. ActiveX controls have different properties and may be disabled.

Symbol Changes Font When Copied

A check mark inserted via the Symbol dialog may change if you paste the cell into a workbook with different font settings. To prevent this, copy and paste the cell using Paste Special > Values. This pastes only the character, not the original font formatting.

Checkboxes Print Poorly

Form Control checkboxes are objects that float above cells. They may not align correctly when printing. Before printing, use Page Layout view to check positioning. You can also group multiple checkboxes to move them together.

Check Mark Symbol vs. Form Control Checkbox

Item	Check Mark Symbol	Form Control Checkbox
Type	Static text character	Interactive control object
Insert Method	Insert > Symbol or Wingdings font	Developer > Insert > Form Control
State Change	Manual edit required	Click to toggle checked/unchecked
Cell Link	Not applicable	Can link to a cell showing TRUE/FALSE
Best For	Static lists, printed reports	Interactive lists, dashboards, forms

You can now add both static and interactive check marks to your worksheets. Use the Symbol dialog for simple inserts or the Wingdings trick for quick formatting. For task lists you update often, the Form Control checkbox is the most efficient tool. Try using the linked cell from a checkbox in a COUNTIF formula to automatically tally completed items.