Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How To Insert Tick And Cross Marks Quickly In Microsoft Excel

Date:2021-8-2 Author:Sandra

How do you usually insert tick or cross symbols in Excel?  I’m sure you have your own way. The so-called multi-skills are not pressure. In our today’s tutorial, the author would introduce two methods about how to insert tick or cross marks in Excel. They are both interesting, and you probably haven’t used them yet.

Method 1:

Type O, P, Q, R in cells, and highlight them, and change the Theme Fonts into Wingdings 2.

How To Insert Tick And Cross Marks Quickly In Microsoft Excel

So in the theme font Wingdings 2, when you type O, it will change into a cross, P will be a tick, Q will be a cross in a box, and R will be a checkmark in a box.

How To Insert Tick And Cross Marks Quickly In Microsoft Excel

Note: You can not type any text after them, or it will be changed.  For example, if you type 156daf after the cross, the text would be changed into some other symbols.

How To Insert Tick And Cross Marks Quickly In Microsoft Excel

Method 2:

Hold Alt key and press 41409, there will show a cross. If you hold on Alt key and then you type 41420, there will be a checkmark.

How To Insert Tick And Cross Marks Quickly In Microsoft Excel

In this way, you can type any text after the tick or cross, and they would not be changed.

How To Insert Tick And Cross Marks Quickly In Microsoft Excel

So, that’s all about the two methods, don’t just inert symbols to get the tick or cross. Use these two interesting approaches as well.

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *