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

How To Insert Tick And Cross Mark Quickly In Excel

Date:2021-9-13 Author:Sandra

There are at least 6 ways to insert tick and cross symbols in Excel or Word. I guess you know at least one or two of these methods. But the method I want to talk about is the very unusual one.

Let’s take the table below as an example.

How To Insert Tick And Cross Mark Quickly In Excel

Select the area from cell B2 to cell B9, and go to the Data tab to choose Date Validation.

How To Insert Tick And Cross Mark Quickly In Excel

Allow List and type R, S in the Source box like below.

How To Insert Tick And Cross Mark Quickly In Excel

After hit OK, we need to change the font into Wingdings 2.

How To Insert Tick And Cross Mark Quickly In Excel

If you choose R in the list, there will appear a tick in a box; if you choose S, there will be a cross symbol.

How To Insert Tick And Cross Mark Quickly In Excel
How To Insert Tick And Cross Mark Quickly In Excel
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 *