Sounds handy? Let's get our hands on this: We can tinker with the AutoCorrect settings to replace a keyword with a checkmark or even a cross mark. Autocorrection is automatic text replacement for spelling or typing errors. Insert Checkmark Using AutoCorrectĪutoCorrect needs no introduction but let's remind ourselves of its basic properties to see how we can use it for inserting checkmarks. Using the above keyboard shortcuts, we can get checkmarks and cross marks as text symbols. Before you do, change the font of the designated cell(s) to Wingdings 2 or Webdings font as per the below table. To quickly and easily add a checkmark, you can make use of keyboard shortcuts. You can also use the other Paste Options instead of going into cell edit mode.Īnd you should have your checkmark ready! Insert Checkmark Using Keyboard Shortcut
No frills, no strings, copy from here and paste to the cell where you want the checkmark: ✓ Insert Checkmark Using Copy Paste CheckmarkĪnd of course, the simple copy-paste. For punching them in, there are other options mentioned in the following sections. You can also use the boxed check and cross marks, whichever is the preference.īut every time you may not have data where you need to conditionally enter checks and crosses such as to-do lists. Here we have the results of this formula: The target sales figure is locked in the $ signs to keep it as a constant in the formula as the formula is dragged. This means that if the sales is greater than the target sales, return a checkmark. The function reads like this: If C6 is greater than C3, return CHAR(252). So, we will feed 252 into the CHAR function like so: The first step would be to change the font of the cells where the check and cross marks will be entered to Wingdings. With the Wingdings font, here are the codes that we need to feed in the CHAR function to arrive at a checkmark or a cross mark: Hence, we can have a checkmark as a text symbol using Wingdings and the CHAR function. A requirement is that the font of the cell must be set to Wingdingsas it is a symbol font. In this way, we can use the CHAR function to return a checkmark in Excel.
The CHAR function returns a character against a specific code entered in the function. Now that we've established that this guide is about checkmarks, let's explore many ways of adding them to our sheets. If you are looking to add checkboxes instead of checkmarks, check out our detailed guide on checkboxes here – Everything You Need to Know About Excel Checkboxes This also differs from a checkbox which can only be either checked or unchecked. A cross mark can also be used in the same way as a checkmark. And a deleted or moved cell will delete or move the checkmark with it). Being the content or part of the content of the cell, a checkmark is affected by the movement of the cell (a copy-pasted cell will also copy-paste the checkmark in it. That also means the checkbox can be freely moved anywhere on the sheet.Ī checkmark is a text symbol and therefore is part of a cell, like any text. Therefore, it sits above the cell as an object and is unaffected by the contents of the cell or movement/deletion of the cell. The graphical part of the checkbox clarifies that it isn't text and therefore not part of cell text and not part of a cell.