MS Excel 97 - Text formats

Vertical text
Wrap text in a cell
Text justification
Text colour

This is not a course. It is a...

Tip Sheet

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 to the right).

Click on Format
Click on Cells

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.

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 to the right).

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

Click on Format
Click on Cell

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:

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.

Click on OK