PhysicsLaboratory ExcelTutorial#5

 4. AlgebraE Displaying Symbols 6. TrigonometryF

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 createthis character ... Change the fontto "Symbol" andtype 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 createthis character ... Change the fontto "Symbol" andtype 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 createthis character ... Press the key while typingthis number ... ° (degree) 0176 ± 0177 0185 × 0180 ÷ 0184 0165
 To createthis character ... Press the key while typingthis 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 .

 4. AlgebraE 6. TrigonometryF