Using Checkmarks in Excel

Carol’s Corner Office Blog recently had a great trip on how to add checkmarks to an Excel spreadsheet. Carol explains:

I receive lots of e-mail from subscribers asking me if they can put checkmarks into the cells in their MS Excel spreadsheets. The short answer is yes!

There are several ways to place checkmarks in the cells of your MS Excel spreadsheets. Follow the steps below to learn how:

Note – Depending upon your version of MS Excel and Windows, you may not have some of the fonts below.

  1. Type a lower case a and change the font to Marlette or Webdings.
  2. Type an upper case P and change the font to Wingdings2.
  3. Hold down the ALT key and type 251.
  4. Click on Insert | Insert Symbol and scroll down and click on the checkmark. Click on Insert | Close | Enter.
  5. Hold down the ALT key and type 0252 and change the font to Wingdings.

I know that this is probably not something you need to do often, however, if you need a checkmark, you now know several ways to accomplish this. Check out Carol’s complete post. It contains 6 different ways for you to add checkmarks to your spreadsheet.