Before you go, check out these stories!

0
Hackernoon logoHow To Add A Check Symbol In Excel and Word by@5amily

How To Add A Check Symbol In Excel and Word

Author profile picture

@5amily5amily

We are a well-established online store offering customized goods and merchandise for passionate people.

If you use Microsoft Word and Excel frequently, you might have repeatedly had the question of how to add symbols such as the tick or checkmark in your document or spreadsheet. Keep reading to learn about the various shortcuts you can use to make these routine tasks take less time and effort.

In this article we provide you with the handy tips and tricks necessary to add a tick or a cross into your Microsoft Word or Excel project.

Copy and Paste Method

This technique is possibly the simplest and fastest method of inserting a tick or a cross into your Microsoft document. The only thing you need to do is copy and paste the symbol where desired. To do this on a phone, long tap on whichever symbol below catches your fancy and highlight it. Press the "Copy" option. Then open your Excel sheet and long tap on the cell of choice. Press "Paste".

To do this on a computer, drag your mouse from the beginning of your symbol of choice to the end and highlight it. Right-click and select "Copy", or press Ctrl + C on the keyboard. Then open your Excel sheet. Right-click on the cell of choice and select "Paste", or press Ctrl + V on the keyboard.

The symbols you can copy and paste are given below:

?

Symbol Command Method

If the option above isn't for you, then the Symbol Command method is another possible way you might use to achieve the same result. In order for this to be successful, you will need to ensure that you have Microsoft Excel installed to your system. Navigate to the main Excel menu and go to "Insert". Then, go to "Symbol", select the "Font" option, and then opt for "Wingdings". Now you should be able to see that the tick mark you need is located at the bottom of the list.

A second way to access this is to go to the "Start” menu. You'll find this situated the "Character Map" portion, within System Tools. Select the "Font" option and choose "Wingdings". After doing this, hover with your mouse over the symbol of choice. You can do this by taking your cursor over to the symbol, without clicking on it. This will make the symbol enlarge, and from here you can select from the range of different versions of the tick mark available. Decide which one you think you want to use, and then copy the icon through the method described above and paste it within your text or sheet wherever required.

Tick Symbol Character Code Method

A second method of carrying out any of the above is via the use of the character code of the tick symbol. In this technique, you will be required to use the numerical keypad, usually located on the right hand of your keyboard. This will allow you to insert four various check marks.

This can be achieved through the following steps:

Step 1: The first step is to choose the font called 'Wingdings'.

Step 2: The second thing you need to do is to use the numerical keypad on your keyboard. Hold down the 'Alt' key and select one of the numbers shown below to enter:

Ticks:

• ALT + 0252

• ALT + 0254

Crosses:

• ALT + 0251

• ALT + 0253

NOTE: It's important to remember to make sure that you've chosen the 'Wingdings' font in order for the character codes mentioned above to work successfully. Once you are done and have your tick or cross in place, you can go back to the font you were using originally.

Using Autocorrect

One of the final ways to add a tick mark into your Excel sheet is through the autocorrect function. In fact, it's not just tick marks that you can enter - you can go for almost any symbol you'd like! Autocorrect is a feature of Excel where it can, as the term suggests, automatically correct words that have been misspelled.

As an example, you can demonstrate to yourself what happens when you type "bcak" (instead of "back") into Excel. Excel will automatically change the word to its correct spelling, and will change "bcak" into "back".

This occurs because there exists in the software a list that has already been prepared of words that people are most likely to spell incorrectly, and thus, Excel automatically checks and corrects these on your behalf.

You might want to add a symbol such as the delta symbol into your Excel project. These are the steps you can follow to do so:

Step 1: The first step is to click on the File tab.

Step 2: The second thing you need to do is to click on Options.

Step 3: Then, in the Options dialogue box, choose Proofing.

Step 4: After that, click on the button that says 'AutoCorrect Options'.

Step 5: Following this, in the AutoCorrect dialogue box, enter the following:

  • Replace: CMARK
  • With: ? (you can copy and paste this)

If you would like to enter any other symbol, paste that symbol instead. Below are some symbols that might catch your fancy - though there exists a plethora of these, and a quick Google search should give you what you want. Once you've identified the symbol you want, simply copy it from the site and paste into the "With" box. You can name each symbol as you want in the "Replace" box, for instance a delta symbol might be DELTA, and so on. We've given some suggestions below. What you name each symbol is subjective - it is basically just the text you need to type which will be replaced by your symbol of choice, so it's up to you what you would want to name them.

NOTE: However, it’s important you don’t name the symbols with very common words you use frequently. This is discussed in detail in this article; keep reading to find out!

  • Replace: CMARK ; With: ?
  • Replace: XMARK ; With: û
  • Replace: BSTAR ; With: ?
  • Replace: ARROWR ; With: è
  • Replace: ARROWL ; With: ç
  • Replace: FLOWERSYMBOL ; With: ?
  • Replace: CLOCK3 ; With: ¹

Step 6: The final step is to click Add, and then OK.

Now, whenever you type the word CMARK into a cell in Excel (in the case that you require a check mark), Excel will automatically change it into a check mark symbol.

The following tips are important to note when you use the Autocorrect method.

  • This technique is case sensitive. This means that it matters if you use small or capital letters. So, if you type "cmark" instead of "CMARK" into a cell, it won't convert the text into a check mark symbol. Therefore, make sure that what you type in the cell precisely matches what you had named the symbol, or what you had typed in the "Replace" box.
  • A convenient top tip is that this change gets applied to all your other Microsoft-powered applications! These include MS Word, PowerPoint, and so on. So applying a change in Excel will save you time in your other frequently used apps and you'll get the same result across other Microsoft software. However, this could go two ways. You might only
    want, for example, "CMARK" to be replaced by a tick symbol in Excel but not in Word. That's why it's important to be cautious and opt for keywords that you are not very likely to use in other applications. Now, "CMARK" is probably not a very common term you'd use in Word, but "tick" might be one, and so, choose what you name your symbols
    carefully.
  • If there is any form of text or number before CMARK, CMARK will not get converted to a check mark. For instance, '5%CMARK' will not get autocorrected and converted. A simple remedy is to just put a space after the text or number and then enter the word you'd like to be replaced by the symbol. In this case, '5% CMARK' will change to '5% ?’.

This is a highly useful technique if you want a quick and ready reference for the tick mark symbol and you use it very frequently in your work. Hence, by using this method, you no longer need to remember shortcuts or codes, or even to use the symbol dialogue box provided in the system. Instead, all you need to do is remember the short code name you kept and simply type that out as and when required. Plus, the method is so versatile you can use it for virtually any symbol!

Also published here.

Author profile picture

@5amily5amily

Read my stories

We are a well-established online store offering customized goods and merchandise for passionate people.

Tags

Join Hacker Noon

Create your free account to unlock your custom reading experience.