Inserting Symbols

Selecting (Insert Tab, Symbol) will give you the complete character set for every font installed font on your PC.
This dialog box makes it very easy to insert special symbols and characters into cells.
It is important to remember that each font has a different set of special characters.
Not all the fonts support the Euro. Fonts that do support the Euro are Courier, Tahoma, Times and Arial.

Symbols tab

microsoft excel docs

Font - Select the font you want to use to display your character or symbol
Subset - Allows you to jump to specific areas in the character set:
Basic Latin, Latin-1 Supplement, Latin Extended-A, Latin Extended-B, Spacing Modifier Letters, Greek and Coptic, General Punctuation, Currency Symbols, Letterlike Symbols, Mathematical Operators, Geometric Shapes, Private Use Area
Character Code - Displays the code of the currently selected character. You can choose from displaying the code in either Unicode hex, ASCII decimal or ASCII hex.

Special Characters tab

This gives you access a number of commonly used special characters such as the trademark and copyright symbols.
These characters will be left aligned by default.

microsoft excel docs

Alt + Number Pad

Alt +Symbol / Description
20Paragraph - ¶
21Section - §
0128Euro - €
0169Copyright - ©
0174Registered - ®
0153Trademark - ™
0185Subscript 1 - ¹
0178Subscript 2 - ²
0179Subscript 3 - ³
0188Quarter - ¼
0189Half - ½
0190Three Quarters - ¾

Greek Letters

Alt +Symbol / Description
224Alpha - à
225Beta - á
226Gamma - â
235Delta - ë
238Epsilon - î
233Theta - é
227Pi - ã
230Mu - æ
228Uppercase Sigma - ä
229Lowercase Sigma (or select upper case and use Shift + F3 to change case) - å
231Tau - ç
232Uppercase Phi - è
237Lowercase Phi - í
234Omega - ê


You can enter the Euro symbol by pressing Alt + 0128 (on the numerical keypad)

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext