align text??

[L.S.]

Winxp(home) Office(excel) 2k.

Is there a way to align text vertically in a cell?
Under format cell and alignment tab, I can align Right and then Justify but
I need more control.
Ex: This is a test.

I can get;
This This is
is a or a test.
test.

but need;
This
is
a
test.

Any way to do this?

 

[Otto Moehrbach]

Precede a word with Alt-Enter to force it to the next line. HTH Otto

 

[Shane Devenshire]

Hi,

go back to the Alignment tab of the Format Cells dialog box and look on the
right side of the window. There are a number of options for alignining
vertically. There is also a vertical align in the drop down below Horizontal
on that page. Further you can use word wrap in some cases.

 

[L.S.]

thanks, got it.

Precede a word with Alt-Enter to force it to the next line.

HTH Otto