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?

Precede a word with Alt-Enter to force it to the next line. HTH Otto
"L.S." wrote in message
...
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?

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.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"L.S." wrote:

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?

thanks, got it.

"Otto Moehrbach" wrote in message
...

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

HTH Otto
"L.S." wrote in message
...
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?