Insert a Check Mark in Excel

You can add check marks (✓), crosses (✗), or clickable checkboxes in Excel to create things like to-do lists or tracking sheets.


1. Insert a Check Mark

Steps:

  1. Select a cell (e.g., A1)
  2. Press Shift + P → you’ll see “P”
  3. Change the font to Wingdings 2

✅ Result: A check mark appears

👉 Make it nicer:

  • Change color → Green
  • Increase size
  • Make it Bold

2. Insert a Cross (X)

Steps:

  1. Press Shift + O
  2. Change font to Wingdings 2

✅ Result: A cross (✗)

👉 You can color it Red for better visibility


3. Align the Symbol

  • Go to Home → Alignment
  • Click:
    • Center (horizontal)
    • Middle Align (vertical)

Your check mark is perfectly centered


5. Insert Check Mark from Symbols

Steps:

  1. Go to Insert → Symbol
  2. Choose font: Wingdings 2
  3. Select a check mark
  4. Click Insert

👉 You can also find:

  • Boxed check marks ☑
  • Other symbols

6. Quick Copy Method

You can simply copy this:

Then paste into Excel (Ctrl + V)


7. Use Check Mark in a Formula

You can display a check mark automatically.

Example:

👉 If value > 500 → show ✓
👉 Otherwise → show nothing


8. Insert Clickable Checkboxes

You can add real checkboxes:

Steps:

  1. Enable Developer tab (if not visible)
  2. Go to Developer → Insert
  3. Choose Checkbox
  4. Click in the sheet to place it

✅ Now users can click to check/uncheck