Ticks and Crosses

I used to have a colleague who liked me to create reports which visually showed her, using ticks and crosses, which of her clients sold which products.

The report looked something like this:

To create the ticks and crosses I first selected the cells in which they were to appear, and changed the font to Webdings. You can change the font using the dropdown box in the Font group on the Home tab on the Ribbon.

The first time I entered a tick and a cross I used the Insert Symbol method I covered here two days ago. However those particular symbols correspond to letters. I was able to find out what those letters were by clicking on the cell I entered the symbol in and looking in the formula bar. As you can see below the tick corresponds to the letter a, and the cross corresponds to the letter r.

So, to complete the report all I had to do was type an a where there should be tick, and an r where there should be a cross.

Leave a comment

Your comment