76. Excel Tips - Get Tick Or Cross

Nick's picture

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:




  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:

get-tick-or-cross.xls41 KB