Home Excel How to Use Special Characters to Create Cute Shapes in Excel

How to Use Special Characters to Create Cute Shapes in Excel

by Kim Thu
A+A-
Reset

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.

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:

  1. Type a regular letter (A-Z, 0-9).
  2. 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.

  1. Go to Insert → Select Shapes.
  2. Insert circles, hearts, stars, etc.
  3. Use colors to decorate.

How to Use Special Characters to Create Cute Shapes in Excel

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

Related Posts

Leave a Comment