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.

Highlight the cells (see example below).

Click on Format in the Cells group
Click on Format Cells

Check that you are working in the Alignment tab

Change the text orientation to 90 degrees (drag the red point of the arrow to the required angle),

or type in the specific angle of your choice if you want the text to slant (see circled area above)

Click on OK

The text is now vertically orientated. 

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- the text Grade 8 A Class Test does not fit in cell A1 ).

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

Click on Format in the Cells group
Click on Format Cell

Check that the Alignment tab is active

Click on the white square next to Wrap text (encircled in the above image). 

or you can slect the text you want to wrap and then click the icon in the Alignment groups.

Your text should appear like this:

Text justification

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

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

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

It is also possible to vertically align text.

Use the following icons from the Alignment group.

Text colour

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

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

Select a colour from the options in the pull down menu. Your text will be chnaged to that colour.