This is not a course. It is a... Tip Sheet

COMPUTER SKILLS AND TIP SHEETS
MS Excel 2002 - Text formats

 

 Vertical text

In the example to the right you will notice that the text in cells B3 and C3 do not fit into the cell width. One way of overcoming this would be to increase the cell width, but then the cell may become too wide.

 orient1.jpg (32949 bytes)  

Highlight the cells (see example to the right).

Click on Format
Click on Cells
Click on Alignment

  

  

Change the text orientation to 90 degrees, or any angle of your choice if you want the text to slant (see circled area in the example to the right).

Click on OK

  

The text is now vertically orientated. 

orient6.jpg (21848 bytes)  

Wrap text in cell

If you have too much text to fit into a reasonable cell width, you could get the text to wrap as if the cell is a mini-page (see example below).

Select the cell(s) in which you wish to wrap text.

Click on Format
Click on Cell
Click on Alignment

 

wrap.jpg (7462 bytes)  

Click on the white circle next to Wrap text (encircled in the image to the right). 

  

Text justification

Justification is the horizontal position of the text in a cell, as shown here:

just1.jpg (2600 bytes)

Select the cells in which you wish to change the justification.

Use the icons     (left, centre and right justify icons respectively)  

Text colour

Select the text for which you wish to change the text colour.

Click on the little black down arrow   to the right of the Font colour icon

Choose a colour from the options in the pull down menu.

txtclr.jpg (9637 bytes)

Click on OK

                                           The Educators' Network



Copyright SchoolNet SA and SCOPE. All Rights Reserved.