You want to use a special character in Excel, but you don't know how to find it:

• Help is at hand with a combination of
  • CHAR()
  • ROW()
  • Text formatting

Finding how to enter a tick or a cross in Excel could drive you crazy, but fortunately, there's a useful way of displaying a whole load of characters quickly.

Here's a screen shot of what it looks like in Excel:

Steps:

1. In the first row, enter the following formula:  =CHAR(ROW())
   • The ROW function returns the row that the calculation is occurring in
   • The CHAR function returns a character based on a number from 1 to 255
2. Copy that down 255 rows
3. Format that column as Windings 

Now, you will see all the characters that the Windings font has to offer.

• Repeat for other fonts, and explore their characters
• You will be amazed how many characters there are

Download sheet to practise how to Get a Tick Or Cross in Excel

Training Video on how to Get a Tick Or Cross in Excel: