Excel is not just a calculation tool; it can also create cute shapes using special characters. This guide will show you how to use Unicode characters, special fonts (Wingdings, Webdings), the CHAR() function, and how to insert illustrations.
Nội dung
1. Why Use Special Characters in Excel?
- Make tables more lively.
- Creative notes help make Excel less boring.
- Easy to share because images are not needed.
- Does not increase file size since it only uses text.
2. Ways to Create Cute Shapes Using Special Characters
2.1. Using Unicode Symbols
You can insert Unicode characters into Excel by copy-pasting or using the ALT + Unicode code combination.
| Symbol | Meaning | ALT Code | CHAR() |
|---|---|---|---|
| ♥ | Heart | ALT + 3 | =CHAR(3) |
| ☺ | Smiley Face | ALT + 1 | =CHAR(1) |
| ★ | Star | ALT + 9733 | =CHAR(9733) |
| ✿ | Flower | ALT + 10047 | =CHAR(10047) |
| ✔ | Checkmark | ALT + 10004 | =CHAR(10004) |
| ❌ | Cross | ALT + 10060 | =CHAR(10060) |
| ⏰ | Clock | ALT + 9200 | =CHAR(9200) |
| ✈ | Airplane | ALT + 9992 | =CHAR(9992) |
| Pin | ALT + 128204 | =CHAR(128204) |
|
| Fire | ALT + 128293 | =CHAR(128293) |
|
| Musical Note | ALT + 127925 | =CHAR(127925) |
|
| Trophy | ALT + 127942 | =CHAR(127942) |
|
| Telephone | ALT + 128222 | =CHAR(128222) |
Example: Typing =CHAR(9829) will display the ♥ character in Excel.
2.2. Using Wingdings & Webdings Fonts
Wingdings and Webdings contain many unique symbols. To use them:
- Type a regular letter (A-Z, 0-9).
- Change the font to Wingdings or Webdings.
| Character | Wingdings | Webdings |
|---|---|---|
| J | (smile) | (email) |
| L | ☹️ (sad) | (prohibited) |
| N | ⚠️ (warning) | (folder) |
| a | ✉ (letter) | ✈ (airplane) |
| g | ☎ (telephone) | (house) |
| r | ✂ (scissors) | (pen) |
2.3. Create Cute Shapes Using ASCII Art
ASCII Art lets you design cute shapes directly in Excel.
Example: Cute Bunny
(\_/)
(•_•)
(><)
Example: Cute Kitten
/\_/\
( o.o )
> ^ <
Example: Cute Bear
(￣(エ)￣)
(o◕(ェ)◕o)
Example: Christmas Tree
*
***
*****
*******
*********
|||
Example: Smiley Face
:-)
(^_^)
(•‿•)
(｡♥‿♥｡)
Tip:
- Set the font to Courier New to maintain the formatting.
- Use merge cells to create larger shapes.
2.4. Using Shapes & Symbols
For more creativity, you can combine with Insert > Shapes to draw shapes.
- Go to Insert → Select Shapes.
- Insert circles, hearts, stars, etc.
- Use colors to decorate.
Conclusion
Using special characters in Excel makes your spreadsheets more lively and creative. Try out the methods above to create cute shapes and make working in Excel more fun!
Do you have any other tips? Share them in the comments!
See more: Summary of 10 Essential Excel Functions Accountants Shouldn’t Ignore