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!