Inserting Symbols

Selecting (Insert > 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.


Symbols tab


 

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.


 


Not all the fonts support the Euro. Fonts that do support the Euro are Courier, Tahoma, Times and Arial.
List the common subsets


Alt + Number Pad

Alt +Symbol / Description
20
21
0128
0134
0135
0169
0174
0153
241
246
248
239
236
0185
253
0179
0188
0189
0190


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


Important

You can enter the Euro symbol by pressing Alt + 0128 (on the numerical keypad)
If you are not using Excel 2002 but are using an earlier version you can use the Windows Character Map program to obtain similar functionality (charmap.exe).


© 2017 Better Solutions Limited. All Rights Reserved. © 2017 Better Solutions Limited

Top

PrevNext