Tutorial 05

Displaying symbols

Adding Greek letters, math symbols, arrows etc in Excel

 

back to algebra

on to trigonometry

You will often find it convenient to display symbols such α, β, γ, @, ±, or ‰ within your worksheet.

Mac users: Select theVIEW menu >> OBJECT PALLETTE.

Select the SYMBOL tab and a series of different symbols will be present. Click on the symbol you want to insert.

PC users: Depending on which symbols you wish to display, select one of the two methods described below.

 


With the first method you can simply change the font face to Symbol and type the appropriate letter. For example, to display the Greek letter alpha, a, first type the letter "a". Then highlight the letter and change the font to "Symbol". That's all there is to that method.

Below are some of the characters you can display by changing the font to "Symbol".

To create
this character ...
Change the font
to "Symbol" and
type this letter ...
a a
b b
d d
f f
g g
l l
m m
n n
p p
q q
r r
s s
t t
w w
To create
this character ...
Change the font
to "Symbol" and
type this letter ...
C C
D D
F F
G G
L L
P P
Q Q
S S
W W
@ @
^ ^
\ \

 


Unfortunately not every character you will wish to use can be displayed with the above method. Some characters like, ° (degree), ±, × and ÷ must be displayed by using a second method.

To get these and certain other characters to appear in your worksheet, press the <ALT> key while you use the numeric keypad to type in the appropriate numerical code. For example, in order to create the degree symbol ( ° ), press the <ALT> key while you type 0176 with the numeric keypad, not the number keys on the main keyboard.

Below are some of the characters you can display with the <ALT>+number method.

To create
this character ...
Press the <ALT>
key while typing
this number ...
° (degree) 0176
± 0177
0185
× 0180
÷ 0184
0165
To create
this character ...
Press the <ALT>
key while typing
this number ...
0163
0179
0187
0186
0209
0182

Note that the numbers entered above must be entered with the numeric keypad, not the main keyboard!

To the right is a worksheet example using the two methods described above to create symbols and Greek letters. Can you reproduce it?

 

 

 

back to algebra

on to trigonometry

Copyright © 2000, St. Mary's College of Maryland. All Rights Reserved.

Please send comments, problems or request for topics to

Walter I. Hatch
wihatch@smcm.edu
August 11, 2005