How to Insert a Check Mark (Tick Symbol) in Excel

How to Insert a Check Mark (Tick Symbol) in Excel

HomeOther ContentHow to Insert a Check Mark (Tick Symbol) in Excel
ChannelPublish DateThumbnail & View CountActions
Channel AvatarPublish Date not found Thumbnail
0 Views
Learn how to insert a check mark (tick symbol) in Excel using 5 different methods. See below to jump to specific points in the video.

CHECK MARK AND OTHER SYMBOLS TO COPY AND PASTE:
◀ ▶ ± × ÷ ° ℉ ℃ ∅

0:00 Method 1: Use the Windows 10 Emoji Panel Keyboard Shortcut
0:42 Make it a green tick symbol by changing the font color
0:54 Method 2: Use the Insert ▷ Symbol tool
1:30 Method 3: Copy and Paste from a web page to insert a symbol in excel
1:52 Method 4: Use AutoCorrect to change /”(check)/” to /”/”
2:44 Method 5: Use the =UNICHAR(10004) formula
3:04 Bonus 1: Create a drop down to easily select a check mark
3:31 Bonus 2: Use =IF() to display a /”/” or /”/”

Remember to Subscribe for more excel tips and tricks, excel shortcuts, and excel tutorials.

This video is based on the article /”Using Unicode Character Symbols in Excel,/” by Vertex42.com. Read the full article here:
https://www.vertex42.com/blog/help/excel-help/using-unicode-character-symbols-in-excel.html

FOLLOW VERTEX42 HERE:
Instagram: https://www.instagram.com/vertex42/
Facebook: https://www.facebook.com/vertex42/
Pinterest: https://www.pinterest.com/vertex42/
Twitter: https://twitter.com/vertex42

MUSIC: Pixelate, by Zac Nelson, licensed via ArtList

Please take the opportunity to connect and share this video with your friends and family if you find it useful.