Channel | Publish Date | Thumbnail & View Count | Actions |
---|---|---|---|
| Publish Date not found | ![]() 0 Views |
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.