|
Physics Laboratory
|
|
Excel Tutorial #5
|
You will often find it convenient to display symbols such as
a, b, D, p, @ and ± within your
worksheet. Depending on which symbols you wish to display,
there are at least two methods of doing so.
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 ÷ can 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?
If you have a question or comment, send an e-mail to
.
|
|