How to insert a tick symbol (checkmark) in Excel

This tutorial explores six methods for inserting checkmarks in Excel, along with formatting and counting techniques. Excel offers two checkmark types: interactive checkboxes and tick symbols. Checkboxes allow selection/deselection via mouse clicks (see separate instructions for checkbox insertion). Tick symbols (✓) are static characters representing "yes" or similar affirmation. Cross marks (x) can also be used, often indicating negation.

Several methods efficiently insert tick symbols across Excel versions:

• Using the Symbol Command:

  1. Select the target cell.
  2. Navigate to the Insert tab > Symbols group, click Symbol.
  3. In the Symbol dialog, choose Wingdings font.
  4. Select the desired checkmark, click Insert, then Close. The character code (e.g., 252 for ✓) is displayed; this is useful for formulas. Insert checkmarks into empty cells or existing text.

• Using the CHAR Function: Insert checkmarks into empty cells using formulas (Wingdings font required): =CHAR(252) (✓), =CHAR(254) (✓ in a box), =CHAR(251) (x), =CHAR(253) (x in a box). Copy and paste values to remove formulas.

• Typing Character Codes: With NUM LOCK on, use the numeric keypad: Alt 0252 (✓), Alt 0254 (✓ in a box), Alt 0251 (x), Alt 0253 (x in a box). Wingdings font is necessary.

• Keyboard Shortcuts: Use Wingdings 2 or Webdings fonts and these shortcuts: See table below for shortcut keys and corresponding symbols.

• AutoCorrect: Automate checkmark insertion:

  1. Insert a checkmark using any method.
  2. Copy it from the formula bar (Ctrl C).
  3. Go to File > Options > Proofing > AutoCorrect Options….
  4. In AutoCorrect, link a word (e.g., "tick") to the copied symbol. Type the linked word; apply the correct font (e.g., Wingdings).

• Inserting as an Image: Copy and paste images of checkmarks from external sources. Examples are provided below.

Formatting and Counting:

• Formatting: Format checkmarks like regular text (bold, color, etc.).

• Conditional Formatting: Create rules based on the presence of checkmarks (using =CHAR(252) in the formula).

• Counting: Use =COUNTIF(range,CHAR(252)) to count checkmarks. For checkboxes, link them to cells and count TRUE values.

Keyboard Shortcuts Table (Wingdings 2 & Webdings):

Font	Shortcut	Tick Symbol	Font	Shortcut	Tick Symbol
Wingdings 2	Shift P		Webdings	a
Wingdings 2	Shift R		Webdings	r
Wingdings 2	Shift O
Wingdings 2	Shift Q
Wingdings 2	Shift S
Wingdings 2	Shift T
Wingdings 2	Shift V
Wingdings 2	Shift U

This enhanced description provides a clearer, more organized explanation of the various methods.

The above is the detailed content of How to insert a tick symbol (checkmark) in Excel. For more information, please follow other related articles on the PHP Chinese website!