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

COMPUTER SKILLS AND TIP SHEETS
MS Excel 2000 - 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

 orient3.jpg (5346 bytes) 

orient2.jpg (34976 bytes)  

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

orient4.jpg (21569 bytes)  

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

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

Click on Format
Click on Cell

orient3.jpg (5346 bytes) 

wrap.jpg (7462 bytes)  

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

orient5.JPG (21272 bytes)  

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   just2.jpg (1076 bytes)  (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  downarrow.jpg (743 bytes)   to the right of the Font colour icon ictextclr.jpg (911 bytes)

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.