Please Note: This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here: Typing Check Marks into Excel.

Typing Check Marks into Excel

by Allen Wyatt
(last updated November 13, 2014)

It is not unusual to use an Excel worksheet to create different types of checklists and forms that are used by other people. When you are developing your checklist, you may want to actually put a check mark into a cell. There are several ways you can go about doing this. Both methods involve changing the font applied to a cell and then typing the character you want in the cell.

For instance, try these steps:

  1. Select the cell that you want to contain the check mark.
  2. Using the Font drop-down list, select Wingdings. The cell is now formatted to use the Wingdings font.
  3. Start the Character Map accessory included with Windows. (See Figure 1.) (Click on Start, then All Programs, then Accessories to find the program; you may need to look under System Tools to find it.)
  4. Figure 1. The Character Map accessory.

  5. In the Character Map, select the Wingdings font.
  6. Scroll though the available characters until you find the check mark you like.
  7. Copy the character to the Clipboard. (The controls in the Character Map accessory allow you to do this, although the controls differ from one version of Windows to another.)
  8. Close the Character Map accessory.
  9. In Excel, press Ctrl+V to paste the character into the cell.

This is quite a few steps to put in a simple check mark. There is a simpler way, however, if you simply remember that you need to pick a font that contains check marks, and then put in the character to produce that check mark.

When it comes to fonts containing check marks, there are quite a few. The appearance of the check mark will depend on the font you use. The following information shows what you would type (on the keyboard) in various fonts to achieve a check mark:

Character to Type Font to Use
a Marlett
a Webdings
b Marlett
C Erilogo
P Wingdings 2
Alt+129 Wingdings
Alt+0214 Symbol
Alt+0252 Wingdings

For those instances where an Alt combination is mentioned, you simply need to hold down the Alt key as you type the three or four numbers on the keypad.

There are undoubtedly numberless other character/font combinations that will result in a check mark in a cell. If you want to do your own exploring, you can use the Character Map accessory to look around through different fonts to find out what is available. (You can also find different fonts containing check marks at some Web sites, such as www.dingbatpages.com.)

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (3201) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Typing Check Marks into Excel.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He  is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Defining a Name

One of the great features of Excel is that it allows you to use named ranges. These can make your formulas much easier to ...

Discover More

Adjusting the Width of Characters

Need to adjust how your characters look horizontally? Word provides an easy way you can scale the horizontal appearance of ...

Discover More

Defining Styles

Styles are a powerful component of Word. You use them to determine the way that your text should appear. This tip explains ...

Discover More

Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out Mastering VBA for Office 2010 today!

MORE EXCELTIPS (MENU)

Inserting Dashes between Letters and Numbers

If you need to add dashes between letters and numbers in a string, the work can quickly get tedious. This tip examines some ...

Discover More

Creating New Windows

If you need to look at different parts of the same worksheet at the same time, the answer is to create windows for your data. ...

Discover More

Selecting Formulas

Want to select only the formulas in your worksheet? It's easy to do using the Go To Special dialog box.

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments for this tip:

There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)

This Site

Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.

Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.

Links and Sharing
Share