In this video, I will show you seven ways to insert and use a checkmark symbol (Tick mark) in Excel.
The following methods of inserting a checkmark symbol in Excel are covered in this video:
1) Copy and Paste the Check Mark (✓)
2) Use the Keyboard Shortcuts
3) Using the Symbols Dialog Box
4) Using the CHAR Formula
5) Using Autocorrect
6) Using Conditional Formatting to Insert Check Mark
7) Using a Double-Click (uses VBA)
A checkmark symbol is different than a checkbox. While a checkbox is an object that floats over the worksheet, a checkmark is a part of the cell and is entered just like you enter the text. This means that you can format the checkmark by changing its size, color, or font type.
The easiest way to insert a checkmark in Excel is to simply copy it and paste it. Although this is a manual process, it can be great when you only want a few of these checkmarks/tick marks.
Below is a checkmark (tick mark) symbol and you can copy and paste in Excel:
✓
You also have keyboard shortcuts in Excel that you can use to insert a checkmark directly into the cell. Note that these keyboard shortcuts will work only when you change the cell formatting to Wingdings or Wingdings 2.
You can also use the CHAR formula to get the checkmark symbol in Excel. This function uses the ANSI code of the checkmark symbol and gives you the corresponding character, For this to work, you need to change the cell formatting to Wingdings.
The good thing about using a formula is that it allows you to get the result based on the cell value. For example, you can get the checkmark if the cell value crosses the 200-mark (example covered in the video).
Autocorrect is another way to insert a checkmark symbol by adding an autocorrect text. For example, you can create a system where as soon as you enter ‘cmark’ and hit the space key, it would automatically convert the ‘cmark’ to a checkmark. The exact process is covered in the video.
Conditional Formatting is another method covered in the video. You can quickly get the checkmark (tick mark) or the cross mark based on the cell value. To do this, you need to apply conditional formatting icons to the cells that have the values.
And the last method covered in this video is using VBA to automatically insert a checkmark as soon as you double-click on a cell. This works by adding a short VBA code in the Excel workbook. Once the code is copied, when you double click on any cell in the specified column, it would automatically insert the checkmark and when you double-click again, it would remove it.
Below the VBA code that does this (exact steps to copy the code in the VB Editor is shown in the video):
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Target.Column = 2 Then
Cancel = True
Target.Font.Name = “Wingdings”
If Target.Value = “” Then
Target.Value = “ü”
Else
Target.Value = “”
End If
End If
End Sub
Remember to save the workbook as an Excel macro-enabled workbook.
You can read more about this tutorial here: https://ift.tt/2JsICCa
⚡ Subscribe to this YouTube channel to get updates on Excel Tips and Excel Tutorials videos – https://www.youtube.com/c/trumpexcel
📌 This YouTube channel is managed by Sumit Bansal (who also runs the TrumpExcel website).
This channel is meant for people who want to learn Excel. It covers a lot of Excel basics and advanced Excel topics such as Excel Formulas, Functions, Pivot Table, Shortcuts, Excel VBA, Macros, Excel Dashboards, Excel Charts, Conditional Formatting, Power Query, etc.
⚡ Please subscribe to this channel to be the first to know when new Excel tutorials come out – https://www.youtube.com/c/trumpexcel
You can find a lot of useful Excel resources on the following site: https://trumpexcel.com/
#Excel #ExcelTips #ExcelTutorial