Excel Worksheet Tips: Adding ticks and crosses

Have you created a list and you want to tick off an item?

1. Select the cell you wish to add the tick to.
2. Change the font to “webdings”
3. To enter a tick – enter the letter a. To enter a cross – enter the letter r.
4. To change the colour of the tick to green or the cross red automatically, you will need to do some conditional formatting. Select “create new rule”.
5. Choose the option “Format only cells that contain”.
6. In the “Edit the Rule Description” box, in the first drop down box, select “specific text”, in the second drop down box, select “containing”.
7. In the final box, enter the letter a. Then click the format button.
8. Ensure you have the font tab selected and choose the colour to be green, so that when a tick is entered, it goes green.
9. For a cross – Repeat step 6 and modify step 7, and enter the letter r. Change the colour to red.

That’s how to enter a tick and cross into excel.

Come check out the directory for the rest of my excel tips!



Posted by:submeg

Musician, Writer and Inspirer. I discuss the projects I am working on, the services I provide and my general thoughts.

4 replies on “Excel Worksheet Tips: Adding ticks and crosses

  1. very usefull tips. I have a lot of course participants that ask for features like that. So once again thank you for sharing this tip with me and my course participants:)


  2. I am doing a questionnaire to send to my clients.. i would like for them to click in the ‘yes’ or ‘no’ column and the tick or cross will appear… if that makes sense? please could someone help ..


Tell me what you think!

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s